Metada för skador

CREATE TABLE skfab.damage_places (

damage_place_id int4 NOT NULL DEFAULT nextval('skfab.damage_places_damage_place_id'::regclass),

customer_link int4 NULL,

status int4 NOT NULL,

"name" text NOT NULL,

"comment" text NULL,

created_user_uuid varchar(36) NULL,

changed_date timestamp NOT NULL,

changed_user_uuid varchar(36) NULL,

created_date timestamp NOT NULL,

geometry geometry(MULTIPOLYGON, 4326) NULL,

CONSTRAINT damage_places_pkey PRIMARY KEY (damage_place_id)

);

CREATE INDEX damage_places_gix ON skfab.damage_places USING gist (geometry);