Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| album_file_id | bigserial | 19 | √ | nextval('oc_photos_albums_files_album_file_id_seq'::regclass) |
|
|
||
| album_id | int8 | 19 | null |
|
|
|||
| file_id | int8 | 19 | null |
|
|
|||
| added | int8 | 19 | null |
|
|
|||
| owner | varchar | 64 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oc_photos_albums_files_pkey | Primary key | Asc | album_file_id |
| paf_album_file | Must be unique | Asc/Asc | album_id + file_id |
| paf_folder | Performance | Asc | album_id |