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