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