Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('oc_user_status_id_seq'::regclass) |
|
|
||
| user_id | varchar | 255 | null |
|
|
|||
| status | varchar | 255 | null |
|
|
|||
| status_timestamp | int4 | 10 | null |
|
|
|||
| is_user_defined | bool | 1 | √ | null |
|
|
||
| message_id | varchar | 255 | √ | NULL::character varying |
|
|
||
| custom_icon | varchar | 255 | √ | NULL::character varying |
|
|
||
| custom_message | text | 2147483647 | √ | null |
|
|
||
| clear_at | int4 | 10 | √ | null |
|
|
||
| is_backup | bool | 1 | √ | false |
|
|
||
| status_message_timestamp | int4 | 10 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_user_status_pkey | Primary key | Asc | id |
| user_status_clr_ix | Performance | Asc | clear_at |
| user_status_iud_ix | Performance | Asc/Asc | is_user_defined + status |
| user_status_mtstmp_ix | Performance | Asc | status_message_timestamp |
| user_status_tstmp_ix | Performance | Asc | status_timestamp |
| user_status_uid_ix | Must be unique | Asc | user_id |