public.orders
Documentation | Dell DVD Store |
Schema | public |
Name | orders |
Module | Dell DVD Store database diagram |
Information about order - amount, date etc.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | orderid | integer |
Identity / Auto increment column
Default: nextval('orders_orderid_seq'::regclass) |
Order identification number.Primary key for orders table. | ||||
Order identification number.Primary key for orders table. Identity / Auto increment column Default: nextval('orders_orderid_seq'::regclass) |
||||||||
2 | orderdate | date(0) | Order's date. | |||||
Order's date. |
||||||||
3 | customerid | integer | public.customers | Customer identification number. (reference to customer.customerid) | ||||
Customer identification number. (reference to customer.customerid) References: public.customers |
||||||||
4 | netamount | numeric | Order's net amount. | |||||
Order's net amount. |
||||||||
5 | tax | numeric | Tax amount. | |||||
Tax amount. |
||||||||
6 | totalamount | numeric | Order's total amount. | |||||
Order's total amount. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.orders | public.customers | public.orders.customerid = public.customers.customerid | fk_customerid Foreign key constraint referencing customers.customerid |
|
public.orders.customerid = public.customers.customerid Name: fk_customeridForeign key constraint referencing customers.customerid |
||||
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
orders_pkey | orderid | Primary key. | |
Primary key. |
Uses
Name |
---|
public.orders
|
Used by
Name |
---|
public.orders
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39