db rag 과제 2

테이블 (5)

Record

  • RecordID (Key) — NUMBER — 기본 키 — NOT NULL
  • Opinion (Field) — CLOB
  • PreviousConditions (Field2) — CLOB
  • Name (Field3) — VARCHAR2(100)
  • UserID (Key3) — NUMBER — 외래 키 → User.UserID — NOT NULL
  • ServiceID (Key4) — NUMBER — 외래 키 → Service.ServiceID — NOT NULL

SearchHistory

  • SearchID (Key) — NUMBER — 기본 키 — NOT NULL
  • AdditionalInfo (Field) — CLOB
  • CreationDate (Field2) — DATE
  • SerchRecordID (Field3) — NUMBER
  • RecordID (Key2) — NUMBER — 외래 키 → Record.RecordID — NOT NULL

Service

  • ServiceID (Key) — NUMBER — 기본 키 — NOT NULL
  • PatientName (Field) — VARCHAR2(100)
  • PatientCode (Field2) — VARCHAR2(50)
  • CurrentCondition (Field3) — VARCHAR2(255)

Specialist

  • SpecialistID (Key) — NUMBER — 기본 키 — NOT NULL
  • SpecialistName (Field) — VARCHAR2(100)
  • SpecialistCode (Field2) — VARCHAR2(50)
  • Specialty (Field3) — VARCHAR2(100)
  • Affiliation (Field4) — VARCHAR2(255)

User

  • UserID (Key) — NUMBER — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR2(100)
  • Password (Field2) — VARCHAR2(100)
  • RegistrationDate (Field3) — DATE