Dell DVD Store

- Dell DVD Store

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_customerid Foreign 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_orderid Foreign key constraint referencing orders.orderid

Unique keys

	Key name	Columns	Description
	orders_pkey	orderid	Primary key.
Primary key.

Uses

Name
public.orders
public.customers

Used by

Name
public.orders
public.orderlines

Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39