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)