public.inventory
Documentation | Dell DVD Store |
Schema | public |
Name | inventory |
Module | Dell DVD Store database diagram |
Stores inventory data
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | prod_id | integer | Product identification number.Primary key for inventory table. | |||||
Product identification number.Primary key for inventory table. |
||||||||
2 | quan_in_stock | integer | Product quantity. | |||||
Product quantity. |
||||||||
3 | sales | integer | Product sales. | |||||
Product sales. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.products | public.inventory | public.products.prod_id = public.inventory.prod_id | fk_products_inventory Foreign key constraint referencing inventory.product_id |
|
public.products.prod_id = public.inventory.prod_id Name: fk_products_inventoryForeign key constraint referencing inventory.product_id |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
inventory_pkey | prod_id | Primary key. | |
Primary key. |
Triggers
Key name | When | Description | |
---|---|---|---|
restock | Before Update | Execute restock_order() function - | |
Execute restock_order() function - |
Used by
Name |
---|
public.inventory
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39