- img_name VARBINARY(255)
- img_size INT
- img_width INT
- img_height INT
- img_metadata MEDIUMBLOB
- img_bits INT
- img_media_type ENUM(…)
- img_major_mime ENUM(…)
- img_minor_mime VARBINARY(100)
- img_description_id BIGINT
- img_actor BIGINT
- img_timestamp BINARY(14)
- img_sha1 VARBINARY(32)
| - oi_name VARBINARY(255)
- oi_archive_name VARBINARY(255)
- oi_size INT
- oi_width INT
- oi_height INT
- oi_bits INT
- oi_description_id BIGINT
- oi_actor BIGINT
- oi_timestamp BINARY(14)
- oi_metadata MEDIUMBLOB
- oi_media_type ENUM(…)
- oi_major_mime ENUM(…)
- oi_minor_mime VARBINARY(100)
- oi_deleted TINYINT
- oi_sha1 VARBINARY(32)
| - fa_id INT
- fa_name VARBINARY(255)
- fa_archive_name VARBINARY(255)
- fa_storage_group VARBINARY(16)
- fa_storage_key VARBINARY(64)
- fa_deleted_user INT
- fa_deleted_timestamp BINARY(14)
- fa_deleted_reason_id BIGINT
- fa_size INT
- fa_width INT
- fa_height INT
- fa_metadata MEDIUMBLOB
- fa_bits INT
- fa_media_type ENUM(…)
- fa_major_mime ENUM(…)
- fa_minor_mime VARBINARY(100)
- fa_description_id BIGINT
- fa_actor BIGINT
- fa_timestamp BINARY(14)
- fa_deleted TINYINT
- fa_sha1 VARBINARY(32)
| - us_id INT
- us_user INT
- us_key VARCHAR(255)
- us_orig_path VARCHAR(255)
- us_path VARCHAR(255)
- us_source_type VARCHAR(50)
- us_timestamp BINARY(14)
- us_status VARCHAR(50)
- us_chunk_inx INT
- us_props BLOB
- us_size INT
- us_sha1 VARCHAR(31)
- us_mime VARCHAR(255)
- us_media_type ENUM(…)
- us_image_width INT
- us_image_height INT
- us_image_bits SMALLINT
|
