customer

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.customer_id_seq'::regclass)
budget.customer_id fk_budget_customer_id_customer_id R
customer_address_mapping.customer_id fk_customer_address_mapping_customer_id_customer_id C
customer_attributes_mapping.customer_id fk_customer_attributes_mapping_customer_id_customer_id C
customer_customer_role_mapping.customer_id fk_customer_customer_role_mapping_customer_id_customer_id C
customer_login_history.customer_id fk_customer_login_history_customer_id_customer_id C
customer_relationship_mapping.customer_child_id fk_customer_relationship_mapping_customer_child_id_customer_id R
customer_relationship_mapping.customer_master_id fk_customer_relationship_mapping_customer_master_id_customer_id C
order.customer_id fk_order_customer_id_customer_id R
order.impersonating_customer_id fk_order_impersonating_customer_id_customer_id R
orderline_approver_history.customer_id fk_orderline_approver_history_customer_id_customer_id N
product_download.customer_id fk_product_download_customer_id_customer_id R
reward_points_history.customer_id fk_reward_points_history_customer_id_customer_id C
first_name varchar 500 √ null
last_name varchar 500 √ null
email varchar 500 √ null
username varchar 500 √ null
vat_number varchar 1000 √ null
company varchar 1000 √ null
gender varchar 1000 √ null
custom_field_1 text 2147483647 √ null
custom_field_2 text 2147483647 √ null
custom_field_3 text 2147483647 √ null
custom_checkbox text 2147483647 √ null
phone varchar 500 √ null
zip_postal_code varchar 500 √ null
billing_address_id int4 10 √ null
address.id fk_customer_billing_address_id_address_id R
shipping_address_id int4 10 √ null
address.id fk_customer_shipping_address_id_address_id R
department_id int4 10 √ null
department.id fk_customer_department_id_department_id R
storefront_id int4 10 null
storefront.id fk_customer_storefront_id_storefront_id C
date_of_birth timestamp 29,6 √ null
date_of_registration timestamp 29,6 null
status text 2147483647 √ null
external_ref uuid 2147483647 null
source_id int4 10 null
uid varchar 200 √ null
is_tax_exempt bool 1 √ null
admin_comment text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_customer Primary key Asc id
ixInsights_customer_source_id Performance Asc source_id
ixInsights_customer_uid Performance Asc uid
ixcustomer_billing_address_id Performance Asc billing_address_id
ixcustomer_department_id Performance Asc department_id
ixcustomer_shipping_address_id Performance Asc shipping_address_id
ixcustomer_storefront_id Performance Asc storefront_id

Relationships

Close relationships within degrees of separation