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