hame.organisation.md

hame.organisation

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
name	jsonb	'{"eng": "", "fin": "", "swe": ""}'::jsonb	false
business_id	varchar		false
id	uuid	gen_random_uuid()	false	hame.plan
created_at	timestamp without time zone	now()	false
modified_at	timestamp without time zone	now()	false
administrative_region_id	uuid		false		codes.administrative_region

Viewpoints

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

Constraints

Name	Type	Definition
organisation_pkey	PRIMARY KEY	PRIMARY KEY (id)
administrative_region_id_fkey	FOREIGN KEY	FOREIGN KEY (administrative_region_id) REFERENCES codes.administrative_region(id)

Indexes

Name	Definition
organisation_pkey	CREATE UNIQUE INDEX organisation_pkey ON hame.organisation USING btree (id)

Triggers

Name	Definition
trg_organisation_modified_at	CREATE TRIGGER trg_organisation_modified_at BEFORE INSERT OR UPDATE ON hame.organisation FOR EACH ROW EXECUTE FUNCTION hame.trgfunc_modified_at()

Relations

---

Generated by tbls