Address

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AddressId int identity 4 null
Address.ParentId FK_Address_Address R
AddressAdminBoundary.AddressId FK_AddressAdminBoundary_Address R
AddressMarketBoundary.AddressId FK_AddressMarketBoundary_Address R
Company.AddressId FK_Company_Address R
Scheme.AddressId FK_Scheme_Address R
AddressLine nvarchar 1073741823 ('')
RegionCode nvarchar 100 null
PostalCode nvarchar 100 null
AdministrativeArea nvarchar 510 null
CountryId int 4 null
Country.CountryId FK_Address_Country R
Locality nvarchar 510 null
Sublocality nvarchar 510 null
AddressInLocalLanguage nvarchar 1073741823 null
Location geography 2147483647 null
LocationWKT nvarchar 510 null
IsVerified bit 1 ((0))
CompletenessScore decimal 20,8 null
CompletenessScoreLastCalculated datetime 16,3 null
ParentId int 4 null
Address.AddressId FK_Address_Address R
GooglePlaceId nvarchar 510 null
GoogleLocationTypeId int 4 null
GoogleLocationType.GoogleLocationTypeId FK_Address_GoogleLocationType R
IsRetired bit 1 ((0))
RetiredDate date 20 null
CreatedAt datetime 16,3 null
UpdatedAt datetime 16,3 null

Indexes

Constraint Name Type Sort Column(s)
PK_AddressId Primary key Asc AddressId
IX_Address_Address_Text Performance Asc AddressId

Relationships