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