fitbacktest
Tables (25)
Untitled
- Field
- Field2
analysis_report
- report_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → image_asset.owner_member_id — NOT NULL
- original_image_id — BIGINT — Foreign key → image_asset.image_id — NOT NULL
- analysis_status — VARCHAR(20) — NOT NULL
- match_percentage — INT — NOT NULL
- completed_at — DATETIME
- deleted_at — DATETIME
- purge_after — DATETIME
- garment_piece — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
closet_save
- save_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → analysis_report.member_id — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- trend_id — BIGINT — Foreign key → trend_content.trend_id
- lookbook_id — BIGINT — Foreign key → lookbook.lookbook_id
- report_id — BIGINT — Foreign key → analysis_report.report_id
- created_at — DATETIME — NOT NULL
image_asset
- image_id — BIGINT — Primary key — NOT NULL
- public_id — CHAR(36) — NOT NULL
- owner_member_id — BIGINT — Foreign key — NOT NULL
- purpose — VARCHAR(20) — NOT NULL
- visibility — VARCHAR(20) — NOT NULL
- storage_key — VARCHAR(512) — NOT NULL
- mime_type — VARCHAR(50) — NOT NULL
- file_size_bytes — BIGINT — NOT NULL
- width_px — INT
- height_px — INT
- checksum_sha256 — CHAR(64)
- asset_status — VARCHAR(20) — NOT NULL
- presigned_expires_at — DATETIME
- uploaded_at — DATETIME
- activated_at — DATETIME
- delete_requested_at — DATETIME
- deleted_at — DATETIME
- retry_count — INT — NOT NULL
- next_retry_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- Field
lookbook
- lookbook_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → image_asset.owner_member_id — NOT NULL
- source_report_id — BIGINT — Foreign key → analysis_report.report_id
- original_image_id — BIGINT — Foreign key → image_asset.image_id — NOT NULL
- matched_image_id — BIGINT — Foreign key → image_asset.image_id — NOT NULL
- purchase_url — VARCHAR(2048)
- comment — VARCHAR(500)
- like_count — INT — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
lookbook_like
- like_id — BIGINT — Primary key — NOT NULL
- lookbook_id — BIGINT — Foreign key → lookbook.lookbook_id — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- created_at — DATETIME — NOT NULL
lookbook_product
- lookbook_product_id — BIGINT — Primary key — NOT NULL
- lookbook_id — BIGINT — Foreign key → lookbook.lookbook_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
lookbook_report (Untitled2)
lookbook_tag
- lookbook_tag_id — BIGINT — Primary key — NOT NULL
- lookbook_id — BIGINT — Foreign key → lookbook.lookbook_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- created_at — DATETIME — NOT NULL
member
member_consent_history
- consent_history_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key
- consent_type — VARCHAR(30) — NOT NULL
- policy_version — VARCHAR(30) — NOT NULL
- is_agreed — TINYINT(1) — NOT NULL
- recorded_at — DATETIME — NOT NULL
member_tag
- member_tag_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- created_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- notification_type — VARCHAR(30) — NOT NULL
- actor_member_id — BIGINT — Foreign key
- lookbook_id — BIGINT — Foreign key → lookbook.lookbook_id
- report_id — BIGINT — Foreign key → analysis_report.report_id
- trend_id — BIGINT — Foreign key → trend_content.trend_id
- title — VARCHAR(100) — NOT NULL
- body — VARCHAR(500) — NOT NULL
- read_at — DATETIME
- created_at — DATETIME — NOT NULL
product
- product_id — BIGINT — Primary key — NOT NULL
- external_product_id — VARCHAR(100)
- name — VARCHAR(255) — NOT NULL
- brand_name — VARCHAR(100)
- seller_name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- average_price — INT
- category — VARCHAR(50) — NOT NULL
- season — VARCHAR(20)
- gender — VARCHAR(20)
- purchase_url — VARCHAR(2048) — NOT NULL
- image_url — VARCHAR(2048) — NOT NULL
- source_api — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product_tag
- product_tag_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- created_at — DATETIME — NOT NULL
recommended_item
- recommend_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_report.report_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- rank_no — INT — NOT NULL
- category — VARCHAR(50) — NOT NULL
- similarity_score — INT — NOT NULL
- is_value_match — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
report_tag
- report_tag_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_report.report_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- source — VARCHAR(20) — NOT NULL
- is_confirmed — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
tag
- tag_id — BIGINT — Primary key — NOT NULL
- tag_name — VARCHAR(50) — NOT NULL
- tag_type — VARCHAR(30) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
trend_content
- trend_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(2048) — NOT NULL
- description — TEXT
- source_url — VARCHAR(2048)
- created_by — BIGINT — Foreign key
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
trend_tag
- trend_tag_id — BIGINT — Primary key — NOT NULL
- trend_id — BIGINT — Foreign key → trend_content.trend_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- created_at — DATETIME — NOT NULL
- 트랜드와 태그 관련도 (relevance_weight) — INT — NOT NULL
로그인 시도 (login_attempt)
- id (login_attempt_id) — BIGINT — Primary key — NOT NULL
- 이메일(해시) (email_hash) — VARCHAR(64) — NOT NULL
- 로그인 실패 횟수 (failed_count) — INT — NOT NULL
- 마지막 로그인 시도 (last_failed_at) — DATETIME — NOT NULL
- 잠금 시간 (locked_until) — DATETIME
마케팅 알림 수신 동의 이력 (marketing_consent_history)
- id (marketing_consent_history_id) — BIGINT — Primary key — NOT NULL
- 회원 id (member_id) — BIGINT — Foreign key — NOT NULL
- 동의 여부 (is_agreed) — TINYINT(1) — NOT NULL
- 변경 시간 (created_at) — DATETIME — NOT NULL
비밀번호 초기화 토큰 (password_reset_token)
- member_id — BIGINT — Foreign key — NOT NULL
- 재설정 토큰 해시값 (token_hash) — CHAR(64) — NOT NULL
- 토큰 만료시간 (expires_at) — DATETIME — NOT NULL
- 생성 시간 (created_at) — DATETIME — NOT NULL
탈퇴 이메일 재가입 제한 (withdrawal_email_block)
- withdrawal_id — BIGINT — Primary key — NOT NULL
- email_hash — CHAR(64) — NOT NULL
- blocked_until — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
회원 알림 설정 (member_notification_setting)
- member_id — BIGINT — Foreign key — NOT NULL
- analysis_complete_enabled — TINYINT(1) — NOT NULL
- lookbook_liked_enabled — TINYINT(1) — NOT NULL
- trend_update_enabled — TINYINT(1) — NOT NULL
- marketing_enabled — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL