predictiveAI

Tables (9)

health_contents

  • content_id — BIGINT
  • category — ENUM('ALL', 'SKELETON', 'DIGESTIVE', 'MUSCLE') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT — NOT NULL
  • target_organ — VARCHAR(50) — 연관 장기 태그
  • view_count — INT
  • created_at — TIMESTAMP

notifications

  • noti_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — `idx_user_read`

popups

  • popup_id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • content_url — VARCHAR(255) — NOT NULL
  • priority — INT
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

terms_agreement

  • agreement_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • term_type — ENUM('SERVICE', 'PRIVACY', 'MARKETING') — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • version — VARCHAR(20) — NOT NULL — 약관 버전
  • agreed_at — TIMESTAMP
  • INDEX — `idx_user_term`

user_bio_keys

  • key_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • public_key — TEXT — NOT NULL — FIDO 공개키
  • device_uuid — VARCHAR(100) — NOT NULL — 기기 고유 번호
  • created_at — TIMESTAMP

user_data_connections

  • user_id — BINARY(16) — Foreign key → users.user_id
  • health_connected — BOOLEAN
  • interest_connected — BOOLEAN
  • shopping_connected — BOOLEAN
  • updated_at — TIMESTAMP

user_devices

  • device_id — BIGINT
  • user_id — BINARY(16) — Foreign key — NOT NULL
  • device_uuid — VARCHAR(100) — NOT NULL — 기기 고유 번호
  • device_name — VARCHAR(100) — 기기 모델명 (예: iPhone 15)
  • refresh_token_hash — VARCHAR(255) — NOT NULL — 서버 검증용 리프레시 토큰 해시
  • pin_fail_count — INT — 해당 기기 PIN 입력 실패 횟수
  • is_bio_registered — BOOLEAN — 해당 기기 생체인증 등록 여부
  • last_login_at — TIMESTAMP

user_popup_settings

  • setting_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • popup_id — BIGINT — Foreign key → popups.popup_id — NOT NULL
  • hide_until — DATETIME — NOT NULL — 노출 차단 만료 시간

users

  • user_id — BINARY(16) — Primary key — NOT NULL — UUID 고유 식별자
  • name — VARCHAR(50) — NOT NULL — 사용자 실명
  • ci_value — VARCHAR(255) — NOT NULL — 본인인증 고유 식별값
  • auth_type — ENUM('PIN', 'BIO', 'NONE') — 주 인증 수단
  • pin_hash — VARCHAR(255) — 암호화된 PIN
  • pin_fail_count — INT — PIN 실패 횟수
  • is_bio_enabled — BOOLEAN — 생체인증 활성화 여부
  • setup_complete — BOOLEAN — 온보딩 완료 여부
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP