mysql> describe files;
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| fid      | int(10) unsigned | NO   | PRI | 0       |       |
| nid      | int(10) unsigned | NO   | MUL | 0       |       |
| filename | varchar(255)     | NO   |     |         |       |
| filepath | varchar(255)     | NO   |     |         |       |
| filemime | varchar(255)     | NO   |     |         |       |
| filesize | int(10) unsigned | NO   |     | 0       |       |
+----------+------------------+------+-----+---------+-------+