Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADDRESSLABEL nvarchar(25)   Default = 'Address' Stores the value to be used on labels when prompting for an address block.
 CITYLABEL nvarchar(25)   Default = 'City' Stores the value to be used on labels when prompting for a city.
 REGIONLABEL nvarchar(25)   Default = 'Province' Stores the value to be used on labels when prompting for a region.
 POSTCODELABEL nvarchar(25)   Default = 'Postcode' Stores the value to be used on labels when prompting for a postcode.
 DPCLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a DPC.
 CARTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a cart.
 LOTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a lot.
 COUNTYLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a county.
 CONGRESSIONALDISTRICTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a congressional district.
 STATEHOUSEDISTRICTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a state house district.
 STATESENATEDISTRICTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a state senate district.
 LOCALPRECINCTLABEL nvarchar(25)   Default = '' Stores the value to be used on labels when prompting for a local precinct.
 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.

Foreign Key Field Type Null Notes Description
 COUNTRYID uniqueidentifier   COUNTRY.LOCALID Stores the country that this set of custom labels is to be used with.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_COUNTRYADDRESSLABEL_DATEADDED DATEADDED    
 IX_COUNTRYADDRESSLABEL_DATECHANGED DATECHANGED      
 PK_COUNTRYADDRESSLABEL ID  
 UC_COUNTRYADDRESSLABEL_COUNTRYID COUNTRYID    

Trigger Name Description
 TR_COUNTRYADDRESSLABEL_AUDIT_UPDATE
 TR_COUNTRYADDRESSLABEL_AUDIT_DELETE
 TR_COUNTRYADDRESSLABEL_T2BDELETE

Entity-Relationship diagram of this table