public.store

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
store_id	integer	nextval('store_store_id_seq'::regclass)	false	public.customer public.inventory public.staff
manager_staff_id	integer		false
address_id	integer		false		public.address
last_update	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
store_address_id_fkey	FOREIGN KEY	FOREIGN KEY (address_id) REFERENCES address(address_id) ON UPDATE CASCADE ON DELETE RESTRICT
store_pkey	PRIMARY KEY	PRIMARY KEY (store_id)

Indexes

Name	Definition
store_pkey	CREATE UNIQUE INDEX store_pkey ON public.store USING btree (store_id)
idx_unq_manager_staff_id	CREATE UNIQUE INDEX idx_unq_manager_staff_id ON public.store USING btree (manager_staff_id)

Triggers

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

Relations