Table: Address Entity

Table: Address Entity

This entity holds address information, including Lattitude and Longitude conversions as well as verification status.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
address1varchar(255)Address Line 1
address2varchar(255)Address Line 2
cityvarchar(255)City
statechar(20)The current state of the computation fieldgeo.state.*; geo.province.*
zipcodechar(15)Zip/postal code
countrychar(20)Country codegeo.country.*
geo_latvarchar(255)Latitude coordinate
geo_lonvarchar(255)Longitude coordinate
is_verifiedtinyint(4)Whether or not it has been verified1 - yes, 0 - no
is_standardizedtinyint(1)Whether or not it has been standardized1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List