SurgGram DB

Tables (4)

Survey (Survey)

  • id (key) — Primary key — NOT NULL — Survey시 생성
  • date (SurveyDate)
  • string (Sex)
  • string (HospitalId) — 병원내 PatientId(EMR 끌어오기에 사용)

Anthropometric_Data (신체계측)

  • Key — Primary key — NOT NULL
  • date (MesaureDate)
  • decimal (Height)
  • decimal (Weight)
  • deicmal (BMI)
  • patientId (key) — Foreign key → Patient.id — NOT NULL — Patient연결

HealthHistory (과거력)

  • id (key) — Primary key — NOT NULL — History 끌어오기시 생성
  • boolean (SurveyDate)
  • boolean (Sex)
  • boolean (HospitalId) — 병원내 PatientId(EMR 끌어오기에 사용)

Patient (Register)

  • id (key) — Primary key — NOT NULL — Case Register 시 생성
  • date (Birthday)
  • string (Sex)
  • string (HospitalId) — 병원내 PatientId(EMR 끌어오기에 사용)