• Home
• org.beangle.ems
• beangle-ems-core_3
• 4.8.7
• source code
• 4-constraints.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.postgresql.init.4-constraints.sql Maven / Gradle / Ivy

alter table ems.blb_blob_metas add constraint fk_d3yxkna364mf4mkit1c43alo3 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.blb_blob_metas add constraint fk_fwsivfrcv3dueipw2679kvikl foreign key (profile_id) references ems.blb_profiles (id);
alter table ems.blb_profiles add constraint fk_e60r4lcpbwolub0gn2xetoolo foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.cfg_app_groups add constraint fk_is79tynyqwd3tjp6imw4waxa2 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.cfg_apps add constraint fk_63b8qir7o0ra6nvjgbdxom1xp foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.cfg_apps add constraint fk_e9dlk79vqcr6h7s4j94xd3ur2 foreign key (group_id) references ems.cfg_app_groups (id);
alter table ems.cfg_apps add constraint fk_oyclhhl4b5hmp6irr0gcs9xbx foreign key (app_type_id) references ems.cfg_app_types (id);
alter table ems.cfg_credentials add constraint fk_83dcjrkal5a4f5caten4qsov0 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.cfg_data_sources add constraint fk_bdy20umf8o7qawut9sttmynfj foreign key (db_id) references ems.cfg_dbs (id);
alter table ems.cfg_data_sources add constraint fk_lkns1b89bk1r1gtftfflnl1r5 foreign key (credential_id) references ems.cfg_credentials (id);
alter table ems.cfg_data_sources add constraint fk_rncmj0cj4iyxjolva8oviqk4w foreign key (app_id) references ems.cfg_apps (id);
alter table ems.cfg_dbs add constraint fk_tcq34ws060gnkcrmxw5ik8y19 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.cfg_dbs_properties add constraint fk_2v5t7l6nx0rw0e4s5uqqs6nha foreign key (db_id) references ems.cfg_dbs (id);
alter table ems.cfg_domains add constraint fk_sv9p6l4dip3iufo95oq8moq7s foreign key (org_id) references ems.cfg_orgs (id);
alter table ems.cfg_files add constraint fk_dol7duk700r2xmhltnqw2yac4 foreign key (app_id) references ems.cfg_apps (id);
alter table ems.cfg_portalets_categories add constraint fk_1wyav9ml67vi1urrrm6ri1w9o foreign key (category_id) references ems.usr_categories (id);
alter table ems.cfg_portalets_categories add constraint fk_4vtds4chbhscr97qd4c8o3qo1 foreign key (portalet_id) references ems.cfg_portalets (id);
alter table ems.log_business_logs add constraint fk_62sjh37y9se42o14o2yuohkvx foreign key (level_id) references ems.log_levels (id);
alter table ems.log_business_logs add constraint fk_rrpr22e7bp9a61fov2yqs107l foreign key (app_id) references ems.cfg_apps (id);
alter table ems.log_session_events add constraint fk_m0p65dq2hujn1as3ayowmg63d foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.oa_docs add constraint fk_90rt2b8ko9dtmfagl9j5jkdj5 foreign key (upload_by_id) references ems.usr_users (id);
alter table ems.oa_docs add constraint fk_t2qoocyx1xwbyo7ex0ii8hlij foreign key (app_id) references ems.cfg_apps (id);
alter table ems.oa_docs_categories add constraint fk_5yuw0si9jf4m36tb23ngmbjuj foreign key (category_id) references ems.usr_categories (id);
alter table ems.oa_docs_categories add constraint fk_c6dgseyhj0qohbadwxf5utpqq foreign key (doc_id) references ems.oa_docs (id);
alter table ems.oa_messages add constraint fk_3u7wk80g0cui9ra3twa6scw36 foreign key (recipient_id) references ems.usr_users (id);
alter table ems.oa_messages add constraint fk_nilhuywf0n9f5t8200g70rvn4 foreign key (sender_id) references ems.usr_users (id);
alter table ems.oa_news add constraint fk_sa7idffyughpqt5fso3n95y77 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.oa_notices add constraint fk_9ynb83bqk81v1f63byns5varx foreign key (app_id) references ems.cfg_apps (id);
alter table ems.oa_notices add constraint fk_en5a6ud40d1v0nd77y7vonh2p foreign key (operator_id) references ems.usr_users (id);
alter table ems.oa_notices add constraint fk_liq6cinvsbnvimuij51bi9cc9 foreign key (auditor_id) references ems.usr_users (id);
alter table ems.oa_notices_categories add constraint fk_9w0mcwh7o7n8ic5ptskrlo7ui foreign key (category_id) references ems.usr_categories (id);
alter table ems.oa_notices_categories add constraint fk_sw9cowmvwom37orfr3mbeu7nu foreign key (notice_id) references ems.oa_notices (id);
alter table ems.oa_notices_docs add constraint fk_1guanblq93x0s91s091w2wjb5 foreign key (doc_id) references ems.oa_docs (id);
alter table ems.oa_notices_docs add constraint fk_51mr3j8mjh6edbuoa9ktvsl08 foreign key (notice_id) references ems.oa_notices (id);
alter table ems.oa_notifications add constraint fk_gape9e9p6ep3pc4ausb5b11c5 foreign key (recipient_id) references ems.usr_users (id);
alter table ems.oa_sensitive_words add constraint fk_bvusulink71q1pbjckap6cqaw foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.oa_todoes add constraint fk_a4r41j3r11fk2kdxhadlyp730 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.oa_todoes add constraint fk_bw0bv219t3rs9h4xgycxu1kb5 foreign key (user_id) references ems.usr_users (id);
alter table ems.se_app_permissions add constraint fk_56n4sdkcac0n09w0qatuiryog foreign key (resource_id) references ems.se_func_resources (id);
alter table ems.se_app_permissions add constraint fk_5g13fgs1ppr4cwbs73uf27ny foreign key (app_id) references ems.cfg_apps (id);
alter table ems.se_data_permissions add constraint fk_3iigcb47b6u4lk7600qu9mped foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.se_data_permissions add constraint fk_8m9d4petjo64ktvo773itnyg8 foreign key (resource_id) references ems.se_data_resources (id);
alter table ems.se_data_permissions add constraint fk_9qysha56tkvqd1vxq7yabsnft foreign key (func_resource_id) references ems.se_func_resources (id);
alter table ems.se_data_permissions add constraint fk_ftnaay414xukmne6di331jcy0 foreign key (role_id) references ems.usr_roles (id);
alter table ems.se_data_permissions add constraint fk_jssv5ly5wjo02pvfmfputfqg3 foreign key (app_id) references ems.cfg_apps (id);
alter table ems.se_data_resources add constraint fk_dk50vpqsida5h1271dv47imk6 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.se_func_permissions add constraint fk_6f381rw1cmkb200ben5c76o foreign key (role_id) references ems.usr_roles (id);
alter table ems.se_func_permissions add constraint fk_ao9ut2csq2k21nx7e8t2bjeuj foreign key (resource_id) references ems.se_func_resources (id);
alter table ems.se_func_resources add constraint fk_3ju8wtwtb6byhutjnfgej46ss foreign key (app_id) references ems.cfg_apps (id);
alter table ems.se_menus add constraint fk_9j0v9w5h4bij1ajoh8febi4wh foreign key (entry_id) references ems.se_func_resources (id);
alter table ems.se_menus add constraint fk_m6o2fdnpl1ngm724sdy6gmptb foreign key (app_id) references ems.cfg_apps (id);
alter table ems.se_menus add constraint fk_sk5i2hu25xymere80g1rbn7uv foreign key (parent_id) references ems.se_menus (id);
alter table ems.se_menus_resources add constraint fk_13cr2f0yryioqbo09judu50df foreign key (func_resource_id) references ems.se_func_resources (id);
alter table ems.se_menus_resources add constraint fk_eyl6aveotnavrf99odfsnwt2b foreign key (menu_id) references ems.se_menus (id);
alter table ems.se_session_configs add constraint fk_1lninitsqmbijgecrywhb88e6 foreign key (category_id) references ems.usr_categories (id);
alter table ems.se_session_configs add constraint fk_45ijj5mugsun1xt93tnqfsnh7 foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_accounts add constraint fk_hwy5rqywnccgsdkylphw79b5c foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_accounts add constraint fk_iybd37kqrrs1wcewrt87r6ecy foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_avatars add constraint fk_b5t09f57obh37di4c60bq9oab foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_categories add constraint fk_942y0yyte37hk7g2rtbsmw9a7 foreign key (org_id) references ems.cfg_orgs (id);
alter table ems.usr_dimensions add constraint fk_n554u52g2602fpj6o4pskw8gs foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_group_members add constraint fk_6f8eyjnx907a0gl1abag7tn7w foreign key (group_id) references ems.usr_groups (id);
alter table ems.usr_group_members add constraint fk_ohao01ximhmcf5q77sladwu6u foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_groups add constraint fk_a21ym9fl383pw06xqh8g508qu foreign key (parent_id) references ems.usr_groups (id);
alter table ems.usr_groups add constraint fk_bjd8utlg5suh7lll0rhp7x9ku foreign key (org_id) references ems.cfg_orgs (id);
alter table ems.usr_groups add constraint fk_gvggc1045nj9bouvqmmu3aje2 foreign key (creator_id) references ems.usr_users (id);
alter table ems.usr_groups_properties add constraint fk_ss67lgormbaehgmqlga9rfuji foreign key (group_id) references ems.usr_groups (id);
alter table ems.usr_password_configs add constraint fk_9oli46aiaibkpa2wftgsweqsb foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_profiles add constraint fk_ipf6f03qoljh8ahtb6s1foudm foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_profiles add constraint fk_okkg9hdpvau3u2r7uanfl66y foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_profiles_properties add constraint fk_hc3opa4vag30nnpi4itrq2fr8 foreign key (profile_id) references ems.usr_profiles (id);
alter table ems.usr_role_members add constraint fk_4ginknwrhsxxncy15fwierbyq foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_role_members add constraint fk_bm1ix1rci332yc9xjselvkltl foreign key (role_id) references ems.usr_roles (id);
alter table ems.usr_roles add constraint fk_48rf6jlralqywk4om6yw478kq foreign key (parent_id) references ems.usr_roles (id);
alter table ems.usr_roles add constraint fk_k72k7td9qiw0c42wj3cbqe1wt foreign key (creator_id) references ems.usr_users (id);
alter table ems.usr_roles add constraint fk_s4bgp91kk8g9asdwmg60k2dwl foreign key (domain_id) references ems.cfg_domains (id);
alter table ems.usr_roles_properties add constraint fk_f66m6ftj0kpr837j9dtewnop8 foreign key (role_id) references ems.usr_roles (id);
alter table ems.usr_roots add constraint fk_akxow8uv93shp0ukqwgnqjs99 foreign key (app_id) references ems.cfg_apps (id);
alter table ems.usr_roots add constraint fk_o5eita87yogy8ancda49b13f0 foreign key (user_id) references ems.usr_users (id);
alter table ems.usr_users add constraint fk_owno1cqcdeihlygy0qlwpw0qp foreign key (org_id) references ems.cfg_orgs (id);
alter table ems.usr_users add constraint fk_rvydc53ioy9f11rhg7pmts3rr foreign key (category_id) references ems.usr_categories (id);