FIT-CHECKER
Tables (6)
br_circumference (Untitled)
- circumferenceIndex (Field2) — VARCHAR — Primary key
- measurementId (Key2) — VARCHAR — Foreign key → br_measurement.measurementId — NOT NULL
- circumference (Field) — VARCHAR
br_measurement (Untitled2)
- measurementId (Key) — VARCHAR — Primary key — NOT NULL
- PATIENT_ID (Key2) — VARCHAR — Foreign key → br_patient.PATIENT_ID — NOT NULL
- dateTime (Field) — datetime
br_patient (Untitled3)
- PATIENT_ID (Key) — VARCHAR — Primary key — NOT NULL
- NAME (Field) — VARCHAR
- LAST_UPDATE (Field2) — datetime
- SEX (Field3) — VARCHAR
- ID_NUMBER (Field4) — VARCHAR
- PHONE (Field5) — VARCHAR
- PATIENT_NUMBER (Field6) — VARCHAR
- ADMISSIVE_CH (Field7) — VARCHAR
- ADDRESS (Field8) — VARCHAR
- HEIGHT (Field9) — VARCHAR
- WEIGHT (Field10) — VARCHAR
- TARGET_WEIGHT (Field11) — VARCHAR
br_queue (Untitled4)
- QUEUE_ID (Key) — VARCHAR — Primary key — NOT NULL
- PATIENT_ID (Key2) — VARCHAR — Foreign key → br_patient.PATIENT_ID — NOT NULL
- IS_MEASURING (Field) — TINYINT
- PRIORITY (Field2) — INT
br_staff (Untitled5)
- hospitalId (Key) — VARCHAR — Primary key — NOT NULL
- email (Field) — VARCHAR
- hospitalname (Field2) — VARCHAR
- password (Field3) — VARCHAR
br_volume (부피 데이터)
- volumeIndex (Field2) — Primary key
- measurementId (Key) — VARCHAR — Foreign key → br_measurement.measurementId — NOT NULL
- volume (Field) — VARCHAR