Fields (12)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| albumID | int(11) | NO | MUL | NULL | |
| name | varchar(255) | NO | NULL | ||
| description | text | NO | NULL | ||
| path | varchar(255) | NO | MUL | NULL | |
| type | varchar(50) | NO | NULL | ||
| extension | varchar(20) | NO | NULL | ||
| file_size | int(10) unsigned | NO | NULL | ||
| width | int(11) unsigned | YES | NULL | ||
| height | int(11) unsigned | YES | NULL | ||
| userID | int(11) | NO | NULL | ||
| created | date | NO | NULL |
Indexes (3)
| Name | Columns | Unique |
|---|---|---|
| Album | albumID | No |
| path | path | No |
| PRIMARY | id | Yes |