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