PT10

Tables (24)

TB_Dynamic_Range

  • AnalyteID — TEXT — Primary key — NOT NULL
  • PanelID — TEXT — Primary key — NOT NULL
  • ApplyDate_From — DATE — Primary key — NOT NULL
  • ReagentVersion — TEXT — Primary key — NOT NULL
  • Dynamic_Min — REAL — NOT NULL
  • Dynamic_Max — REAL — NOT NULL

Tb_Analyte_Info

  • Analyte_ID — VARCHAR(4) — Primary key — NOT NULL
  • Analyte_Name — VARCHAR(5) — 검사항목명
  • Analyte_Full_name — VARCHAR(50)
  • RefRange_Min — FLOAT — 범위
  • RefRange_Max — FLOAT — 범위
  • RefRange_User — INTEGER
  • Dynamic_Min — FLOAT
  • Dynamic_Max — FLOAT
  • Unit — VARCHAR(10) — 단위
  • SI_Unit — VARCHAR(10)
  • Unit_Flag — BOOLEAN
  • Conversion_factor — FLOAT
  • Conversion_Offset — FLOAT
  • DecimalNo — SMALLINT
  • SI_DecimalNo — SMALLINT
  • QC_Flag — CHAR(1)
  • InstFactor_A — FLOAT
  • InstFactor_B — FLOAT
  • LOINC — VARCHAR(10)
  • SI_LOINC — VARCHAR(10)
  • Serum_HEM — FLOAT
  • Serum_ICT — FLOAT
  • Serum_LIP — FLOAT

Tb_Analyte_Rank

  • AnalyteID — VARCHAR(4) — Primary key — NOT NULL
  • PanelID — CHAR(3) — Primary key — NOT NULL
  • Rank — INTEGER
  • Enable — CHAR(1)

Tb_Calibration_SerialNum

  • SerialNumber — VARCHAR(13) — Primary key — NOT NULL
  • Date — DATE
  • LOTNumber — VARCHAR(8)
  • ConcentrationA — FLOAT
  • ConcentrationB — FLOAT
  • ResultA — FLOAT
  • ResultB — FLOAT

Tb_Calibration_Summary

  • LOTNumber — VARCHAR(8) — Primary key — NOT NULL
  • Date — DATE — Primary key — NOT NULL
  • CoeffA_1 — FLOAT
  • CoeffA_2 — FLOAT
  • CoeffA_3 — FLOAT
  • CoeffA_4 — FLOAT
  • CoeffA_5 — FLOAT
  • CoeffB_1 — FLOAT
  • CoeffB_2 — FLOAT
  • CoeffB_3 — FLOAT
  • CoeffB_4 — FLOAT
  • CoeffB_5 — FLOAT

Tb_Canceled_Result

  • SerialNumber — VARCHAR(13) — Primary key — NOT NULL

Tb_Control_Summary

  • Analyte_ID — VARCHAR(4) — Primary key — NOT NULL
  • Control_Type — INTEGER
  • LastTest_Date — DATE
  • Num — INTEGER
  • Average — FLOAT
  • Stdev_val — FLOAT
  • QC_Flag — CHAR(1)
  • Warning — BOOLEAN
  • Panel_Type — CHAR(1) — NOT NULL
  • Name — VARCHAR(14)
  • Level — INTEGER
  • Lot — VARCHAR(14)

Tb_Ctrl_Data

  • Result — FLOAT
  • QCFlag — CHAR(1)
  • ControlType — INTEGER
  • TargetMean — FLOAT
  • TargetSD — FLOAT
  • Min — FLOAT
  • Max — FLOAT
  • RuleFlag — INTEGER
  • SelectedRule — INTEGER
  • CalcMean — FLOAT
  • CalcSD — FLOAT
  • FinalOD — FLOAT
  • BubbleOccur — CHAR(1)
  • Dynamic_Min — REAL
  • Dynamic_Max — REAL
  • ControlID — VARCHAR(5) — Foreign key → Tb_Ctrl_Summary.ControlID — NOT NULL
  • Date — DATE — Foreign key → Tb_Ctrl_Summary.Date — NOT NULL
  • AnalyteID — VARCHAR(4) — Foreign key → Tb_Analyte_Info.Analyte_ID — NOT NULL

Tb_Ctrl_Summary

  • ControlID — VARCHAR(5) — Primary key — NOT NULL
  • Date — DATE — Primary key — NOT NULL
  • PanelID — CHAR(3)
  • PanelType — CHAR(1)
  • ControlType — INTEGER
  • ErrorCode — INTEGER
  • ErrorLevel — CHAR(1)
  • BloodInfo — INTEGER
  • TestType — VARCHAR(1)
  • PCSync — BOOLEAN
  • SerialNumber — VARCHAR(13)
  • AvailablePeriod — VARCHAR(13)
  • LOTNumber — VARCHAR(8)
  • QCMaterialName — VARCHAR(14)
  • QCMaterialLevel — INTEGER
  • QCMaterialLotNum — VARCHAR(14)
  • QCMaterialExpiredDate — VARCHAR(8)
  • POCTSendFlag — CHAR(1)
  • OperatorID — VARCHAR(14)
  • PanelShortName — CHAR(10)
  • Operator_rowid — INTEGER
  • AppSWVer — VARCHAR(20)
  • SysSWVer — VARCHAR(20)
  • XmlSWVer — VARCHAR(20)
  • ReagentVersion — TEXT
  • QCValueVersion — TEXT

Tb_Detection_Result

  • Date — DATE — Primary key — NOT NULL
  • FilterName — CHAR(1) — Primary key — NOT NULL
  • PanelID — VARCHAR(3)
  • SerialNumber — VARCHAR(13)
  • L340 — FLOAT
  • L405 — FLOAT
  • L450 — FLOAT
  • L500 — FLOAT
  • L550 — FLOAT
  • L570 — FLOAT
  • L600 — FLOAT
  • L630 — FLOAT
  • L660 — FLOAT
  • L700 — FLOAT

Tb_EMR_Order

  • PatientID — VARCHAR(20) — Primary key — NOT NULL
  • InsertedDate — DATE — Primary key — NOT NULL
  • ControlID — VARCHAR(20)
  • ServiceID — VARCHAR(40)
  • OrderNumber — VARCHAR(20)
  • OrderTime — DATE
  • ChangedDate — DATE
  • OrderFlag — CHAR(2)
  • GivenName — VARCHAR(20)
  • FamilyName — VARCHAR(20)
  • Birth — DATE
  • Sex — CHAR(1)
  • Weight — FLOAT
  • SendingApp — VARCHAR(20)
  • SendingFacility — VARCHAR(20)
  • ModuleName — VARCHAR(20)
  • Provider — VARCHAR(20)
  • SpecimenType — VARCHAR(5)
  • SpecimenRole — VARCHAR(5)
  • Status — CHAR(2)
  • SendResultFlag — CHAR(1)
  • Priority — CHAR(1)
  • Race — CHAR(1)
  • SpeciesID — TEXT
  • PanelShortName — CHAR(10)
  • ClientID — VARCHAR(14)

Tb_ErrorCode

  • Code — INTEGER — Primary key — NOT NULL
  • Level — CHAR(1) — Primary key — NOT NULL
  • Language — CHAR(1) — Primary key — NOT NULL
  • Title — VARCHAR(64)
  • Guide — TEXT
  • Version — INTEGER

Tb_History

  • Version — VARCHAR(13) — NOT NULL
  • Date — DATE
  • Description — VARCHAR(128)

Tb_Mobile_Device

  • MACAddress — VARCHAR(20) — Primary key — NOT NULL
  • PhoneNumber — VARCHAR(20) — NOT NULL
  • Register — CHAR(1)
  • RegisterDate — DATE
  • UnRegisterDate — DATE
  • LastSyncRow — INTEGER
  • MobileAppVer — VARCHAR(20)
  • MobileModelName — VARCHAR(30)
  • LastSyncRowQC — INTEGER
  • SDT_Sync — VARCHAR(10)
  • LastSyncDateResult — DATE
  • LastSyncDateQC — DATE

Tb_Operator_List

  • OperatorID — TEXT — Primary key — NOT NULL
  • OperatorName — TEXT
  • InsertedDate — DATE
  • ActiveDate — DATE
  • ExpirationDate — DATE
  • Password — TEXT
  • Valid — TEXT
  • PasswordType — INTEGER

Tb_QC_Material

  • QCName — VARCHAR(14) — Primary key — NOT NULL
  • QCLevel — INTEGER — Primary key — NOT NULL
  • QCLotNumber — VARCHAR(14) — Primary key — NOT NULL
  • QCValueVersion — TEXT — Primary key — NOT NULL
  • QCExpiredDate — VARCHAR(8)
  • Modifier — VARCHAR(10)

Tb_QC_Material_Analytes

  • Analyte_ID — VARCHAR(4) — Primary key — NOT NULL
  • QCName — VARCHAR(14) — Primary key — NOT NULL
  • QCLevel — INTEGER — Primary key — NOT NULL
  • QCLotNumber — VARCHAR(14) — Primary key — NOT NULL
  • QCValueVersion — TEXT — Primary key — NOT NULL
  • Mean — FLOAT
  • SD — FLOAT
  • Min — FLOAT
  • Max — FLOAT
  • Rules — CHAR(1)
  • SelectedRule — INTEGER

Tb_RM_Msg

  • Date — DATE — Primary key — NOT NULL
  • Code — CHAR(16)
  • Msg — VARCHAR(2000)
  • Category — CHAR(16)
  • ExamID — CHAR(16)
  • ExamDate — DATE
  • ViewLog — CHAR(24)
  • TemperatureFile — VARCHAR(30)
  • Sent — BOOLEAN
  • PanelType — CHAR(4)
  • ControlType — Integer
  • ErrorLogSession — VARCHAR(20)
  • ErrorTitle — VARCHAR(250)
  • ErrorGuide — VARCHAR(250)

Tb_Result_Data

  • Result — FLOAT — 결과값
  • QCFlag — CHAR(1)
  • RefRange_Min — FLOAT
  • RefRange_Max — FLOAT
  • UnitFlag — BOOLEAN
  • SiResult — FLOAT
  • Unit — VARCHAR(10)
  • SiUnit — VARCHAR(10)
  • FinalOD — FLOAT
  • AbFlag — VARCHAR(4)
  • BubbleOccur — CHAR(1)
  • Dynamic_Min — REAL
  • Dynamic_Max — REAL
  • PatientID (ControlID) — VARCHAR(5) — Foreign key → Tb_Result_Summary.PatientID — NOT NULL
  • Date — DATE — Foreign key → Tb_Result_Summary.Date — NOT NULL

Tb_Result_Statistics

  • Date — DATE — NOT NULL
  • PanelID — VARCHAR(3)

Tb_Result_Summary

  • PatientID (ControlID) — VARCHAR(5) — Primary key — NOT NULL
  • Date — DATE — Primary key — NOT NULL — 검사시간
  • PanelID — VARCHAR(3) — 패널ID
  • TestType — CHAR(1)
  • BloodInfo — INTEGER
  • PCSync — BOOLEAN — PC전송여부
  • SerialNumber — VARCHAR(13) — 디스크제조번호
  • AvailablePeriod — VARCHAR(13) — 디스크유효기간
  • LOTNumber — VARCHAR(8) — 디스크LOT
  • ErrorCode — INTEGER — 에러코드
  • ErrorLevel — CHAR(1) — 심각도
  • OperatorID — VARCHAR(14) — 관리자ID
  • Sex — CHAR(1) — 성별
  • Birth — DATE — 생년월일
  • OrderInsertedDate — DATE — EMR요청시간
  • SerumResultHEM — FLOAT
  • SerumResultICT — FLOAT
  • SerumResultLIP — FLOAT
  • POCTSendFlag — CHAR(1)
  • Weight — FLOAT
  • Race — CHAR(1)
  • SpeciesID — TEXT
  • PanelShortName — CHAR(10)
  • Operator_rowid — INTEGER
  • Age — INTEGER
  • ClientID — VARCHAR(14)
  • SpecimenType — VARCHAR(10)
  • AppSWVer — VARCHAR(20)
  • SysSWVer — VARCHAR(20)
  • XmlSWVer — VARCHAR(20)
  • SerumIndexHEM — TEXT
  • SerumIndexICT — TEXT
  • SerumIndexLIP — TEXT
  • ReagentVersion — TEXT
  • SpeciesClass — TEXT — 종

Tb_SelfTest

  • Date — DATE — Primary key — NOT NULL
  • canceled — BOOLEAN
  • Power_ErrCode — INTEGER
  • Power_ErrLvl — VARCHAR(1)
  • LaserMotor_ErrCode — INTEGER
  • LaserMotor_ErrLvl — VARCHAR(1)
  • LaserDiode1_ErrCode — INTEGER
  • LaserDiode1_ErrLvl — VARCHAR(1)
  • LaserDiode2_ErrCode — INTEGER
  • LaserDiode2_ErrLvl — VARCHAR(1)
  • Heater1_ErrCode — INTEGER
  • Heater1_ErrLvl — VARCHAR(1)
  • Heater2_ErrCode — INTEGER
  • Heater2_ErrLvl — VARCHAR(1)
  • TempIC_ErrCode — INTEGER
  • TempIC_ErrLvl — VARCHAR(1)
  • Tray_ErrCode — INTEGER
  • Tray_ErrLvl — VARCHAR(1)
  • MainMotor_ErrCode — INTEGER
  • MainMotor_ErrLvl — VARCHAR(1)
  • HomePosition_ErrCode — INTEGER
  • HomePosition_ErrLvl — VARCHAR(1)
  • Barcode_ErrCode — INTEGER
  • Barcode_ErrLvl — VARCHAR(1)
  • Detector_ErrCode — INTEGER
  • Detector_ErrLvl — VARCHAR(1)
  • Print_ErrCode — INTEGER
  • Print_ErrLvl — VARCHAR(1)
  • Etc — TEXT
  • PlungerMotor_ErrCode — INTEGER
  • PlungerMotor_ErrLvl — VARCHAR(1)
  • CameraBlu_ErrCode — INTEGER
  • CameraBlu_ErrLvl — VARCHAR(1)
  • DetectorMotor_ErrCode — INTEGER
  • DetectorMotor_ErrLvl — VARCHAR(1)
  • DetectorLED_ErrCode — INTEGER
  • DetectorLED_ErrLvl — VARCHAR(1)
  • CatridgeSensor_ErrCode — INTEGER
  • CatridgeSensor_ErrLvl — VARCHAR(1)
  • EQC_ErrCode — INTEGER
  • EQC_ErrLvl — VARCHAR(1)
  • AppSWVer — VARCHAR(20)
  • SysSWVer — VARCHAR(20)
  • XmlSWVer — VARCHAR(20)

Tb_Species_Feature

  • SpeciesID — TEXT — Primary key — NOT NULL
  • AnalyteID — TEXT — Primary key — NOT NULL
  • Class — TEXT
  • Breed — TEXT
  • Gender — TEXT
  • AgeMin — INTEGER
  • AgeMax — INTEGER
  • RefRange_Min — REAL
  • RefRange_Max — REAL
  • RefRange_User — INTEGER
  • RefRange_DefMin — REAL
  • RefRange_DefMax — REAL
  • DisplayPosition — INTEGER
  • IsDefaultSpecies — INTEGER
  • SpeciesInstFactor_A — FLOAT
  • SpeciesInstFactor_B — FLOAT

Tb_Update_History

  • ModuleName — TEXT
  • UpdateCompleteTime — DATE
  • ElapsedTime — TEXT
  • OldVersion — TEXT
  • NewVersion — TEXT
  • Method — TEXT