customer_attributes_mapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.customer_attributes_mapping_id_seq'::regclass)
customer_id int4 10 null
customer.id fk_customer_attributes_mapping_customer_id_customer_id C
attribute_name_id int4 10 null
attribute_name.id fk_customer_attributes_mapping_attribute_name_id_attribute_name C
attribute_value_id int4 10 √ null
attribute_value.id fk_customer_attributes_mapping_attribute_value_id_attribute_val N
external_ref uuid 2147483647 null
source_id int4 10 null

Indexes

Constraint Name Type Sort Column(s)
PK_customer_attributes_mapping Primary key Asc id
ixcustomer_attributes_mapping_attribute_name_id Performance Asc attribute_name_id
ixcustomer_attributes_mapping_attribute_value_id Performance Asc attribute_value_id
ixcustomer_attributes_mapping_customer_id Performance Asc customer_id

Relationships

Close relationships within degrees of separation