Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | int4 | 10 | null |
| Primary key. | |||||||||||||||
archived_at | timestamp | 29,6 | √ | null | Date the location was archived. | |||||||||||||||
city | varchar | 255 | √ | null | City. | |||||||||||||||
company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | ||||||||||||||
country_code | varchar | 255 | √ | null | Country ISO code. | |||||||||||||||
created_at | timestamp | 29,6 | √ | null | Date the record was created. | |||||||||||||||
full_address | varchar | 65535 | √ | null | Full address. | |||||||||||||||
name | varchar | 255 | √ | null | Location name. | |||||||||||||||
note | varchar | 65535 | √ | null | Note. | |||||||||||||||
postal_code | varchar | 255 | √ | null | Postal code. | |||||||||||||||
state_code | varchar | 255 | √ | null | State code. | |||||||||||||||
street | varchar | 255 | √ | null | Street. | |||||||||||||||
updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |