스마트병원 모니터링
테이블 (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