알약

테이블 (7)

analysis_results

  • analysis_id — bigint — 기본 키 — NOT NULL
  • log_id — bigint — 외래 키 → identification_logs.log_id — NOT NULL
  • has_dur_violation — boolean
  • dur_warning_summary — varchar(55)
  • safety_instruction — text
  • analyzed_at — timestamptz

dur_rules

  • rule_id — bigint — 기본 키 — NOT NULL
  • rule_type — varchar(50) — NOT NULL
  • prohibit_item_seq_a — varchar(50) — NOT NULL
  • prohibit_item_seq_b — varchar(50)
  • age_limit_under — int
  • notice_message — varchar(255) — NOT NULL

identification_logs

  • log_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.user_id — NOT NULL
  • uploaded_image_url — varchar(512) — NOT NULL
  • analysis_engine — varchar(50)
  • accuracy_score — int
  • detected_medicine_id — bigint — 외래 키 → medicines.medicine_id
  • created_at — timestamptz

medicines

  • medicine_id — bigint — 기본 키 — NOT NULL
  • item_seq — varchar(50) — NOT NULL
  • item_name — varchar(255) — NOT NULL
  • entp_name — varchar(255)
  • hira_medi_class_code — varchar(50)

pill_details

  • pill_detail_id — bigint — 기본 키 — NOT NULL
  • medicine_id — bigint — 외래 키 → medicines.medicine_id — NOT NULL
  • drug_shape — varchar(50)
  • color_front — varchar(50)
  • print_front — varchar(100)
  • pill_image_url — varchar(512)
  • efcy_qesitm — text
  • use_method_qesitm — text
  • atnc_qesitm — text

user_medication_history

  • history_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.user_id — NOT NULL
  • medicine_id — bigint — 외래 키 → medicines.medicine_id — NOT NULL
  • is_active — boolean
  • started_at — date
  • ended_at — date

users

  • user_id — bigint — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • birth_date — date — NOT NULL
  • is_pregnant — boolean
  • created_at — timestamptz