public.address

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
address_id	integer	nextval('address_address_id_seq'::regclass)	false	public.customer public.staff public.store
address	text		false
address2	text		true
district	text		false
city_id	integer		false		public.city
postal_code	text		true
phone	text		false
last_update	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
address_pkey	PRIMARY KEY	PRIMARY KEY (address_id)
address_city_id_fkey	FOREIGN KEY	FOREIGN KEY (city_id) REFERENCES city(city_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
address_pkey	CREATE UNIQUE INDEX address_pkey ON public.address USING btree (address_id)
idx_fk_city_id	CREATE INDEX idx_fk_city_id ON public.address USING btree (city_id)

Triggers

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

Relations