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