Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ALLOWVALIDATION bit   Default = 0 Signifies whether or not addresses in this country may be validated.
 VALIDATIONCOUNTRYCODE tinyint   Default = 0 Maps the country records to a constant enumeration which represents the countries supported by address validation.
 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.
 VALIDATIONCOUNTRY nvarchar(14) (Computed) CASE [VALIDATIONCOUNTRYCODE] WHEN 0 THEN N'' WHEN 1 THEN N'Australia' WHEN 2 THEN N'Canada' WHEN 3 THEN N'United Kingdom' WHEN 4 THEN N'United States' WHEN 5 THEN N'New Zealand' END Provides a translation for the 'VALIDATIONCOUNTRYCODE' field.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   COUNTRY.LOCALID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_COUNTRYVALIDATIONINFO_DATEADDED DATEADDED    
 IX_COUNTRYVALIDATIONINFO_DATECHANGED DATECHANGED      
 PK_COUNTRYVALIDATIONINFO ID  

Trigger Name Description
 TR_COUNTRYVALIDATIONINFO_AUDIT_UPDATE
 TR_COUNTRYVALIDATIONINFO_AUDIT_DELETE

Entity-Relationship diagram of this table