Untitled

create table if not exists public.bql_e_coordinate
(
    id              integer default nextval('e_coordinates_id_seq'::regclass) not null,
    geometry_wgs84  geometry,
    active          boolean default true,
    geometry_vn2000 geometry,
    e_id            integer,
    documented      boolean
);

comment on column public.bql_e_coordinate.documented is 'shows coordinates drawn by hand or inputed officially';

alter table public.bql_e_coordinate
    owner to "cholimex-vl-dev";

create table if not exists public.bql_layer_entity_type
(
    layer_id       integer not null,
    entity_type_id integer not null,
    constraint layer_entity_type_pk
        primary key (layer_id, entity_type_id)
);

alter table public.bql_layer_entity_type
    owner to "cholimex-vl-dev";

create table if not exists public.bql_entity_ho_so
(
    id            serial
        primary key,
    trich_yeu     text,
    entity_id     integer,
    ngay_ban_hanh bigint,
    duong_dan     varchar,
    hien_trang_id integer
);

alter table public.bql_entity_ho_so
    owner to "cholimex-vl-dev";

create table if not exists public.fw_user
(
    id                        serial
        constraint fw_user_pk
            primary key,
    email                     varchar(100)                not null,
    last_name                 varchar(200),
    first_name                varchar(100),
    image                     varchar(200),
    password                  varchar(100)                not null,
    is_staff                  boolean       default false,
    is_shareholder            boolean       default false,
    cmnd_cccd                 varchar(20)   default ''::character varying,
    dia_chi                   varchar(1000) default ''::character varying,
    so_dien_thoai             varchar(20)   default ''::character varying,
    so_co_phan                integer       default 0,
    so_co_phan_in             integer       default 0,
    ma_co_phan                varchar(10),
    xac_nhan_tham_gia_dai_hoi boolean       default false,
    duoc_uy_quyen             boolean       default false not null,
    cmnd_cccd_noi_cap         text          default ''::text,
    cmnd_cccd_ngay_cap        bigint,
    token                     varchar(20),
    active                    boolean       default false
);

alter table public.fw_user
    owner to "cholimex-vl-dev";