CREATE TABLE ais_ksodd.divisions (
    id int4 NOT NULL,
    "name" varchar NULL,
    geom geometry NULL,
    CONSTRAINT divisions_pk PRIMARY KEY (id)
)
WITH (
    OIDS=FALSE
) ;
CREATE INDEX sidx_divisions ON ais_ksodd.divisions USING gist (geom) ;

CREATE TABLE ais_ksodd.signs (
    guid uuid NOT NULL,
    division int4 NULL,
    district int4 NULL,
    street int4 NULL,
    segment int4 NULL,
    group_id uuid NULL,
    "number" int4 NULL,
    "type" int4 NULL,
    bilateral bool NULL,
    status int4 NULL,
    height int4 NULL,
    visibility varchar NULL,
    defects varchar NULL,
    install_type int4 NULL,
    angle float8 NULL,
    mirror bool NULL,
    performed_info bool NULL,
    p1 varchar NULL,
    p2 varchar NULL,
    p3 varchar NULL,
    p4 varchar NULL,
    p5 varchar NULL,
    geom geometry NULL,
    created_at timestamp NULL,
    updated_at timestamp NULL,
    created_by varchar NULL,
    updated_by varchar NULL,
    deleted bool NULL DEFAULT false,
    CONSTRAINT signs_pk PRIMARY KEY (guid),
    CONSTRAINT signs_divisions_fk FOREIGN KEY (division) REFERENCES ais_ksodd.divisions(id)
)
WITH (
    OIDS=FALSE
) ;
CREATE INDEX sidx_signs ON ais_ksodd.signs USING gist (geom) ;


insert into ais_ksodd.divisions(id, name) values(1, 'ЦАО');

insert into ais_ksodd.signs (guid, division, geom) values (uuid_generate_v4(), 1, ST_GeomFromText('POINT (37.6747668808994 55.7338888791742)', 4326));