RAG실습2
테이블 (10)
chatbot_responses (CopyOfUntitled2)
- response_id (Key) — PK — 기본 키 — NOT NULL
- user_id (사용자ID) — FK — 외래 키 → users.user_id — NOT NULL
- user_question (Field2)
- generated_response (Field3)
- response_date (Field4)
community_answers (CopyOfUntitled4)
- answer_id (Key) — PK — 기본 키 — NOT NULL
- question_id (Key2) — FK — 외래 키 → community_questions.question_id — NOT NULL
- user_id (사용자ID) — FK — 외래 키 → users.user_id — NOT NULL
- content (Field4)
- answer_date (Field)
community_questions (CopyOfUntitled3)
- question_id (Key) — PK — 기본 키 — NOT NULL
- user_id (사용자ID) — FK — 외래 키 → users.user_id — NOT NULL
- title (Field2)
- content (Field3)
- question_date (Field5)
drug_interactions (Drug_interactions)
- interaction_id (Key) — PK — 기본 키 — NOT NULL
- drug1_id (Key2) — FK — 외래 키 → medicine_interactions.drug1_id — NOT NULL
- drug2_id (Key22) — FK — 외래 키 → medicine_interactions.drug2_id — NOT NULL
- interaction_level (Field3)
- precaution (Field4)
medicine_interactions
- drug1_id (Key) — PK — 기본 키 — NOT NULL
- drug2_id (Key2) — PK — 기본 키 — NOT NULL
medicines (CopyOfUntitled6)
- medicine_id (Key) — PK — 기본 키 — NOT NULL
- medicine_name (Field)
- ingredient (Field2)
- effect (Field3)
- manufacturer (Field5)
- image_url (Field4)
- precaution (Field6)
pharmacy (Pharmacy)
- PharmacyID (Key) — PK — 기본 키 — NOT NULL
- PharmacyName (Field)
- Address (Field2)
- Phone (Field3)
- OperatingHours (Field4)
prescriptions (CopyOfUntitled10)
- prescription_id (Key) — PK — 기본 키 — NOT NULL
- user_id (사용자ID) — FK — 외래 키 → users.user_id — NOT NULL
- image_path (Field)
- extracted_text (Field2)
- upload_date (Field3)
search_history (CopyOfUntitled5)
- search_id (Key) — PK — 기본 키 — NOT NULL
- user_id (사용자ID) — FK — 외래 키 → users.user_id — NOT NULL
- search_term (Field2)
- search_date (Field3)
users (CopyOfUntitled)
- user_id (사용자ID) — PK — 기본 키 — NOT NULL
- name (Field)
- email (Field2)
- password (Field3)
- user_type (Field4) — 'general' 또는 'doctor'
- registration_date (Field5)