| 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.plan_type | |||
| id | uuid | gen_random_uuid() | false | hame.plan codes.plan_type | ||
| created_at | timestamp without time zone | now() | false | |||
| modified_at | timestamp without time zone | now() | false |
| Name | Definition |
|---|---|
| All tables | All tables that make up maakuntakaava plan data. |
| Name | Type | Definition |
|---|---|---|
| plan_type_parent_id_fkey | FOREIGN KEY | FOREIGN KEY (parent_id) REFERENCES codes.plan_type(id) |
| plan_type_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| plan_type_pkey | CREATE UNIQUE INDEX plan_type_pkey ON codes.plan_type USING btree (id) |
| ix_codes_plan_type_level | CREATE INDEX ix_codes_plan_type_level ON codes.plan_type USING btree (level) |
| ix_codes_plan_type_parent_id | CREATE INDEX ix_codes_plan_type_parent_id ON codes.plan_type USING btree (parent_id) |
| ix_codes_plan_type_value | CREATE UNIQUE INDEX ix_codes_plan_type_value ON codes.plan_type USING btree (value) |
| ix_codes_plan_type_short_name | CREATE INDEX ix_codes_plan_type_short_name ON codes.plan_type USING btree (short_name) |
Generated by tbls