public.inventory

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
inventory_id	integer	nextval('inventory_inventory_id_seq'::regclass)	false	public.rental
film_id	integer		false		public.film
store_id	integer		false		public.store
last_update	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
inventory_film_id_fkey	FOREIGN KEY	FOREIGN KEY (film_id) REFERENCES film(film_id) ON UPDATE CASCADE ON DELETE RESTRICT
inventory_pkey	PRIMARY KEY	PRIMARY KEY (inventory_id)
inventory_store_id_fkey	FOREIGN KEY	FOREIGN KEY (store_id) REFERENCES store(store_id) ON UPDATE CASCADE ON DELETE RESTRICT

Indexes

Name	Definition
inventory_pkey	CREATE UNIQUE INDEX inventory_pkey ON public.inventory USING btree (inventory_id)
idx_store_id_film_id	CREATE INDEX idx_store_id_film_id ON public.inventory USING btree (store_id, film_id)

Triggers

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

Relations