pagila
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
film_in_stock
Parameters
Name
Type
Mode
p_film_id
integer
IN
p_store_id
integer
IN
p_film_count
integer
OUT
Definition
SELECT inventory_id FROM inventory WHERE film_id = $1 AND store_id = $2 AND inventory_in_stock(inventory_id);