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

Close relationships within degrees of separation