Columns
| Column | Type | Children | Parents | Comments | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| community_id | int8 |
|
|
The unique community ID, e.g.: 123. |
||||||||||||||||||||||||
| community_name | text |
|
|
The name of the community, e.g.: “Western Suburbs”. |
||||||||||||||||||||||||
| 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 last updated (in UTC), e.g.: 2021-03-17 22:59:01.116801. |
||||||||||||||||||||||||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dim_communities_pkey | Primary key | Asc | community_id |
| dim_communities_company_id_idx | Performance | Asc | company_id |