public.reorder
Documentation | Dell DVD Store |
Schema | public |
Name | reorder |
Module | Dell DVD Store database diagram |
Stores information about product to reorder.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | prod_id | integer | public.products | Product identification number. | ||||
Product identification number. References: public.products |
||||||||
2 | date_low | date(0) | The date when product quantity in stock was low. | |||||
The date when product quantity in stock was low. |
||||||||
3 | quan_low | integer | The product quantity in stock - when was low. | |||||
The product quantity in stock - when was low. |
||||||||
4 | date_reordered | date(0) | The reorder's date. | |||||
The reorder's date. |
||||||||
5 | quan_reordered | integer | The reorder's quantity. | |||||
The reorder's quantity. |
||||||||
6 | date_expected | date(0) | The quantity of reorder. | |||||
The quantity of reorder. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.reorder | public.products | public.reorder.prod_id = public.products.prod_id | fk_reorder_products | |
public.reorder.prod_id = public.products.prod_id Name: fk_reorder_products |
Uses
Name |
---|
public.reorder
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39