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