address_entity - Address Entity

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


How did we do?


Powered by HelpDocs (opens in a new tab)