Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| file_id | bigserial | 19 | √ | nextval('previews_file_id_seq'::regclass) |
|
|
|||||
| page_number | int4 | 10 | null |
|
|
||||||
| key | varchar | 64 | null |
|
|
||||||
| filename | varchar | 256 | null |
|
|
||||||
| content_type | varchar | 128 | 'image/png'::character varying |
|
|
||||||
| size | int8 | 19 | null |
|
|
||||||
| uploaded | timestamptz | 35,6 | √ | now() |
|
|
|||||
| deleted | timestamptz | 35,6 | √ | null |
|
|
|||||
| final | bool | 1 | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| previews_file_id_page_number_key | Must be unique | Asc/Asc | file_id + page_number |
| previews_key_key | Must be unique | Asc | key |
Relationships
Close relationships within degrees of separation
