Database – Address Entity (address_entity)
General
This entity holds address information, including latitude and longitude conversions as well as verification status.
Address Entity
Column | Data Type | Column Info | Value Notes |
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 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 the entity is active | 1 - yes 0 - no |
deleted | tinyint(1) | Whether the entity was deleted | 1 - yes 0 - no |