ITOS
Tables (30)
TB_ADDPACKETDATA
- PacketID — varchar(6) — Primary key — NOT NULL
- BytePosition — int — Primary key — NOT NULL
- MomMnemonic — varchar(200) — Primary key — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_ADDPACKETLIST
- Version — int — Primary key — NOT NULL
- PacketID — varchar(6) — Primary key — NOT NULL
- PacketTitle — varchar(100)
- CreatedDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_ADDPACKET_HISTORY
- Version — int — Primary key — NOT NULL
- UplinkedDate — datetime — Primary key — NOT NULL
- UplinkStatus — bit — Primary key — NOT NULL
- PacketID — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_ALARM
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Number — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- ALL_Mode — char(1)
- TSH_Mode — char(1)
- WSH_Mode — char(1)
- TOC_Mode — char(1)
- WOC_Mode — char(1)
- DV_Mode — char(1)
- NOM_Mode — char(1)
- FDV_Mode — char(1)
- SP_Mode — char(1)
- TP_Mode — char(1)
- Condition_TLM — varchar(50)
- Condition_Value1 — varchar(20)
- Condition_Value2 — varchar(20)
- Condition_Value3 — varchar(20)
- Lower_Limit_Red — float
- Lower_Limit_yellow — float
- Upper_Limit_yellow — float
- Upper_Limit_Red — float
- Filter_On — bit — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CAANALOG
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- ArgName — varchar(60) — Primary key — NOT NULL
- ArgType — varchar(8) — NOT NULL
- Unit — varchar(50)
- Type — varchar(10) — NOT NULL
- Calcurve — varchar(50)
- LRange — varchar(50)
- HRange — varchar(50)
- LSB — float
- BASE — smallint
- ORD — smallint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CADISCRETE
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- ArgName — varchar(60) — Primary key — NOT NULL
- SubArgName — varchar(60) — Primary key — NOT NULL
- StartBit — smallint — Primary key — NOT NULL
- ArgType — varchar(8) — NOT NULL
- LRange — bigint
- HRange — bigint
- ArgLen — smallint — NOT NULL
- TotalByteLen — smallint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CAFRAME
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- ArgName — varchar(60) — Primary key — NOT NULL
- ArgType — varchar(8) — NOT NULL
- ResvValue — varchar(1000)
- Description — varchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CALCURVE_LIST
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- CalcurveID — int — Primary key — NOT NULL
- CalcurveNumber — int — Primary key — NOT NULL
- CalcurveType — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CALCURVE_NORMAL
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- CalcurveID — int — Primary key — NOT NULL
- CalcurveNumber — int — Primary key — NOT NULL
- MinValue — float
- MaxValue — float
- Slope — float
- Intercept — float
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CALCURVE_POLYNOMIAL
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- CalcurveID — int — Primary key — NOT NULL
- CalcurveNumber — int — Primary key — NOT NULL
- MinValue — float
- MaxValue — float
- COEF_A — float — NOT NULL
- COEF_B — float — NOT NULL
- COEF_C — float — NOT NULL
- COEF_D — float — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CALCURVE_TYPE
- CalcurveTypeName — nvarchar(20) — Primary key — NOT NULL
- CalcurveType — tinyint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CAMAPPING
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- ArgName — varchar(60) — Primary key — NOT NULL
- ArgIndex — smallint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CASTATUS
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- ArgName — varchar(200) — Primary key — NOT NULL
- Status — varchar(200) — Primary key — NOT NULL
- StatusCode — varchar(16) — NOT NULL
- ArgLen — tinyint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_COMMAND
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- CMDID — varchar(50)
- Subsystem — nvarchar(50)
- ToUnit — nvarchar(50)
- CMDTYPE — nvarchar(50)
- Description — nvarchar(500)
- Criticality — nvarchar(10)
- SVCID — varchar(10)
- Cmd_Number — varchar(2)
- SubAddress — varchar(2)
- CmdHex — nvarchar(3000)
- Number_Of_Args — smallint
- Type_Of_Args — nvarchar(1500)
- TotalArgLen — int
- DeleveryDate — datetime
- RevDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CURRENT_VERSION
- CurrentID — uniqueidentifier — Primary key — NOT NULL
- User — nvarchar(50)
- Description — nvarchar(300)
- ReleaseDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_EVENTERROR
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- EventID — varchar(50) — Primary key — NOT NULL
- Service — varchar(50)
- Component — varchar(50)
- Level — int — NOT NULL
- Description — varchar(3000)
- Remark — varchar(3000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_HL_COMMAND
- Target — nvarchar(15) — Primary key — NOT NULL
- No — int — Primary key — NOT NULL
- Major (Major2) — Foreign key → TB_VERSION_INFO.Major — NOT NULL
- Minor (Minor2) — Foreign key → TB_VERSION_INFO.Minor — NOT NULL
- Unit — nvarchar(50)
- Table — nvarchar(15)
- Offset — int
- Mnemonic — nvarchar(50)
- TlmMnemonic — nvarchar(100)
- Description — nvarchar(max)
- NumberOfArgs — int
- ArgType — nvarchar(50)
- ArgUnit — nvarchar(50)
- ArgRange — nvarchar(max)
- ArgDefault — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_HL_TELEMETRY
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Target — nvarchar(15) — Primary key — NOT NULL
- No — int — Primary key — NOT NULL
- Unit — nvarchar(50)
- Table — nvarchar(15)
- Offset — int
- Mnemonic — nvarchar(50)
- Description — nvarchar(max)
- ArgType — nvarchar(15)
- ArgUnit — nvarchar(50)
- ArgRange — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_KPD_CVARIABLES
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- KPD_CVariable — nvarchar(250) — Primary key — NOT NULL
- Address — nvarchar(50) — NOT NULL
- Type — nvarchar(50) — NOT NULL
- Description — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_PACKETDATA
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Packet_ID — varchar(10) — Primary key — NOT NULL
- BytePosition — int — Primary key — NOT NULL
- MomMnemonic — varchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_PACKETLIST
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Packet_ID — varchar(10) — Primary key — NOT NULL
- PacketTitle — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_PAYLOADASYNC_PACKETDATA
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Payload_Unit — varchar(256) — Primary key — NOT NULL
- DownlinkMnemonic — varchar(50) — Primary key — NOT NULL
- TLM_ID — varchar(10) — Primary key — NOT NULL
- BytePosition — int — Primary key — NOT NULL
- MomMnemonic — varchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_PAYLOADASYNC_PACKETLIST
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Payload_Unit — varchar(256) — Primary key — NOT NULL
- TLM_ID — varchar(10) — Primary key — NOT NULL
- DownlinkMnemonic — varchar(50) — Primary key — NOT NULL
- TLM_Name — varchar(256) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_SCTLMCALCURVEINFO
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- SwitchValue — varchar(20) — Primary key — NOT NULL
- Calcurve_For_Tlm — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_SCTLMDISCRETEINFO
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- DiscreteValue — int — Primary key — NOT NULL
- DiscreteStatus — varchar(50) — NOT NULL
- Description — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_SCTLMMNEMONIC
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- Mnemonic_ID — varchar(10)
- SubSystem — nvarchar(50) — NOT NULL
- Unit — nvarchar(50)
- SVC — nvarchar(50)
- Description — nvarchar(max)
- Ana_Dis — nvarchar(10) — NOT NULL
- Analog_Type — nvarchar(10)
- MomMnemonic — varchar(50) — NOT NULL
- StartBit — int — NOT NULL
- BitCount — int — NOT NULL
- ByteSize — int — NOT NULL
- Calcurve_Primary — int
- SwitchMnemonic — nvarchar(100)
- ScaleUnit — varchar(20)
- C_Variable_Name — varchar(100)
- AlarmCheck — varchar(50)
- DeleveryDate — datetime
- RevDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_SCTLMMNEMONICMOM
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- Mnemonic — varchar(50) — Primary key — NOT NULL
- Mnemonic_ID — varchar(10) — NOT NULL
- ByteSize — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_VERSION_EGSE
- Unit — varchar(50) — Primary key — NOT NULL
- Major — int — Primary key — NOT NULL
- Minor — int — Primary key — NOT NULL
- User — varchar(50)
- Description — nvarchar(max)
- ReleaseDate — datetime
- Valid — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_VERSION_INFO
- ID — uniqueidentifier — Primary key — NOT NULL
- Item — varchar(50) — Primary key — NOT NULL
- Major — Primary key — NOT NULL
- Minor — Primary key — NOT NULL
- ReleaseDate — datetime
- User — varchar(50)
- Description — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_VERSION_LIST
- ID — uniqueidentifier — Primary key — NOT NULL
- ReleaseDate — datetime
- User — nvarchar(50)
- Description — nvarchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =