actor.hours_of_operation
When does this org_unit usually open and close? (Variations are expressed in the actor.org_unit_closed table.)
|
Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit. |
|
Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: |
Columns
| Column | Type | Nullable | Default | Notes |
|---|---|---|---|---|
id PK FK |
|
No |
||
dow_0_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Monday? |
dow_0_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Monday? |
dow_0_note |
|
Yes |
||
dow_1_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Tuesday? |
dow_1_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Tuesday? |
dow_1_note |
|
Yes |
||
dow_2_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Wednesday? |
dow_2_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Wednesday? |
dow_2_note |
|
Yes |
||
dow_3_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Thursday? |
dow_3_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Thursday? |
dow_3_note |
|
Yes |
||
dow_4_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Friday? |
dow_4_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Friday? |
dow_4_note |
|
Yes |
||
dow_5_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Saturday? |
dow_5_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Saturday? |
dow_5_note |
|
Yes |
||
dow_6_open |
|
No |
'09:00:00'::time without time zone |
When does this org_unit open on Sunday? |
dow_6_close |
|
No |
'17:00:00'::time without time zone |
When does this org_unit close on Sunday? |
dow_6_note |
|
Yes |