Table: dbo.Country_Code
Type table for ISO 3166-1 country codes.
Columns
NameTypeConstraintsDescription
country_code_KEYint (4)NOT NULLPrimary Key
country_namenvarchar (90)NOT NULLEnglish country name.
country_codenvarchar (4)NOT NULLISO country code.
Primary key
NameColumnsDescription
PK_Country_Codecountry_code_KEY
Unique constraints
NameColumnsDescription
UK_Country_Code$country_codecountry_code
UK_Country_Code$country_namecountry_name
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYTax_Agent_Direct_Deposit_Allocation
FK_Vendor_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYVendor_Direct_Deposit_Allocation
FK_Direct_Deposit_Bank_Transaction_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYDirect_Deposit_Bank_Transaction_Allocation
FK_Employee_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYEmployee_Direct_Deposit_Allocation

Schema diagram