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