capstone

Tables (14)

cm29_brands

  • partner_brand_key — VARCHAR(100)
  • brand_name — VARCHAR(255) — NOT NULL
  • brand_name_ko — VARCHAR(255)
  • status — VARCHAR(30) — NOT NULL
  • logo_url — VARCHAR(500)
  • raw_json — JSON
  • synced_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cm29_catalog_items

  • item_key — VARCHAR(100)
  • partner_brand_key — VARCHAR(100) — Foreign key → cm29_brands.partner_brand_key
  • standard_category_code — VARCHAR(50) — Foreign key → cm29_standard_categories.code
  • item_name — VARCHAR(255) — NOT NULL
  • item_name_eng — VARCHAR(255)
  • sale_price — DECIMAL(10,2)
  • list_price — DECIMAL(10,2)
  • currency — VARCHAR(10) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • detail_url — VARCHAR(500)
  • option_json — JSON
  • model_info_json — JSON
  • raw_json — JSON
  • status — VARCHAR(30) — NOT NULL
  • synced_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_cm29_catalog_brand
  • INDEX — idx_cm29_catalog_category
  • FULLTEXT — KEY

cm29_display_categories

  • display_code — VARCHAR(50)
  • parent_display_code — VARCHAR(50) — Foreign key → cm29_display_categories.display_code
  • name — VARCHAR(255) — NOT NULL
  • depth — TINYINT — NOT NULL
  • raw_json — JSON
  • synced_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cm29_display_standard_mappings

  • id — BIGINT
  • display_code — VARCHAR(50) — Foreign key → cm29_display_categories.display_code — NOT NULL
  • standard_code — VARCHAR(50) — Foreign key → cm29_standard_categories.code — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • mapped_at — DATETIME — NOT NULL
  • INDEX — idx_mapping_standard_code

cm29_standard_categories

  • code — VARCHAR(50)
  • parent_code — VARCHAR(50) — Foreign key → cm29_standard_categories.code
  • name — VARCHAR(255) — NOT NULL
  • depth — TINYINT — NOT NULL
  • is_leaf — BOOLEAN — NOT NULL
  • model_size_required — BOOLEAN — NOT NULL
  • size_chart_available — BOOLEAN — NOT NULL
  • raw_json — JSON
  • synced_at — DATETIME — NOT NULL
  • updated_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
  • INDEX — idx_favorites_created_at

garment_images

  • id — BIGINT
  • 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
  • INDEX — idx_garment_images_garment_sort

garments

  • id — BIGINT
  • owner_user_id — BIGINT — Foreign key → users.id
  • source_type — ENUM('UPLOAD', '29CM_IMPORT', 'EXTERNAL_LINK') — NOT NULL
  • source_provider — ENUM('INTERNAL', '29CM') — NOT NULL
  • external_item_key — VARCHAR(100) — Foreign key → cm29_catalog_items.item_key
  • partner_brand_key — VARCHAR(100) — Foreign key → cm29_brands.partner_brand_key
  • standard_category_code — VARCHAR(50) — Foreign key → cm29_standard_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)
  • status — ENUM('ACTIVE', 'HIDDEN', 'DELETED') — NOT NULL
  • metadata_json — JSON
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • INDEX — idx_garments_source
  • INDEX — idx_garments_brand
  • INDEX — idx_garments_category
  • INDEX — idx_garments_status
  • FULLTEXT — KEY

result_feedbacks

  • id — BIGINT
  • result_id — BIGINT — Foreign key → results.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — VARCHAR(1000) — ARCHAR(1000) NUL
  • recommendation_mode — ENUM('SIMILAR', 'CONTRAST', 'MIXED')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_result_feedbacks_rating

result_recommendations

  • id — BIGINT
  • result_id — BIGINT — Foreign key → results.id — NOT NULL
  • garment_id — BIGINT — Foreign key → garments.id
  • external_item_key — VARCHAR(100) — Foreign key → cm29_catalog_items.item_key
  • source_type — ENUM('GARMENT', '29CM_ITEM') — NOT NULL
  • rank_no — INT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_result_reco_result

results

  • id — BIGINT
  • 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
  • INDEX — idx_results_user_created

tryons

  • id — BIGINT
  • 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
  • external_item_key — VARCHAR(100) — Foreign key → cm29_catalog_items.item_key
  • source_provider — ENUM('INTERNAL', '29CM') — 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
  • INDEX — idx_tryons_user_created
  • INDEX — idx_tryons_status_created
  • INDEX — idx_tryons_worker_status

user_images

  • id — BIGINT
  • 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
  • INDEX — idx_user_images_user_status
  • INDEX — idx_user_images_created_at

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — ENUM('USER', 'ADMIN', 'SELLER') — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'BLOCKED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME