Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| register_id | int4 | 10 | null |
|
|
||||||
| room_id | int4 | 10 | null |
|
|
||||||
| wakeup_date | date | 13 | null |
|
|
||||||
| wakeup_time | time | 15,6 | null |
|
|
||||||
| wakeup_status | text | 2147483647 | 'set'::text |
|
|
set, cancelled, active, busy, answered, no_answer, blocked, outdated, error, unknown. |
|||||
| pabx_status | text | 2147483647 | √ | null |
|
|
|||||
| set_user | text | 2147483647 | √ | null |
|
|
|||||
| set_time | timestamptz | 35,6 | CURRENT_TIMESTAMP |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wakeup_call_pkey | Primary key | Asc | id |
| wakeup_call_register_idx | Performance | Asc | register_id |
| wakeup_call_room_datetime_idx | Performance | Asc/Asc/Asc | room_id + wakeup_date + wakeup_time |
| wakeup_call_status_idx | Performance | Asc | wakeup_status |
| wakeup_call_unq | Must be unique | Asc/Asc/Asc | room_id + wakeup_date + wakeup_time |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| wakeup_call_status_chk | (wakeup_status = ANY (ARRAY['set'::text, 'cancelled'::text, 'active'::text, 'busy'::text, 'answered'::text, 'no_answer'::text, 'blocked'::text, 'outdated'::text, 'error'::text, 'unknown'::text])) |
Relationships
Close relationships within degrees of separation
