알약
테이블 (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