public.orderlines
Documentation | Dell DVD Store |
Schema | public |
Name | orderlines |
Module | Dell DVD Store database diagram |
Stores information about order lines.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | orderlineid | smallint | Order line identification number. | |||||
Order line identification number. |
||||||||
2 | orderid | integer | public.orders | Order identification number (reference to orders.orderid) | ||||
Order identification number (reference to orders.orderid) References: public.orders |
||||||||
3 | prod_id | integer | public.products | Product identification number. | ||||
Product identification number. References: public.products |
||||||||
4 | quantity | smallint | Order's quantity. | |||||
Order's quantity. |
||||||||
5 | orderdate | date(0) | Order's date. | |||||
Order's date. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.orderlines | public.orders | public.orderlines.orderid = public.orders.orderid | fk_orderid Foreign key constraint referencing orders.orderid |
|
public.orderlines.orderid = public.orders.orderid Name: fk_orderidForeign key constraint referencing orders.orderid |
||||
public.orderlines | public.products | public.orderlines.prod_id = public.products.prod_id | fk_orderlines_products Foreign key constraint referencing products.product_id |
|
public.orderlines.prod_id = public.products.prod_id Name: fk_orderlines_productsForeign key constraint referencing products.product_id |
Uses
Name |
---|
public.orderlines
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39