predictiveAI
Tables (21)
analysis_requests
- analysis_request_id — BIGINT
- user_id — BINARY(16) — Foreign key → users.user_id — 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
- 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 → users.user_id
- expires_at — DATETIME — NOT NULL
- provider_info — VARCHAR(100) — 검사 제공자 정보
genome_reports
- genome_report_id — BIGINT
- user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
- 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
health_checkup_details
- detail_id — BIGINT
- 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
- user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
- 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 — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- body — TEXT — NOT NULL
- image_url — VARCHAR(255) — 목록 썸네일 이미지
- 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
- 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', 'ANALYSIS', 'COMMENT '클릭 시 이동할 앱 내 경로',' 'NOTICE') — NOT NULL — 클릭 시 이동할 앱 내 경로',' 'NOTICE') NOT NUL
- title — VARCHAR(100) — NOT NULL
- message — TEXT — NOT NULL
- deep_link — VARCHAR(255) — 쇼핑몰 구분(NAVER, COUPANG, KURLY 등)
- is_read — BOOLEAN
- created_at — TIMESTAMP
popups
- popup_id — BIGINT
- title — VARCHAR(100) — NOT NULL — 관리용 팝업 제목
- image_url — VARCHAR(255) — NOT NULL — 팝업 이미지 경로
- link_url — VARCHAR(255) — 클릭 시 이동할 딥링크/웹뷰 URL
- 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 → users.user_id — 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 → users.user_id — 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 — VARCHAR(50) — NOT NULL — SERVICE, PRIVACY, ANALYSIS_HEALTH 등
- terms_version_id — VARCHAR(20) — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- agreed_at — TIMESTAMP
user_data_connections
- connection_id — BIGINT
- user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
- category_code — ENUM('HEALTH_CHECKUP', 'MEDICAL_RECORD', 'GENOME', 'INTEREST') — NOT NULL
- is_connected — BOOLEAN
- sync_status — ENUM('IDLE', 'PROCESSING', 'COMPLETED', 'FAILED')
- last_sync_at — TIMESTAMP
- next_sync_available_at — TIMESTAMP — 재동기화 가능 시점(쿨타임)
user_interests
- activity_id — BIGINT
- user_id — BINARY(16) — Foreign key → users.user_id — NOT NULL
- 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_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 — 다시보지않기 선택 시 해당 시간까지 노출 차단
user_shopping_connections
- shop_conn_id — BIGINT
- user_id — BINARY(16) — Foreign key → users.user_id — 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