Table: dbo.Static__Valid_Address_Type_Usage_Rule
This table defines which contact types can be associated with which contact address types.
Columns
NameTypeConstraintsDescription
contact_type_KEYint (4)NOT NULLPrimary Key for this table; FK to the Contact_Type table
contact_address_type_KEYint (4)NOT NULLFK to the Contact_Address_Type table
Primary key
NameColumnsDescription
PK_Static__Valid_Address_Type_Usage_Rule$contact_type_KEY$contact_address_type_KEYcontact_type_KEY, contact_address_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Static__Valid_Address_Type_Usage_Rule__Contact_Type__contact_type_KEYcontact_type_KEYContact_Type (contact_type_KEY)
FK_Static__Valid_Address_Type_Usage_Rule__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYContact_Address_Type (contact_address_type_KEY)

Schema diagram