TEMP
Tables (7)
MeasureCondition
- id — BIGINT
- type — VARCHAR(50)
- start — VARCHAR(50)
- step — VARCHAR(50)
- end — VARCHAR(50)
- period — VARCHAR(50)
MeasurementData
- data_id — BIGINT
- group_id — INT — NOT NULL
- time — BIGINT
- temperature — FLOAT
- pressure — FLOAT
- impedance — FLOAT
- impedance_phase — FLOAT
- voltage — INT
- frequency — INT
MeasurementGroup
- group_id — INT
- patient_id — VARCHAR(50) — NOT NULL
- sensor_address — VARCHAR(100) — NOT NULL
- attach_site — VARCHAR(50)
- start_time — BIGINT
- alert_count — INT
PatientInfo
- id — VARCHAR(50)
- name — VARCHAR(100)
- birth — VARCHAR(100)
- sex — VARCHAR(10)
- user_id — VARCHAR(50) — NOT NULL
- sequence_number — INT
- measuring — INT
- age — INT
- ageGroup — VARCHAR(20)
- reg_date — BIGINT
SensorInfo
- address — VARCHAR(100)
- number — INT
- name — VARCHAR(100)
- patient_id — VARCHAR(50) — NOT NULL
- age_group — VARCHAR(20)
- attached_image — VARCHAR(255)
- attach_site — VARCHAR(50)
- distance — VARCHAR(50)
- timer_time — BIGINT
- start_time — BIGINT
- condition_volt_preset_id — INT
- condition_freq_preset_id — INT
- state — VARCHAR(20)
- last_alert_measure_id — INT
UserInfo
- id — VARCHAR(50)
- name — VARCHAR(100)
- password — VARCHAR(255)
- hospital — VARCHAR(100)
- department — VARCHAR(100)
- login_time — BIGINT
UserLog
- time — BIGINT
- action — VARCHAR(100)
- user_id — VARCHAR(50)
- patient_id — VARCHAR(50)
- message — VARCHAR(255)