Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DESCRIPTION nvarchar(100)   Default = '' Stores the description of the country
 ABBREVIATION nvarchar(5)   Default = '' Stores the abbreviation of the country
 ACTIVE bit   Default = 1 Indicates whether or not the country is active
 SEQUENCE int   Default = 0 Stores the user-defined sequence for the country
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 USEFORCOAUPDATE bit   Default = 0 Indicates which country is to be used for the change of address udpate process.
 PHONEFORMATCODE tinyint   Default = 0 Stores the phone format code for the country.
 COUNTRYCODE nvarchar(10)   Default = '' Stores the telephone country code for calling this country.
 ISO3166 nvarchar(2)   Default = '' Stores the ISO3166 code for the country.

Foreign Key Field Type Null Notes Description
 COUNTRYADDRESSFORMATID uniqueidentifier   COUNTRYADDRESSFORMAT.ID Indicates the type of format to use when building addresses for this country.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_COUNTRY_DATEADDED DATEADDED    
 IX_COUNTRY_DATECHANGED DATECHANGED      
 IX_COUNTRY_ID ID      
 PK_COUNTRY ID  
 UC_COUNTRY_ABBREVIATION ABBREVIATION    
 UC_COUNTRY_DESCRIPTION DESCRIPTION    

Trigger Name Description
 TR_COUNTRY_DELETE_BBNCCODETABLEIDMAP
 TR_COUNTRY_INSERT_BBNCCODETABLEIDMAP
 TR_COUNTRY_AUDIT_UPDATE
 TR_COUNTRY_AUDIT_DELETE
 TR_COUNTRY_AUDIT_ETLDELETEDID

Referenced by Field
 ADDRESS COUNTRYID
 ADDRESSBOOKFAF COUNTRYID
 ADDRESSBOOKFAF SECONDARYCOUNTRYID
 ADDRESSTOKEN COUNTRYID
 ADVOCACY_CUSTOM COUNTRYID
 BANKACCOUNTTRANSACTION_EXT COUNTRYID
 BATCHADDRESSVALIDATION COUNTRYID
 BATCHAMPROIMPORTCONSTITUENT CONSTITUENT_UPDATEDCOUNTRYID
 BATCHAUCTIONITEMCONSTITUENT COUNTRYID
 BATCHCONSTITUENT ADDRESS_COUNTRYID
 BATCHCONSTITUENT PRIMARYBUSINESS_ADDRESS_COUNTRYID
 BATCHCONSTITUENT PRIMARYBUSINESS_PHONE_COUNTRYID
 BATCHCONSTITUENTADDRESSUPDATE COUNTRYID
 BATCHCONSTITUENTPHONE COUNTRYID
 BATCHCONSTITUENTUPDATE BUSINESS_COUNTRYID
 BATCHCONSTITUENTUPDATE BUSINESS_PHONE_COUNTRYID
 BATCHCONSTITUENTUPDATEADDRESSES COUNTRYID
 BATCHCONSTITUENTUPDATEPHONES COUNTRYID
 BATCHEDUCATIONALHISTORYUPDATE EDUCATIONALINSTITUTIONCOUNTRYID
 BATCHEVENTSPONSORSHIP COUNTRYID
 BATCHEVENTSPONSORSHIP COMPANY_COUNTRYID
 BATCHEVENTSPONSORSHIP BILLING_COUNTRYID
 BATCHREVENUECONSTITUENT COUNTRYID
 BATCHSPONSORSHIPCONSTITUENT COUNTRYID
 CONSTITUENTSOURCEANALYSISCACHEADDRESS PRIMARYCOUNTRYID
 COUNTRYADDRESSLABEL COUNTRYID
 COUNTRYVALIDATIONINFO ID
 DONATIONBATCH COUNTRYID
 DONATIONBATCH COMPANY_COUNTRYID
 DONATIONBATCH BILLING_COUNTRYID
 EVENTLOCATION COUNTRYID
 EVENTLODGINGLOCATION COUNTRYID
 EVENTREGISTRANTITINERARY COUNTRYID
 EXCHANGEDOWNLOADPROCESS DEFAULTCOUNTRYID
 FEPPROCESS COUNTRYID
 FINANCIALINSTITUTION COUNTRYID
 INTERNATIONALIZATIONINFO DEFAULTCOUNTRYID
 MKTFINDERNUMBERCONSTITUENT COUNTRYID
 MKTSEED COUNTRYID
 MKTSEGMENTPASSIVE LOCATIONCOUNTRYID
 NAMINGOPPORTUNITYFACILITY COUNTRYID
 PHONE COUNTRYID
 REGISTRANTBATCH COUNTRYID
 REGISTRANTBATCH BILLING_COUNTRYID
 REGISTRANTBATCH ORGANIZATION_COUNTRYID
 SALESORDERMARKETINGINFORMATION COUNTRYID
 STATE COUNTRYID
 TRIBUTEEXTENSION TRIBUTEECOUNTRYID
 UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH MFCOUNTRYID
 ZIPCITYSTATE COUNTRYID

Entity-Relationship diagram of this table (ADDRESS-CONSTITUENTSOURCEANALYSISCACHEADDRESS)
Entity-Relationship diagram of this table (COUNTRYADDRESSFORMAT-STATE)
Entity-Relationship diagram of this table (TRIBUTEEXTENSION-ZIPCITYSTATE)