public.cust_hist
Documentation | Dell DVD Store |
Schema | public |
Name | cust_hist |
Module | Dell DVD Store database diagram |
Stores customers’s order histroy.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | customerid | integer | public.customers | Customer identification number. (reference to customer.customerid) | ||||
Customer identification number. (reference to customer.customerid) References: public.customers |
||||||||
2 | orderid | integer | Order identification number | |||||
Order identification number |
||||||||
3 | prod_id | integer | Product identification number. | |||||
Product identification number. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.cust_hist | public.customers | public.cust_hist.customerid = public.customers.customerid | fk_cust_hist_customerid Foreign key constraint referencing customers.customerid |
|
public.cust_hist.customerid = public.customers.customerid Name: fk_cust_hist_customeridForeign key constraint referencing customers.customerid |
Uses
Name |
---|
public.cust_hist
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39