public.city

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
city_id	integer	nextval('city_city_id_seq'::regclass)	false	public.address
city	text		false
country_id	integer		false		public.country
last_update	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
city_pkey	PRIMARY KEY	PRIMARY KEY (city_id)
city_country_id_fkey	FOREIGN KEY	FOREIGN KEY (country_id) REFERENCES country(country_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
city_pkey	CREATE UNIQUE INDEX city_pkey ON public.city USING btree (city_id)
idx_fk_country_id	CREATE INDEX idx_fk_country_id ON public.city USING btree (country_id)

Triggers

Name	Definition
last_updated	CREATE TRIGGER last_updated BEFORE UPDATE ON public.city FOR EACH ROW EXECUTE FUNCTION last_updated()

Relations