dim_organization_unit_code


Description

A tag/code assigned to organization units (gyms) to group them.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_unit_code_id int8 19 null
bridge_organization_unit_to_organization_unit_code.organization_unit_code_id bridge_organization_unit_to_organization_unit_code_organization_unit_code_id_fkey R

The primary key of this table. System column calculated by the source System.
name varchar 256 null

The name of the organization unit code.
color_hex varchar 256 √ null

The color of the organization unit code in hexadecimal format displayed on the UI.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation