Skip to content

Latest commit

 

History

History
49 lines (36 loc) · 2.31 KB

codes.type_of_underground.md

File metadata and controls

49 lines (36 loc) · 2.31 KB

codes.type_of_underground

Description

Columns

Name Type Default Nullable Children Parents Comment
value varchar false
short_name varchar ''::character varying false
name jsonb '{"eng": "", "fin": "", "swe": ""}'::jsonb false
description jsonb '{"eng": "", "fin": "", "swe": ""}'::jsonb false
status varchar false
level integer 1 false
parent_id uuid true codes.type_of_underground
id uuid gen_random_uuid() false codes.type_of_underground hame.land_use_area hame.land_use_point hame.line hame.other_area hame.other_point
created_at timestamp without time zone now() false
modified_at timestamp without time zone now() false

Viewpoints

Name Definition
All tables All tables that make up maakuntakaava plan data.

Constraints

Name Type Definition
type_of_underground_parent_id_fkey FOREIGN KEY FOREIGN KEY (parent_id) REFERENCES codes.type_of_underground(id)
type_of_underground_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
type_of_underground_pkey CREATE UNIQUE INDEX type_of_underground_pkey ON codes.type_of_underground USING btree (id)
ix_codes_type_of_underground_level CREATE INDEX ix_codes_type_of_underground_level ON codes.type_of_underground USING btree (level)
ix_codes_type_of_underground_parent_id CREATE INDEX ix_codes_type_of_underground_parent_id ON codes.type_of_underground USING btree (parent_id)
ix_codes_type_of_underground_value CREATE UNIQUE INDEX ix_codes_type_of_underground_value ON codes.type_of_underground USING btree (value)
ix_codes_type_of_underground_short_name CREATE INDEX ix_codes_type_of_underground_short_name ON codes.type_of_underground USING btree (short_name)

Relations

er


Generated by tbls