Database – Address Entity (address_entity)
Updated 3 months ago
This entity holds address information, including Latitude and Longitude conversions as well as verification status.
Column | Data Type | Column Info | Value Notes | Other |
id | INT(11) | The id of the entity | ||
address1 | VARCHAR(255) | Address Line 1 | ||
address2 | VARCHAR(255) | Address Line 2 | ||
city | VARCHAR(255) | City | ||
state | CHAR(20) | The current state of the computation field | geo.state.*; geo.province.* | |
zipcode | CHAR(15) | Zip/postal code | ||
country | CHAR(20) | Country code | geo.country.* | |
geo_lat | VARCHAR(255) | Latitude coordinate | ||
geo_lon | VARCHAR(255) | Longitude coordinate | ||
is_verified | TINYINT(4) | Whether or not it has been verified | 1 - yes, 0 - no | |
is_standardized | TINYINT(1) | Whether or not it has been standardized | 1 - yes, 0 - no | |
created | TIMESTAMP | Timestamp of when the entity was created | ||
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated | ||
active | TINYINT(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | TINYINT(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |