Columns
| Column | Type | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| event_id | int8 |
|
|
The unique identifier for the event, E.g. 789. |
||||||
| company_id | int8 |
|
|
The company ID associated with the event, E.g. 345. |
||||||
| event_title | text |
|
|
The title or name of the event, E.g. “Company Annual Meeting”. |
||||||
| created_at | timestamp |
|
|
The date and time when the event was created (in UTC), E.g. 2021-03-02 00:12:59. |
||||||
| updated_at | timestamp |
|
|
The date and time when the event was last updated (in UTC), E.g. 2021-03-17 22:59:01. |
||||||
| archived_at | timestamp |
|
|
The date and time when the event was archived (in UTC), E.g. 2021-05-01 00:00:00. |
||||||
| billable | bool |
|
|
Indicates whether the event is billable, E.g. true or false. |
||||||
| event_type | text |
|
|
The type of event, Either “group_visit” or “event”. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_events_pkey | Primary key | Asc | event_id |
| fct_events_company_id_idx | Performance | Asc | company_id |
| fct_events_event_title_idx | Performance | Asc | event_title |