Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| auto_id | bigserial | 19 | √ | nextval('oc_files_trash_auto_id_seq'::regclass) |
|
|
||
| id | varchar | 250 | ''::character varying |
|
|
|||
| user | varchar | 64 | ''::character varying |
|
|
|||
| timestamp | varchar | 12 | ''::character varying |
|
|
|||
| location | varchar | 512 | ''::character varying |
|
|
|||
| type | varchar | 4 | √ | NULL::character varying |
|
|
||
| mime | varchar | 255 | √ | NULL::character varying |
|
|
||
| deleted_by | varchar | 64 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_files_trash_pkey | Primary key | Asc | auto_id |
| id_index | Performance | Asc | id |
| timestamp_index | Performance | Asc | timestamp |
| user_index | Performance | Asc | user |