Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| company_host_id | int8 |
|
|
The company host ID, e.g.: 639. |
|||
| host | varchar |
|
|
The hostname used in the company URL. E.g. “livewell.thelookoutapp.com”. |
|||
| created_at | timestamp |
|
|
The date and time created (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
|||
| updated_at | timestamp |
|
|
The date and time the record was last updated (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
|||
| primary_host | bool |
|
|
True if the default host otherwise false. Most companies only have one host which is the primary host. E.g. true. |
|||
| status | varchar |
|
|
The status of hostname validation. E.g. “pending”, “complete”, or “requires_action”. |
|||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_company_hosts_pkey | Primary key | Asc | company_host_id |
| fct_company_hosts_company_id_idx | Performance | Asc | company_id |