Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| film_not_in_stock | PROCEDURE | SQL | false | DEFINER | ||
| film_in_stock | PROCEDURE | SQL | false | DEFINER | ||
| inventory_in_stock | FUNCTION | SQL | false | tinyint(1) | DEFINER | |
| get_customer_balance | FUNCTION | SQL | true | decimal(5,2) | DEFINER | |
| inventory_held_by_customer | FUNCTION | SQL | false | int(11) | DEFINER | |
| rewards_report | PROCEDURE | SQL | false | DEFINER | Provides a customizable report on best customers |