hame.lifecycle_date.md

hame.lifecycle_date

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
lifecycle_status_id	uuid		false		codes.lifecycle_status
plan_id	uuid		true		hame.plan
plan_regulation_id	uuid		true		hame.plan_regulation
plan_proposition_id	uuid		true		hame.plan_proposition
starting_at	timestamp without time zone		true
ending_at	timestamp without time zone		true
id	uuid	gen_random_uuid()	false
created_at	timestamp without time zone	now()	false
modified_at	timestamp without time zone	now()	false
land_use_area_id	uuid		true		hame.land_use_area
other_area_id	uuid		true		hame.other_area
line_id	uuid		true		hame.line
land_use_point_id	uuid		true		hame.land_use_point
other_point_id	uuid		true		hame.other_point

Viewpoints

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

Constraints

Name	Type	Definition
plan_id_fkey	FOREIGN KEY	FOREIGN KEY (plan_id) REFERENCES hame.plan(id)
plan_lifecycle_status_id_fkey	FOREIGN KEY	FOREIGN KEY (lifecycle_status_id) REFERENCES codes.lifecycle_status(id)
plan_regulation_id_fkey	FOREIGN KEY	FOREIGN KEY (plan_regulation_id) REFERENCES hame.plan_regulation(id)
plan_proposition_id_fkey	FOREIGN KEY	FOREIGN KEY (plan_proposition_id) REFERENCES hame.plan_proposition(id)
land_use_area_id_fkey	FOREIGN KEY	FOREIGN KEY (land_use_area_id) REFERENCES hame.land_use_area(id)
land_use_point_id_fkey	FOREIGN KEY	FOREIGN KEY (land_use_point_id) REFERENCES hame.land_use_point(id)
line_id_fkey	FOREIGN KEY	FOREIGN KEY (line_id) REFERENCES hame.line(id)
other_area_id_fkey	FOREIGN KEY	FOREIGN KEY (other_area_id) REFERENCES hame.other_area(id)
other_point_id_fkey	FOREIGN KEY	FOREIGN KEY (other_point_id) REFERENCES hame.other_point(id)
lifecycle_date_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
lifecycle_date_pkey	CREATE UNIQUE INDEX lifecycle_date_pkey ON hame.lifecycle_date USING btree (id)
ix_hame_lifecycle_date_lifecycle_status_id	CREATE INDEX ix_hame_lifecycle_date_lifecycle_status_id ON hame.lifecycle_date USING btree (lifecycle_status_id)

Triggers

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

Relations

---

Generated by tbls