Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
||||||
| dow_0_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Monday? |
|||||
| dow_0_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Monday? |
|||||
| dow_0_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_1_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Tuesday? |
|||||
| dow_1_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Tuesday? |
|||||
| dow_1_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_2_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Wednesday? |
|||||
| dow_2_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Wednesday? |
|||||
| dow_2_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_3_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Thursday? |
|||||
| dow_3_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Thursday? |
|||||
| dow_3_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_4_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Friday? |
|||||
| dow_4_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Friday? |
|||||
| dow_4_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_5_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Saturday? |
|||||
| dow_5_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Saturday? |
|||||
| dow_5_note | text | 2147483647 | √ | null |
|
|
|||||
| dow_6_open | time | 15,6 | '09:00:00'::time without time zone |
|
|
When does this org_unit open on Sunday? |
|||||
| dow_6_close | time | 15,6 | '17:00:00'::time without time zone |
|
|
When does this org_unit close on Sunday? |
|||||
| dow_6_note | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| hours_of_operation_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
