Manual:Image table

<- MediaWiki architecture < Database layout

The image table describes uploaded files, including images.

"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.