orders

830 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
order_id serial 10 √ nextval('orders_order_id_seq'::regclass)
order_details.order_id fk_order_details_ordersR
customer_id text 2147483647 √ null
customers.customer_id fk_orders_customersR
employee_id int4 10 √ null
employees.employee_id fk_orders_employeesR
order_date date 13 √ null
required_date date 13 √ null
shipped_date date 13 √ null
ship_via int4 10 √ null
shippers.shipper_id fk_orders_shippersR
freight numeric 131089 √ null
ship_name text 2147483647 √ null
ship_address text 2147483647 √ null
ship_city text 2147483647 √ null
ship_region text 2147483647 √ null
ship_postal_code text 2147483647 √ null
ship_country text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_orders Primary key Asc order_id

Relationships

Close relationships within degrees of separation