predictiveAI

Tables (23)

analysis_requests

  • analysis_request_id — BIGINT
  • user_id — BINARY(16) — Foreign key — NOT NULL
  • category_code — VARCHAR(50) — NOT NULL
  • analysis_status — ENUM('REQUESTED', 'PROCESSING', 'COMPLETED', 'FAILED')
  • result_summary — TEXT
  • created_at — TIMESTAMP
  • completed_at — TIMESTAMP

comment_reports

  • report_id — BIGINT
  • comment_id — BIGINT — Foreign key → comments.comment_id — NOT NULL
  • reporter_id — BINARY(16) — NOT NULL
  • reason_code — ENUM('SPAM', 'ABUSE', 'INAPPROPRIATE', 'ETC') — NOT NULL
  • created_at — TIMESTAMP

comments

  • comment_id — BIGINT
  • content_id — BIGINT — Foreign key → health_contents.content_id — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • parent_id — BIGINT — Foreign key → comments.comment_id — NULL이면 댓글, 값이 있으면 답글
  • body — TEXT — NOT NULL
  • is_deleted — BOOLEAN
  • is_hidden — BOOLEAN — 신고 누적 시 자동 숨김
  • report_count — INT
  • created_at — TIMESTAMP

content_likes

  • like_id — BIGINT
  • content_id — BIGINT — Foreign key → health_contents.content_id — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL

genome_matching_codes

  • match_id — BIGINT
  • code_value — VARCHAR(100) — NOT NULL — QR토큰 또는 수기코드
  • match_status — ENUM('UNMATCHED', 'MATCHED', 'EXPIRED')
  • matched_user_id — BINARY(16) — Foreign key
  • expires_at — DATETIME — NOT NULL
  • provider_info — VARCHAR(100) — 검사 제공자 정보

genome_reports

  • genome_report_id — BIGINT
  • report_year — YEAR — NOT NULL
  • report_type — VARCHAR(50)
  • report_name — VARCHAR(100)
  • detail_status — ENUM('AVAILABLE', 'UNAVAILABLE')
  • viewer_type — ENUM('WEBVIEW', 'PDF', 'IMAGE')
  • report_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL — UUID 고유 식별자

health_checkup_details

  • detail_id — BIGINT — Primary key
  • checkup_id — BIGINT — Foreign key → health_checkup_masters.checkup_id — NOT NULL
  • item_code — VARCHAR(50) — NOT NULL — 표준화된 검사 항목 코드
  • item_name — VARCHAR(100) — NOT NULL
  • result_value — VARCHAR(50) — 수치 또는 결과값
  • unit — VARCHAR(20)
  • status_grade — VARCHAR(20) — 정상/주의/위험 등 상태
  • data_type — ENUM('NUMBER', 'STRING', 'BOOLEAN')

health_checkup_masters

  • checkup_id — BIGINT — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL — UUID 고유 식별자
  • exam_year — YEAR — NOT NULL
  • checkup_date — DATE — NOT NULL
  • record_count — INT
  • detail_status — ENUM('AVAILABLE', 'UNAVAILABLE')
  • created_at — TIMESTAMP

health_contents

  • content_id — BIGINT
  • category — ENUM('ALL', 'SKELETON', 'DIGESTIVE', 'VASCULAR', 'MUSCLE') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT — NOT NULL
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • created_at — TIMESTAMP

medical_records

  • medical_record_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL — UUID 고유 식별자
  • visit_date — DATE — NOT NULL
  • visit_type — ENUM('HOSPITAL', 'PHARMACY') — NOT NULL
  • institution_name — VARCHAR(100) — NOT NULL — 병원/약국명
  • visit_days — INT
  • prescription_count — INT
  • created_at — TIMESTAMP

medication_details

  • medication_id — BIGINT
  • medical_record_id — BIGINT — Foreign key → medical_records.medical_record_id — NOT NULL
  • medicine_name — VARCHAR(200) — NOT NULL
  • efficacy — VARCHAR(255) — 약품 효능
  • dosage_days — INT — 처방 일수
  • medicine_code — VARCHAR(50) — 표준 약품 코드

notifications

  • noti_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • noti_type — ENUM('CONNECT', 'SUBMIT', 'UPDATE', 'NOTICE', 'QNA') — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • message — TEXT — NOT NULL
  • deep_link — VARCHAR(255) — 이동할 앱 내 화면 경로
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

popups

  • popup_id — BIGINT — Primary key
  • 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

shopping_orders

  • order_id — BIGINT
  • user_id — BINARY(16) — Foreign key — NOT NULL
  • provider_code — VARCHAR(50) — NOT NULL
  • provider_order_id — VARCHAR(100) — NOT NULL — 묶음 배송/주문 그룹 ID
  • order_group_id — VARCHAR(100) — 대표 상품명
  • item_name — VARCHAR(255) — NOT NULL — 선택 옵션 정보
  • item_option — VARCHAR(255) — 상품 금액
  • item_quantity — INT
  • item_amount — DECIMAL(12, 2) — NOT NULL — 주문/배송 상태(결제완료, 배송중 등)
  • shipping_fee — DECIMAL(10, 2)
  • order_status — VARCHAR(50) — 실제 주문 일시
  • ordered_date — DATETIME — NOT NULL — 해당 기간 총 구매 금액
  • created_at — TIMESTAMP
  • INDEX — `idx_shop_user_date`
  • INDEX — `idx_shop_provider`

shopping_sync_logs

  • sync_log_id — BIGINT
  • user_id — BINARY(16) — Foreign key — NOT NULL
  • provider_code — VARCHAR(50) — NOT NULL
  • sync_start_date — DATE — NOT NULL
  • sync_end_date — DATE — NOT NULL
  • total_amount — DECIMAL(15, 2) — 해당 기간 주문 건수
  • order_count — INT — NOT NULL
  • 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_PUSH', 'MARKETING_SMS') — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • agreed_at — TIMESTAMP

user_data_connections

  • user_id — BINARY(16) — Foreign key → users.user_id
  • health_connected — BOOLEAN — 건강검진/진료 연동
  • medical_connected — BOOLEAN — 진료기록 연동
  • genomic_connected — BOOLEAN — 유전체 데이터 연동
  • interest_connected — BOOLEAN — 직접 선택 관심사 연동
  • last_sync_at — TIMESTAMP

user_devices

  • device_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • device_uuid — VARCHAR(100) — NOT NULL — 기기 고유 번호
  • refresh_token_hash — VARCHAR(255) — NOT NULL — 서버 검증용 RT 해시
  • pin_fail_count — INT — 해당 기기 PIN 실패 횟수
  • is_bio_registered — BOOLEAN
  • last_login_at — TIMESTAMP

user_health_analysis

  • analysis_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • primary_issue_tag — VARCHAR(50) — 가중치 분석 1순위 결과
  • analysis_score_json — JSON — 카테고리별 가중치 합산 점수 데이터
  • updated_at — TIMESTAMP

user_interests

  • activity_id — BIGINT
  • provider_code — VARCHAR(50) — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL — 활동 유형(구매, 검색 등)
  • source_type — VARCHAR(50)
  • activity_title — VARCHAR(200)
  • activity_url — VARCHAR(255)
  • occurred_at — DATETIME — NOT NULL — 활동 발생 시간
  • created_at — TIMESTAMP
  • INDEX — `idx_user_occurred`
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL — UUID 고유 식별자

user_popup_settings

  • setting_id — BIGINT
  • user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
  • hide_until — DATETIME — NOT NULL — 다시보지않기 만료시간
  • popup_id — BIGINT — Foreign key → popups.popup_id
  • Field

user_shopping_connections

  • shop_conn_id — BIGINT
  • user_id — BINARY(16) — Foreign key — NOT NULL
  • provider_code — VARCHAR(50) — NOT NULL — 최종 동기화 완료 시점
  • connection_status — ENUM('CONNECTED', 'DISCONNECTED', 'REAUTH_REQUIRED', 'FAILED')
  • sync_status — ENUM('IDLE', 'PENDING', 'PROCESSING', 'COMPLETED', 'FAILED')
  • is_syncing — BOOLEAN
  • last_synced_at — TIMESTAMP — 최근 업데이트 요청 시점
  • last_requested_at — TIMESTAMP — 외부 API 인증 토큰 및 만료 정보
  • connected_at — TIMESTAMP
  • disconnected_at — TIMESTAMP
  • reauth_required — BOOLEAN
  • auth_token_json — JSON — 외부 쇼핑몰 고유 주문번호

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') — 현재 주 인증 수단
  • status — ENUM('ACTIVE', 'LOCKED', 'SUSPENDED', 'WITHDRAWAL')
  • setup_complete — BOOLEAN — 온보딩/초기설정 완료 여부
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP