스마트병원 모니터링

테이블 (5)

patient_monitor_data

  • id — 기본 키 — NOT NULL — PK
  • heart_rate
  • blood_pressure — VARCHAR
  • oxygen_saturation — INT
  • respiratory_rate — INT
  • mapping_number — VARCHAR
  • Key (device_id) — 외래 키 → 센서.Key — NOT NULL
  • 생성시각 (created_at) — TIMESTAMP
  • Field (patient_name)

병상 (beds)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 호실 (room_number) — INT — NOT NULL
  • 병상번호 (bed_number) — INT — NOT NULL
  • Field (patient_name) — VARCHAR(255)

센서 (devices)

  • Key (id) — VARCHAR(128) — 기본 키 — NOT NULL
  • Field (device_name) — VARCHAR(255) — NOT NULL
  • Field (device_type) — VARCHAR(128) — NOT NULL
  • Key (bed_id) — BIGINT — 외래 키 → 병상.Key — NOT NULL — 센서가 할당되어 있는 bed id

센서 데이터 (sensor_data)

  • id — BIGINT — 기본 키 — NOT NULL — PK
  • Field (patient_name) — VARCHAR(255)
  • Field (category_code) — VARCHAR(64) — NOT NULL
  • Field2 (event_type) — VARCHAR(128) — NOT NULL
  • Field3 (event_code) — VARCHAR(128) — NOT NULL
  • 센서데이터 생성시각 (timestamp) — TIMESTAMP — NOT NULL
  • Key (device_id) — VARCHAR(128) — 외래 키 → 센서.Key — NOT NULL
  • Field6 (device_name) — VARCHAR(255) — NOT NULL
  • Field7 (sensor_state) — VARCHAR(128) — NOT NULL
  • Field8 (sensor_type) — VARCHAR(128) — NOT NULL
  • Field9 (sensor_value) — INT — NOT NULL
  • 레코드 생성시각 (created_at) — DATETIME — NOT NULL

위치 데이터 (location_data)

  • id — BIGINT — 기본 키 — NOT NULL — PK
  • Field (patient_name) — VARCHAR(255)
  • Field (scanner_id) — VARCHAR(128) — NOT NULL
  • Field (category_code) — VARCHAR(64) — NOT NULL
  • Field (event_type) — VARCHAR(128) — NOT NULL
  • Field (event_code) — VARCHAR(128) — NOT NULL
  • Field (timestamp) — TIMESTAMP — NOT NULL
  • Key (device_id) — VARCHAR(128) — 외래 키 → 센서.Key — NOT NULL
  • Field5 (device_name) — VARCHAR(255) — NOT NULL
  • Field2 (location_floor) — INT — NOT NULL
  • Field3 (location_lat) — DECIMAL(9,6) — NOT NULL
  • Field4 (location_lng) — DECIMAL(9,6) — NOT NULL
  • Field3 (zone_id) — INT — NOT NULL
  • (zone_type) — VARCHAR(128) — NOT NULL
  • Field6 (zone_name) — VARCHAR(128) — NOT NULL
  • Field (zone_in_out_state) — VARCHAR(64) — NOT NULL
  • 센서데이터 생성시각 (zone_timestamp) — DATETIME — NOT NULL
  • 레코드 생성시각 (created_at) — DATETIME — NOT NULL