department

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.department_id_seq'::regclass)
customer.department_id fk_customer_department_id_department_id R
department_payment_method_mapping.department_id fk_department_payment_method_mapping_department_id_department_i C
department_shipping_method_mapping.department_id fk_department_shipping_method_mapping_department_id_department_ C
order.department_id fk_order_department_id_department_id R
cost_centre varchar 400 √ null
storefront_id int4 10 null
storefront.id fk_department_storefront_id_storefront_id C
name text 2147483647 √ null
external_ref uuid 2147483647 null
source_id int4 10 null
uid varchar 200 √ null
description varchar 1000 √ null
pl_code varchar 200 √ null
created_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_department Primary key Asc id
ixdepartment_storefront_id Performance Asc storefront_id

Relationships

Close relationships within degrees of separation