· 4 years ago · May 21, 2021, 08:34 AM
1create table if not exists property.lobbies
2(
3 id varchar(64) not null
4 constraint lobbies_pk
5 primary key,
6 floor_id varchar(64)
7 constraint lobbies_floors_id_fk
8 references property.floors,
9 lobby_name varchar(100),
10 active boolean default true,
11 created_by varchar(64),
12 updated_by varchar(64),
13 created_date timestamp,
14 updated_date timestamp,
15 search tsvector
16);
17
18alter table property.lobbies owner to beni;
19
20create unique index if not exists lobbies_id_uindex
21 on property.lobbies (id);
22
23