fitbacktest2

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 → member.member_id — 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 → member.member_id — 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_id — BIGINT — Foreign key → image_asset.owner_member_id — NOT NULL
    • email — VARCHAR(255) — NOT NULL
    • nickname — VARCHAR(50)
    • password_hash — VARCHAR(255)
    • login_provider — VARCHAR(20) — NOT NULL
    • social_uid — VARCHAR(100)
    • provider_subject — VARCHAR(255)
    • profile_image_id — BIGINT — Foreign key → image_asset.image_id
    • role — VARCHAR(20) — NOT NULL
    • refresh_token — VARCHAR(512)
    • onboarding_completed_at — DATETIME
    • created_at — DATETIME — NOT NULL
    • updated_at — DATETIME — NOT NULL

    member_consent_history

    • consent_history_id — BIGINT — Primary key — NOT NULL
    • member_id — BIGINT — Foreign key → member.member_id
    • 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 → member.member_id — 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 → member.member_id — NOT NULL
    • notification_type — VARCHAR(30) — NOT NULL
    • actor_member_id — BIGINT — Foreign key → member.member_id
    • 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 → member.member_id
    • 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 → member.member_id — NOT NULL
    • 동의 여부 (is_agreed) — TINYINT(1) — NOT NULL
    • 변경 시간 (created_at) — DATETIME — NOT NULL

    비밀번호 초기화 토큰 (password_reset_token)

    • member_id — BIGINT — Foreign key → member.member_id — 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 → member.member_id — 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