28 "deleted" boolean not null |
28 "deleted" boolean not null |
29 ); |
29 ); |
30 create sequence "code_list_item_id_seq"; |
30 create sequence "code_list_item_id_seq"; |
31 -- indexes on code_list_item |
31 -- indexes on code_list_item |
32 create index "code_list_item_code_list_idx" on "code_list_item" ("code_list"); |
32 create index "code_list_item_code_list_idx" on "code_list_item" ("code_list"); |
|
33 create table "user" ( |
|
34 "name" varchar(100) not null, |
|
35 "id" bigint primary key not null, |
|
36 "note" varchar(10240), |
|
37 "login" varchar(40) not null, |
|
38 "deleted" boolean not null, |
|
39 "active" boolean not null, |
|
40 "password" varchar(128) not null |
|
41 ); |
|
42 create sequence "user_id_seq"; |
|
43 -- indexes on user |
|
44 create index "user_login_idx" on "user" ("login"); |
33 create table "city" ( |
45 create table "city" ( |
34 "name" varchar(100) not null, |
46 "name" varchar(100) not null, |
35 "id" bigint primary key not null, |
47 "id" bigint primary key not null, |
36 "country_id" bigint not null, |
48 "country_id" bigint not null, |
37 "note" varchar(10240) |
49 "note" varchar(10240) |
94 alter table "address" add constraint "addressFK1" foreign key ("city_id") references "city"("id"); |
106 alter table "address" add constraint "addressFK1" foreign key ("city_id") references "city"("id"); |
95 alter table "city" add constraint "cityFK2" foreign key ("country_id") references "country"("id"); |
107 alter table "city" add constraint "cityFK2" foreign key ("country_id") references "country"("id"); |
96 alter table "company" add constraint "companyFK3" foreign key ("address_id") references "address"("id"); |
108 alter table "company" add constraint "companyFK3" foreign key ("address_id") references "address"("id"); |
97 alter table "company" add constraint "companyFK4" foreign key ("corresp_address_id") references "address"("id"); |
109 alter table "company" add constraint "companyFK4" foreign key ("corresp_address_id") references "address"("id"); |
98 alter table "bank_account" add constraint "bank_accountFK5" foreign key ("company_id") references "company"("id"); |
110 alter table "bank_account" add constraint "bank_accountFK5" foreign key ("company_id") references "company"("id"); |
|
111 -- column group indexes : |
|
112 create index "user_deleted_active_idx" on "user" ("deleted","active"); |