AMC_DB
Tables (12)
ANES_INFO (Untitled4)
- ANES_ID (PK) — INT — Primary key — NOT NULL
- OP_ID (Field2) — INT
- FILE_NAME (Field3) — STR
- H5_ID (Key2) — INT — Foreign key → H5_TABLE.H5_ID — NOT NULL
Comorbidity (Untitled)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- OP_DATE (Field) — DATETIME
- POST_OP_CODE (Field2) — STR
- POST_OP_NAME (Field3) — STR
- DEP_CODE (Field4) — STR
- 동반 질환(10가지 항목) (Field5) — INT
DIAGNOSIS (Untitled2)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- ICD_CODE (Field) — FLOAT
- ICD_NAME (Field2) — STR
H5_TABLE (H5 파일 정보)
- H5_ID (Key2) — INT — Primary key — NOT NULL
- FILE_NAME (Field) — STR
- H5_START_TIME (Field2) — DATETIME
- H5_END_TIME (Field3) — DATETIMIE
- ROOM (Field4) — STR
- ECG (Field5) — INT
- ABP (Field6) — INT
- PPG (Field7) — INT
- DEVICE (Field8) — STR
- PRIMUS (Field9) — INT
- CARESCAPE (Field10) — INT
- EV1000 (Field11) — INT
- INTELLIVUE (Field12) — INT
- OHMEDA (Field13) — INT
- ROOT (Field14) — INT
- VIGILANCE (Field15) — INT
- PHILIPS (Field16) — INT
- BIS (Field17) — INT
- CARDIOQ (Field18) — INT
- ORCHESTRA (Field19) — INT
- A500 (Field20) — INT
- PULSIOFLEX (Field21) — INT
LAB (Untitled3)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- LAB_ID (Field) — INT
- OP_DATE (Field2) — DATETIME
- DATE (Field3) — DATETIME
- NAME (Field4) — STR
- RESULT (Field5) — FLOAT
OP_INFO (Untitled5)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- ANES_START (Field) — DATETIME
- ANES_END (Field2) — DATETIME
- OP_START (Field3) — DATETIME
- OP_END (Field4) — DATETIME
- INTUBATION (Field5) — DATETIME
- DEPARTMENT (Field6) — STR
- OP_CODE (Field7) — STR
- OP_ROOM (Field8) — STR
- OP_TYPE_CODE (Field9) — STR
- ANESTYPE (Field10) — STR
OP_TABLE (EMR 수술정보)
- OP_ID (PK) — INT — Primary key — NOT NULL
- H5_ID (FK2) — INT — Foreign key → H5_TABLE.H5_ID — NOT NULL
- ANES_ID (PK2) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- OP_START_TIME (Field) — DATETIME
- OP_END_TIME (Field2) — DATETIME
- ROOM (Field3) — STR
OUTCOME (Untitled6)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- ADM_DATE (Field) — DATETIME
- DISCHARGE_DATE (Field2) — DATETIME
- ICU_STAY (Field3) — INT
- 30DAY_DEATH (Field4) — INT
- AKI (Field5) — INT
PATIENT_INFO (Untitled7)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- SEX (Field) — STR
- AGE (Field2) — INT
- HEIGHT (Field3) — FLOAT
- WEIGHT (Field4) — FLOAT
- ASA (Field5) — INT
- EMERGENCY (Field6) — INT
- BLOOD_TYPE (Field7) — STR
PRE_OP_INFO (Untitled8)
- ANES_ID (PK) — INT — Foreign key → ANES_INFO.ANES_ID — NOT NULL
- PRE_항목_TIME (Field) — DATETIME
- PRE_항목 (Field2) — INT
SIGNAL_KEY (TRACK ID)
- TRACK_ID (Key2) — INT — Primary key — NOT NULL
- RAW_TRACK_NAME (Field) — STR
TRACK_INFO (TRACK 수집 정보)
- H5_ID (Key22) — INT — Foreign key → H5_TABLE.H5_ID — NOT NULL
- TRACK_ID (Key2) — INT — Foreign key → SIGNAL_KEY.TRACK_ID — NOT NULL
- DATA_TIME (Field2) — INT
- DATA_LEN (Field3) — INT
- FREQUENCY (Field4) — FLOAT
- START_TIME (Field5) — DATETIME
- END_TIME (Field6) — DATETIME