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 끌어오기에 사용)