AdminBoundary

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AdminBoundaryId int identity 4 √ null
AddressAdminBoundary.AdminBoundaryId FK_AddressAdminBoundary_AdminBoundary R
AdminBoundaryCode nvarchar 100 null
AdminBoundaryName nvarchar 510 null
AdminBoundaryTypeId int 4 null
AdminBoundaryType.AdminBoundaryTypeId FK_AdminBoundary_AdminType R
TierTypeId int 4 null
TierType.TierTypeId FK_AdminBoundary_TierType R
CountryId int 4 √ null
Country.CountryId FK_AdminBoundary_Country R
Description nvarchar 1000 √ null
Parent nvarchar 100 √ null
SortIndex int 4 √ null
IsActive bit 1 √ null
Version int 4 √ null
CreatedBy nvarchar 510 √ null
ValidFrom datetime 16,3 √ null
ValidTo datetime 16,3 √ null
Polygon geography 2147483647 √ null
PolygonWKT nvarchar 1073741823 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_AdminBoundaryId Primary key Asc AdminBoundaryId
IX_AdminBoundary_Parent Performance Asc Parent
ix_AdminBoundaryAdminBoundaryCode Must be unique Asc AdminBoundaryCode

Relationships

Close relationships within degrees of separation