bionet
Tables (7)
Trend
- regist_log_date — DATETIME — Primary key — NOT NULL
- unit_patient_key — INT — Foreign key → patient.unit_patient_key — NOT NULL
- HR — VARCHAR — NOT NULL
- RR — VARCHAR — NOT NULL
- TP — NOT NULL
USER (user)
- user_id — VARCHAR(20) — Primary key — NOT NULL
- clinic_key — INT
- user_pw — VARCHAR(150) — NOT NULL
- user_first_name — VARCHAR(10) — NOT NULL
- user_last_name — VARCHAR(10) — NOT NULL
- user_type — VARCHAR(10) — NOT NULL
- user_phone_num — VARCHAR(15) — NOT NULL
- user_email — VARCHAR(30) — NOT NULL
- user_regist_day — VARCHAR(30) — NOT NULL
alarm_default
- alarm_default_admission_date — datetime — Primary key — NOT NULL
- alarm_HR_max — int — NOT NULL
- alarm_HR_min — int — NOT NULL
- alarm_RR_max — int — NOT NULL
- alarm_RR_min — int — NOT NULL
- alarm_TP_max — int — NOT NULL
- alarm_TP_min — int — NOT NULL
- alarm_Type — varchar(20) — NOT NULL
- alarm_on_off — bool — NOT NULL
alarm_history
- alarm_date — datetime — Primary key — NOT NULL
- unit_patient_key — INT — Foreign key → patient.unit_patient_key — NOT NULL
- HR — int
- RR — INT
- TP — INT
- message — VARCHAR
- alarm_type — VARCHAR
- set_HR_max — INT
- set_HR_min — INT
- set_RR_max — INT
- set_RR_min — INT
- set_TP_max — INT
- set_TP_min — INT
clinic
- clinic_key — INT — Primary key — NOT NULL
- clinic_name — varchar(20) — NOT NULL
- clinic_address — varchar(30) — NOT NULL
- clinic_type — varchar(10) — NOT NULL
- clinic_phone_num — varchar(15) — NOT NULL
- clinic_email — varchar(30) — NOT NULL
- is_clinic_regist — bool — NOT NULL
- clinic_regit_day — VARCHAR(20) — NOT NULL
- clinic_apply_usernum — VARCHAR(15) — NOT NULL
- clinic_image — VARCHAR(50) — NOT NULL
- clinic_apply_period — INT — NOT NULL
patient
- unit_patient_key — INT — Primary key — NOT NULL
- unit_id — VARCHAR(50) — Foreign key → unit.unit_id — NOT NULL
- clinic_key — INT — Foreign key → unit.clinic_key — NOT NULL
- patient_admission_date — datetime — NOT NULL
- patient_id — VARCHAR — NOT NULL
- patient_name — VARCHAR
- patient_species — VARCHAR
- alarm_HR_max — INT
- alarm_HR_min — INT — NOT NULL
- alarm_RR_max — INT
- alarm_RR_min — INT
- alarm_TP_max — INT
- alarm_TP_min — INT
- alarm_Type — varvhar
- alarm_on_off — bool
unit
- unit_id — VARCHAR(50) — Primary key — NOT NULL
- clinic_key — INT — Foreign key → clinic.clinic_key — NOT NULL
- temperature_device_id — VARCHAR(50) — NOT NULL
- ecg_device_id — VARCHAR(50) — NOT NULL
- is_monitored — Bool — NOT NULL
- Field