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 — =