dim_closing_hours


Description

Irregular or recurring closure times for an organization unit (gym). Defines exceptions to the regular opening hours, including one-time closures and yearly recurring closures (holidays, maintenance, etc.). YEARLY entries are expanded into specific datetime ranges based on creation/archival dates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
closing_hours_id int8 19 null

The primary key of this table. System column.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id dim_closing_hours_organization_unit_id_fkey R

The organization unit (gym) that these closing hours apply to.
name varchar 256 null

Descriptive name for the closure period (e.g., ‘Summer Break’, ‘Christmas Holiday’, ‘Maintenance’).
closure_type varchar 256 null

Type of closure: ONE_TIME for specific date ranges, YEARLY for annually recurring closures.
start_date_time timestamp 29,6 null

Start date and time of the closure period in local studio timezone. For ONE_TIME: converted from UTC to local studio timezone. For YEARLY: calculated start datetime for each year from created_date to year 2045 (non-archived) or to modified_date (archived).
end_date_time timestamp 29,6 null

End date and time of the closure period in local studio timezone. For ONE_TIME: converted from UTC to local studio timezone. For YEARLY: calculated end datetime for each year from created_date to year 2045 (non-archived) or to modified_date (archived).
archived bool 1 null

Whether this closing hours entry has been archived/deleted.
created_date timestamptz 35 √ null

Date and time when this closing hours entry was originally created.
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