Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('moderation_moderatedobject_id_seq'::regclass) |
|
|
|||||
| object_pk | int4 | 10 | √ | null |
|
|
|||||
| created | timestamptz | 35,6 | null |
|
|
||||||
| updated | timestamptz | 35,6 | null |
|
|
||||||
| state | int2 | 5 | null |
|
|
||||||
| status | int2 | 5 | null |
|
|
||||||
| on | timestamptz | 35,6 | √ | null |
|
|
|||||
| reason | text | 2147483647 | √ | null |
|
|
|||||
| changed_object | text | 2147483647 | null |
|
|
||||||
| changed_by_id | int4 | 10 | √ | null |
|
|
|||||
| content_type_id | int4 | 10 | √ | null |
|
|
|||||
| by_id | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| moderation_moderatedobject_pkey | Primary key | Asc | id |
| moderation_moderatedobject_changed_by_id_cac7f12e | Performance | Asc | changed_by_id |
| moderation_moderatedobject_content_type_id_0bcb3166 | Performance | Asc | content_type_id |
| moderation_moderatedobject_moderated_by_id_5be94779 | Performance | Asc | by_id |
| moderation_moderatedobject_object_pk_d6ad0cef | Performance | Asc | object_pk |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| moderation_moderatedobject_object_pk_check | ((object_pk >= 0)) |