virtual-fitting-capstone-erd
Tables (6)
favorites
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- garment_id — VARCHAR(255) — Foreign key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
garments
- garment_id — VARCHAR(255) — Primary key — NOT NULL
- brand_key — VARCHAR(255)
- brand_name — VARCHAR(255)
- category — VARCHAR(255)
- content_type — VARCHAR(255)
- created_at — DATETIME(6)
- currency — VARCHAR(255)
- deleted — BIT — NOT NULL
- deleted_at — DATETIME(6)
- external_item_key — VARCHAR(255)
- file_url — VARCHAR(255)
- filename — VARCHAR(255)
- mask_url — VARCHAR(255)
- metadata_json — LONGTEXT
- name — VARCHAR(255)
- owner_user_id — BIGINT — Foreign key
- partner_brand_key — VARCHAR(255)
- price — DECIMAL(38, 2)
- source_type — VARCHAR(255)
- standard_category_code — VARCHAR(255)
- status — VARCHAR(255)
- thumbnail_url — VARCHAR(255)
- updated_at — DATETIME(6)
results
- id — BIGINT — Primary key — NOT NULL
- comment — VARCHAR(255) — ARCHAR(255) NUL
- created_at — DATETIME(6)
- deleted — BIT — NOT NULL
- garment_category — VARCHAR(255)
- generation_ms — INT
- rating — INT — NOT NULL
- recommendation_mode — VARCHAR(255)
- result_id — VARCHAR(255)
- result_image_url — VARCHAR(255)
- result_thumbnail_url — VARCHAR(255)
- storage_path — VARCHAR(255)
- tryon_id — VARCHAR(255) — Foreign key
- user_id — BIGINT — Foreign key
tryon_jobs
- tryon_id — VARCHAR(255) — Primary key — NOT NULL
- created_at — DATETIME(6)
- deleted — BIT
- error_code — VARCHAR(255)
- error_message — VARCHAR(1000)
- external_item_key — VARCHAR(255)
- garment_id — VARCHAR(255) — Foreign key
- progress — INT
- result_id — VARCHAR(255)
- result_image_url — VARCHAR(255)
- status — VARCHAR(255)
- updated_at — DATETIME(6)
- user_id — bigint — Foreign key
- user_image_id — VARCHAR(255) — Foreign key
user_images
- image_id — VARCHAR(50) — Primary key — NOT NULL
- content_type — VARCHAR(50)
- created_at — DATETIME(6)
- file_url — VARCHAR(255)
- filename — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- view — VARCHAR(20)
- user_id — BIGINT — Foreign key
users
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- deleted_at — DATETIME(6)
- nickname — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(255)
- role — ENUM — NOT NULL
- status — ENUM — NOT NULL
- updated_at — DATETIME(6)