public.staff

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
staff_id	integer	nextval('staff_staff_id_seq'::regclass)	false	public.payment_p2022_01 public.payment_p2022_02 public.payment_p2022_03 public.payment_p2022_04 public.payment_p2022_05 public.payment_p2022_06 public.rental
first_name	text		false
last_name	text		false
address_id	integer		false		public.address
email	text		true
store_id	integer		false		public.store
active	boolean	true	false
username	text		false
password	text		true
last_update	timestamp with time zone	now()	false
picture	bytea		true

Constraints

Name	Type	Definition
staff_address_id_fkey	FOREIGN KEY	FOREIGN KEY (address_id) REFERENCES address(address_id) ON UPDATE CASCADE ON DELETE RESTRICT
staff_pkey	PRIMARY KEY	PRIMARY KEY (staff_id)
staff_store_id_fkey	FOREIGN KEY	FOREIGN KEY (store_id) REFERENCES store(store_id)

Indexes

Name	Definition
staff_pkey	CREATE UNIQUE INDEX staff_pkey ON public.staff USING btree (staff_id)

Triggers

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

Relations