Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| fileid | bigserial | 19 | √ | nextval('oc_filecache_fileid_seq'::regclass) |
|
|
||
| storage | int8 | 19 | 0 |
|
|
|||
| path | varchar | 4000 | √ | NULL::character varying |
|
|
||
| path_hash | varchar | 32 | ''::character varying |
|
|
|||
| parent | int8 | 19 | 0 |
|
|
|||
| name | varchar | 250 | √ | NULL::character varying |
|
|
||
| mimetype | int8 | 19 | 0 |
|
|
|||
| mimepart | int8 | 19 | 0 |
|
|
|||
| size | int8 | 19 | 0 |
|
|
|||
| mtime | int8 | 19 | 0 |
|
|
|||
| storage_mtime | int8 | 19 | 0 |
|
|
|||
| encrypted | int4 | 10 | 0 |
|
|
|||
| unencrypted_size | int8 | 19 | 0 |
|
|
|||
| etag | varchar | 40 | √ | NULL::character varying |
|
|
||
| permissions | int4 | 10 | √ | 0 |
|
|
||
| checksum | varchar | 255 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_filecache_pkey | Primary key | Asc | fileid |
| fs_mtime | Performance | Asc | mtime |
| fs_name_hash | Performance | Asc | name |
| fs_parent | Performance | Asc | parent |
| fs_parent_name_hash | Performance | Asc/Asc | parent + name |
| fs_size | Performance | Asc | size |
| fs_storage_mimepart | Performance | Asc/Asc | storage + mimepart |
| fs_storage_mimetype | Performance | Asc/Asc | storage + mimetype |
| fs_storage_path_hash | Must be unique | Asc/Asc | storage + path_hash |
| fs_storage_size | Performance | Asc/Asc/Asc | storage + size + fileid |
| memories_parent_mimetype | Performance | Asc/Asc | parent + mimetype |