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