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


How did we do?


Powered by HelpDocs (opens in a new tab)