locations


Description

A list of all locations.

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint410null
offer_locations.location_idDefined in XMLR
placement_locations.location_idDefined in XMLR
placements.work_location_idDefined in XMLR
requisition_locations.location_idDefined in XMLR

Primary key.

archived_attimestamp29,6null

Date the location was archived.

cityvarchar255null

City.

company_idint410null
companies.idDefined in XMLR

Id of the company the record belongs to.

country_codevarchar255null

Country ISO code.

created_attimestamp29,6null

Date the record was created.

full_addressvarchar65535null

Full address.

namevarchar255null

Location name.

notevarchar65535null

Note.

postal_codevarchar255null

Postal code.

state_codevarchar255null

State code.

streetvarchar255null

Street.

updated_attimestamp29,6null

Date the record was updated.

Relationships