capstone_2
Tables (10)
brands
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- slug — VARCHAR(200) — NOT NULL
- logo_url — VARCHAR(500)
- description — TEXT
- is_active — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
categories
- code — VARCHAR(50) — Primary key — NOT NULL
- parent_code — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- depth — INT — NOT NULL
- is_leaf — TINYINT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
favorites
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- garment_id — BIGINT — Foreign key → garments.id — NOT NULL
- created_at — DATETIME — NOT NULL
garment_images
- id — BIGINT — Primary key — NOT NULL
- garment_id — BIGINT — Foreign key → garments.id — NOT NULL
- image_type — ENUM('MAIN','DETAIL','MODEL','THUMBNAIL') — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
garments
- id — BIGINT — Primary key — NOT NULL
- owner_user_id — BIGINT — Foreign key → users.id
- brand_id — BIGINT — Foreign key → brands.id
- category_code — VARCHAR(50) — Foreign key → categories.code
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- brand_name — VARCHAR(255)
- price — DECIMAL(10,2)
- currency — VARCHAR(10) — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- mask_url — VARCHAR(500)
- source_type — ENUM('UPLOAD','EXTERNAL_LINK') — NOT NULL
- status — ENUM('ACTIVE','HIDDEN','DELETED') — NOT NULL
- metadata_json — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
result_feedbacks
- id — BIGINT — Primary key — NOT NULL
- result_id — BIGINT — Foreign key → results.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- rating — TINYINT — NOT NULL
- comment — VARCHAR(1000)
- recommendation_mode — ENUM('SIMILAR','CONTRAST','MIXED')
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
results
- id — BIGINT — Primary key — NOT NULL
- tryon_id — BIGINT — Foreign key → tryons.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- result_image_url — VARCHAR(500) — NOT NULL
- result_thumbnail_url — VARCHAR(500)
- storage_path — VARCHAR(500)
- generation_ms — INT
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
tryons
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- user_image_id — BIGINT — Foreign key → user_images.id — NOT NULL
- garment_id — BIGINT — Foreign key → garments.id — NOT NULL
- status — ENUM('QUEUED','CLAIMED','PROCESSING','COMPLETED','FAILED','CANCELLED') — NOT NULL
- progress — TINYINT — NOT NULL
- request_json — JSON
- worker_token — VARCHAR(100)
- error_message — VARCHAR(500)
- requested_at — DATETIME — NOT NULL
- claimed_at — DATETIME
- started_at — DATETIME
- completed_at — DATETIME
- failed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_images
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_path — VARCHAR(500)
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- width — INT
- height — INT
- view_type — ENUM('FRONT','BACK','LEFT','RIGHT') — NOT NULL
- status — ENUM('UPLOADED','PROCESSING','READY','FAILED','DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- role — ENUM('USER','ADMIN') — NOT NULL
- status — ENUM('ACTIVE','SUSPENDED','DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME