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