ahiWiki.filearchive
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fa_id | int(11) | NO | PRI | auto_increment | ||
| fa_name | varbinary(255) | NO | MUL | |||
| fa_archive_name | varbinary(255) | YES | ||||
| fa_storage_group | varbinary(16) | YES | MUL | |||
| fa_storage_key | varbinary(64) | YES | ||||
| fa_deleted_user | int(11) | YES | ||||
| fa_deleted_timestamp | binary(14) | YES | MUL | |||
| fa_deleted_reason | varbinary(767) | YES | ||||
| fa_deleted_reason_id | bigint(20) unsigned | NO | 0 | |||
| fa_size | int(10) unsigned | YES | 0 | |||
| fa_width | int(11) | YES | 0 | |||
| fa_height | int(11) | YES | 0 | |||
| fa_metadata | mediumblob | YES | ||||
| fa_bits | int(11) | YES | 0 | |||
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | ||||
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | unknown | |||
| fa_minor_mime | varbinary(100) | YES | unknown | |||
| fa_description | varbinary(767) | YES | ||||
| fa_description_id | bigint(20) unsigned | NO | 0 | |||
| fa_user | int(10) unsigned | YES | 0 | |||
| fa_user_text | varbinary(255) | YES | MUL | |||
| fa_timestamp | binary(14) | YES | ||||
| fa_deleted | tinyint(3) unsigned | NO | 0 | |||
| fa_sha1 | varbinary(32) | NO | MUL |
References
| Local Column | References |
|---|