Yakssok
Tables (15)
api_source
- api_source_id — VARCHAR(36) — Primary key — NOT NULL
- provider — VARCHAR(100) — 식약처 DUR / e약은요 / HIRA 내가먹는약
- endpoint — VARCHAR(255)
- license_type — VARCHAR(50) — 공공데이터 이용허락범위 제1~4유형
auth_log
- auth_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- method — VARCHAR(20) — PASS
- verified_at — DATETIME
drug_interaction_warning
- warning_id — VARCHAR(36) — Primary key — NOT NULL
- medication_id — VARCHAR(36) — Foreign key → medication_item.medication_id — NOT NULL
- conflicting_drug_name — VARCHAR(100)
- warning_text — VARCHAR(255)
- severity — VARCHAR(20)
- api_source_id — VARCHAR(36) — Foreign key → api_source.api_source_id
- checked_at — DATETIME
drug_master
- drug_code — VARCHAR(36) — Primary key — NOT NULL
- generic_name — VARCHAR(100)
- product_name — VARCHAR(100)
- official_name — VARCHAR(100) — 대한민국약전명
- category — VARCHAR(50)
emergency_info
- info_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- surgery_history — TEXT
- allergy_info — TEXT
- sensitive_info_consent — BOOLEAN
- updated_at — DATETIME
family_group
- group_id — VARCHAR(36) — Primary key — NOT NULL
- plan_type — VARCHAR(20) — 베이직(2인)/프리미엄(3인이상)
- owner_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- status — VARCHAR(20)
family_membership
- membership_id — VARCHAR(36) — Primary key — NOT NULL
- group_id — VARCHAR(36) — Foreign key → family_group.group_id — NOT NULL
- member_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- guardian_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- relation — VARCHAR(30)
- verification_type — VARCHAR(30) — 가족관계증명서/성년후견/한정후견
- consent_status — VARCHAR(30) — 본인동의완료/후견권한확인필요/보류
- guardian_authority_doc_ref — VARCHAR(255) — 후견심판문 등 증빙 참조
- member_data_share_consent — BOOLEAN — 피보호자 본인의 정보공유 동의 여부
- verified_at — DATETIME
medication_item
- medication_id — VARCHAR(36) — Primary key — NOT NULL
- record_id — VARCHAR(36) — Foreign key → prescription_record.record_id — NOT NULL
- drug_code — VARCHAR(36) — Foreign key → drug_master.drug_code
- drug_name — VARCHAR(100)
- ingredient — VARCHAR(100)
- dosage — VARCHAR(50) — 1회 투약량
- frequency — VARCHAR(50) — 1일 n회
- duration_days — INT
- usage_instruction — VARCHAR(255) — 복약 안내
- drug_type — VARCHAR(20) — 전문의약품 / 일반의약품 / 영양제
- is_current — BOOLEAN — 현재 복용 여부
medication_log
- log_id — VARCHAR(36) — Primary key — NOT NULL
- schedule_id — VARCHAR(36) — Foreign key → medication_schedule.schedule_id — NOT NULL
- log_date — DATE
- status — VARCHAR(20) — 복용완료/미완료/리마인드발송
- taken_at — DATETIME
- reminder_sent_at — DATETIME
medication_schedule
- schedule_id — VARCHAR(36) — Primary key — NOT NULL
- medication_id — VARCHAR(36) — Foreign key → medication_item.medication_id — NOT NULL
- time_slot — VARCHAR(20) — 아침/점심/저녁/커스텀(안약등)
- scheduled_time — TIME
- reminder_offset_minutes — INT
- is_custom — BOOLEAN
otc_medication
- otc_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- name — VARCHAR(100)
- dose — VARCHAR(50)
- frequency — VARCHAR(50)
- api_ref_id — VARCHAR(100)
payment
- payment_id — VARCHAR(36) — Primary key — NOT NULL
- group_id — VARCHAR(36) — Foreign key → family_group.group_id — NOT NULL
- plan — VARCHAR(20)
- amount — INT
- billing_date — DATE
- status — VARCHAR(20)
prescription_record
- record_id — VARCHAR(36) — Primary key — NOT NULL
- patient_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL — 실제 약을 복용하는 사람
- registered_by_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL — 등록한 사람(본인 또는 가족관리자)
- source_type — VARCHAR(20) — 처방전 / 조제약봉투
- hospital_name — VARCHAR(100)
- pharmacy_name — VARCHAR(100)
- disease_code — VARCHAR(20)
- disease_name — VARCHAR(100)
- issue_date — DATE — 교부일(조제일)
- ocr_status — VARCHAR(20) — 인식성공/수정됨/실패
- sensitive_info_consent — BOOLEAN — 민감정보 별도동의 여부 - 필수
- created_at — DATETIME
- purge_scheduled_at — DATETIME — 파기 예정일, 목적달성 기준
user_consent
- consent_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key — NOT NULL
- consent_type — VARCHAR(30) — 개인정보수집이용/민감정보처리/제3자제공/마케팅수신
- policy_version — VARCHAR(20) — 동의 시점의 약관/정책 버전
- agreed — BOOLEAN — NOT NULL
- agreed_at — DATETIME — NOT NULL
- revoked_at — DATETIME
- consent_channel — VARCHAR(20) — app/web
users
- user_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — VARCHAR(10)
- birth_year — INT
- phone_number_hash — VARCHAR(255)
- login_type — VARCHAR(20) — app / kakao / toss
- pass_verified — BOOLEAN
- ci_di_token — VARCHAR(255) — PASS 연계정보 토큰, 주민번호 원본 미저장
- role — VARCHAR(20) — 개인 / 가족관리자
- created_at — DATETIME
- withdrawn_at — DATETIME