Table: Contact_Contact_Category
Columns
NameTypeConstraintsDescription
contact_contact_category_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
contact_KEYintNOT NULLKey to the parent contact record.
contact_category_KEYintNOT NULLKey to the assigned category.
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Contact_Contact_Category$contact_contact_category_KEYcontact_contact_category_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Contact_Contact_Category$contact_KEY$contact_category_KEYcontact_KEY, contact_category_KEYEach Contact can only be in each category once.
Indexes
NameColumnsDescription
IX_Contact_Contact_Category$contact_category_KEYcontact_category_KEYIndex supports foreign key FK_Contact_Contact_Category__Contact_Category__contact_category_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Contact_Category__Contact__contact_KEYcontact_KEYContact
FK_Contact_Contact_Category__Contact_Category__contact_category_KEYcontact_category_KEYContact_Category

Schema diagram