customer_customer_role_mapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.customer_customer_role_mapping_id_seq'::regclass)
customer_id int4 10 null
customer.id fk_customer_customer_role_mapping_customer_id_customer_id C
role_id int4 10 null
customer_role.id fk_customer_customer_role_mapping_role_id_customer_role_id R

Indexes

Constraint Name Type Sort Column(s)
PK_customer_customer_role_mapping Primary key Asc id
ixcustomer_customer_role_mapping_customer_id Performance Asc customer_id
ixcustomer_customer_role_mapping_role_id Performance Asc role_id

Relationships

Close relationships within degrees of separation