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