About this document
Film Stock Procedures Overview by việt lê is a document available to read on EtoBox.
The document describes three stored procedures in a database: 1. film_in_stock checks if a given film is in stock at a store and returns the inventory IDs and count. 2. film_not_in_stock checks if a film is not in stock (rented) at a store and returns the inventory IDs and count. 3. rewards_report generates a list of top customers in the previous month based on purchase criteria like minimum purchases/amount, and returns the customer data and rewardee count.
- Author
- việt lê
- Language
- EN