Manual:Image table

<- MediaWiki architecture < Database layout

The image table describes images and other uploaded files. However, the image description pages are in cur table, with old versions in old table and archive table.

"DESCRIBE image" gives the following:

+-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field          | Type                | Null | Key | Default | Extra |
 * img_name       | varchar(255) binary |      |     |         |       |
 * img_size       | int(8) unsigned     |      |     | 0       |       |
 * img_description | tinyblob           |      |     |         |       |
 * img_user       | int(5) unsigned     |      |     | 0       |       |
 * img_user_text  | varchar(255) binary |      |     |         |       |
 * img_timestamp  | varchar(14) binary  |      |     |         |       |

The fields are:
 * img_name: Filename.
 * img_size: File size in bytes.
 * img_description: Description field given during upload.
 * img_user: User ID of who uploaded the file.
 * img_user_text: User name of who uploaded the file.
 * img_timestamp: Timestamp of when upload took place.

Some of this information was adapted from  in the MediaWiki   directory.