Surggram DB ( EMR)
Tables (8)
Anthropometric (CopyOfCopyOfUntitled)
- id (Key4) — Primary key — NOT NULL
- VisitID (Key32) — INT — Foreign key → Visit.VisitID — NOT NULL
- PatientID (Key) — INT — Foreign key → Visit.PatientID — NOT NULL
- height (Key2) — float
- weight (Key3) — float
Diagnosis (CopyOfCopyOfCopyOfUntitled2)
- DiagnosisID (Key3) — INT — Primary key — NOT NULL
- PatientID (Key) — INT — Foreign key → Patient.PatientID — NOT NULL
- Key (Key4) — Foreign key → Surgery.Key — NOT NULL
- surgery Abdominal (Key2) — Bool — NOT NULL — 복부수술경력
Habit Survey (CopyOfCopyOfCopyOfUntitled)
- id (Key4) — Primary key — NOT NULL
- VisitID (Key32) — INT — Foreign key → Visit.VisitID — NOT NULL
- PatientID (Key) — INT — Foreign key → Visit.PatientID — NOT NULL
- smokingStatus (Key2) — int — 1.never 2. quit 3. smoking
- ceased_ago(year) (Key3) — int — smokingStatus: 2
- pack_day(current) (Field) — int
- smoking_year (Field2) — int
- esmkokingStatus (Field3) — int
- esmoking_year (Field4) — int
- drinking (Field5) — bool — 1. never 2. quit 3. current
- drinking_type (Field6) — charset — 술종류 : wine, soju, beer (preset 정리 필요))
- drinking_per_day (Field7) — int
- driking_per_week (Field8) — int
- drinking_year (Field9) — int
Health History (CopyOfCopyOfUntitled2)
- VisitID (Key3) — INT — Primary key — NOT NULL
- PatientID (Key) — INT — Foreign key → Patient.PatientID — NOT NULL
- surgery Abdominal (Key2) — Bool — NOT NULL — 복부수술경력
Patient (환자 정보)
- PatientID (Key) — INT — Primary key — NOT NULL
- Name — VARCHAR(30) — NOT NULL
- Birthday (Field) — Date — NOT NULL
- AssignedGender (Field2) — VARCHAR(255) — NOT NULL
Surgery (Untitled2)
- Key — Primary key — NOT NULL
SurgeryHistory (Untitled)
- surgeryHistoryID (Key) — Primary key — NOT NULL
- VisitID (Key3) — INT — Foreign key → Health History.VisitID — NOT NULL
- PatientID (Key2) — INT — Foreign key → Health History.PatientID — NOT NULL
- Surgical Site (Field) — charset — NOT NULL — 수술부위
- relationship (Field2) — int — NOT NULL — 1.본인 2. 배우자 3. 부모님
Visit (CopyOfUntitled)
- VisitID (Key3) — INT — Primary key — NOT NULL
- PatientID (Key) — INT — Foreign key → Patient.PatientID — NOT NULL
- visitDate (Key2) — DATE — NOT NULL