Table: dbo.Contact_Address_Type
Columns
NameTypeConstraintsDescription
descriptionnvarchar (60)NOT NULLDescription.
contact_address_type_KEYint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Contact_Address_Typecontact_address_type_KEY
Unique constraints
NameColumnsDescription
UK_Contact_Address_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Static__Valid_Address_Type_Usage_Rule__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYStatic__Valid_Address_Type_Usage_Rule
FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEYmailing__contact_address_type_KEYContact
FK_Contact__Contact_Address_Type__primary__contact_address_type_KEYprimary__contact_address_type_KEYContact
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYContact_Address
FK_Work_Location__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYWork_Location
FK_AR_Transaction_Template__Contact_Address_Type__shipping__contact_address_type_KEYshipping__contact_address_type_KEYAR_Transaction_Template
FK_Pending_AP_Payment__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYPending_AP_Payment
FK_Payable_Transaction_Template__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYPayable_Transaction_Template
FK_AR_Transaction__Contact_Address_Type__shipping__contact_address_type_KEYshipping__contact_address_type_KEYAR_Transaction
FK_Manage_AP_Payment_Processable_Transaction__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYManage_AP_Payment_Processable_Transaction
FK_Payable_Transaction__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYPayable_Transaction

Schema diagram