namespace DTS.Common.Storage { public partial class DbOperations { public abstract class DigitalInputSettings { public const string Table = "tblDigitalInputSetting"; public enum Fields { SettingName, SettingMode, ScaleMultiplier, LastModified, LastModifiedBy, SensorId, UserValue1, UserValue2, UserValue3, UserTags, eId, MeasurementUnit, FilterClass, ISOCode, ISOChannelName, UserCode, UserChannelName, Broken, //new in 2.0 DoNotUse //new in 2.0 } } public abstract class VersionTable { public enum Fields { Version, Step, Date, Remarks, UserField } public const string TableName = "tblDataPRODbVersion"; } public abstract class DAS { public const string Table = "tblDAS"; public enum Fields { SerialNumber, Type, MaxModules, MaxMemory, MaxSampleRate, MinSampleRate, FirmwareVersion, CalDate, ProtocolVersion, LastModified, LastModifiedBy, Version, LocalOnly, LastUsed, LastUsedBy, Connection, Channels, Position, ChannelTypes, Reprogramable, Reconfigurable, IsModule, PositionOnDistributor, PositionOnChain, Port, ParentDAS, DASId, FirstUseDate, StandIn, MaxAAFRate, TestId, GroupId } public const string TableDASChannels = "tblDASChannels"; public enum DASChannelFields { HardwareId, ChannelIdx, SupportedBridges, SupportedExcitations, DASDisplayOrder, LocalOnly, SupportedDigitalInputModes, SupportedSquibFireModes, SupportedDigitalOutputModes, ModuleSerialNumber, ModuleArrayIndex } public const string SLICE1_PROTOTYPE = "SLICE1 Prototype"; public const string SLICEPRO_PROTOTYPE = "SLICEPRO Prototype"; public const string PROTOTYPE_POSITION = "Prototype"; public const string SLICE1_5PROTOTYPE = "SLICE+ Prototype"; public const string G5_VDSPROTOTYPE = "G5 VDS Prototype"; public const string G5_IPORTPROTOTYPE = "G5 iPort Prototype"; public const string TDASPRO_8MRack = "TDASPro Rack 8M Prototype"; public const string TDASPRO_4MRack = "TDASPRO Rack 4M Prototype"; public const string ECM_PROTOTYPE = "SLICE ECM Prototype"; public const string SPM_PROTOTYPE = "SLICE Mini Distributor Prototype"; public const string SLE_PROTOTYPE = "SLICE PRO Lab Ethernet Prototype"; public const string SDB_PROTOTYPE = "SLICE Distributor Prototype"; public const string Slice_NanoPROTOTYPE = "SLICE Nano Prototype"; public const string Slice_MicroPROTOTYPE = "SLICE Micro Prototype"; public const string SLICEPRODIM_PROTOTYPE = "SLICE Pro DIM"; public const string SLICEPROSLD_PROTOTYPE = "SLICE PRO Lab DIM"; public const string SLICEPROTOM_PROTOTYPE = "SLICE Pro TOM"; public const string SLICEPROSLT_PROTOTYPE = "SLICE PRO Lab TOM"; public const string SLICEPROSIM_PROTOTYPE = "SLICE Pro SIM"; public const string SLICEPROSLS_PROTOTYPE = "SLICE PRO Lab SIM"; public const string SLICE1_5_MicroPROTOTYPE = "SLICE MICRO BASE+ Prototype"; public const string G5_INDUMMYPROTOTYPE = "G5 InDummy Prototype"; public const string SG5_PROTOTYPE = "SLICE G5 Prototype"; public const string TDASPRO_LabRack = "TDAS PRO Lab Rack"; public const string SLICE6_PROTOTYPE = "SLICE6 Prototype"; public const string SLICE6_AIR_PROTOTYPE = "SLICE6 AIR Prototype"; public const string SLICE6_AIR_ER_PROTOTYPE = "SLICE6 AIR ER Prototype"; public const string SLICE6_AIR_BR_PROTOTYPE = "SLICE6 Falcon Prototype"; public const string SLICE6DB_PROTOTYPE = "SLICE6Db Prototype"; public const string SLICE6DB3_PROTOTYPE = "SLICE6Db3 Prototype"; public const string SLICE6DB_AIR_PROTOTYPE = "SLICE6Db AIR Prototype"; public const string SLICE6DB_INDUMMY_PROTOTYPE = "SLICE6Db InDummy Prototype"; public const string POWERPRO_PROTOTYPE = "PowerPRO Prototype"; public const string TSR_AIR_PROTOTYPE = "TSR Air Prototype"; public const string TSR_AIR_REVB_PROTOTYPE = "TSR Air RevB Prototype"; public const string DIR_PROTOTYPE = "DIR Prototype"; public const string DKR_PROTOTYPE = "DKR Prototype"; public const string EMB_LIN_ACC_LO_MODULE_PROTOTYPE = "EMB LIN ACC LO Module Prototype"; public const string EMB_LIN_ACC_HI_MODULE_PROTOTYPE = "EMB LIN ACC HI Module Prototype"; public const string EMB_ARS_MODULE_PROTOTYPE = "EMB ARS Module Prototype"; public const string EMB_ATM_MODULE_PROTOTYPE = "EMB ATM Module Prototype"; public const string SLICEPRO_DB_PROTOTYPE = "SLICE Pro Distributor Prototype"; public const string SLICE_TC_PROTOTYPE = "SLICE TC Prototype"; public const string SLICE_PRO_CAN_FD_PROTOTYPE = "SLICE PRO CAN FD Prototype"; } public abstract class TestObjectChannelSettings { public const string TableName = "tblTestObjectChannelSettings"; public enum Fields { TestObjectSerial, ChannelId, Setting, SensorSerial, SerialNumber } } public abstract class DigitalOutputSettings { public const string Table = "tblTOMDigitalChannels"; public enum Fields { ChannelDescription, DelayMS, DurationMS, OutputMode, LimitDuration, LastModified, LastModifiedBy, Version, LocalOnly, DurationMSFloat, UserTags, Broken, //new in 2.0 DoNotUse //new in 2.0 } } public abstract class Squib { public const string Table = "tblTOMSquibChannels"; public enum Fields { SerialNumber, SquibDescription, BypassCurrentFilter, BypassVoltageFilter, DelayMS, DurationMS, FireMode, ISOCode, ISOChannelName, UserCode, UserChannelName, MeasurementType, SquibOutputCurrent, SquibToleranceLow, SquibToleranceHigh, LimitDuration, ArticleId, LocalOnly, Version, LastModified, LastModifiedBy, UserValue1, UserValue2, UserValue3, UserTags, Broken, //new in 2.0 DoNotUse, //new in 2.0 DefineDelayInTest // new in 2.3 } } public abstract class UartIOSettings { public const string Table = "tblUartIOSettings"; public enum Fields { SerialNumber, Description, BaudRate, DataBits, StopBits, Parity, FlowControl, DataFormat, LastModified, LastModifiedBy, UserTags, Broken, DoNotUse } } public abstract class StreamOutputSettings { public const string Table = "tblStreamOutputSettings"; public enum Fields { SerialNumber, Description, StreamProfile, UDPAddress, TimeChannelId, DataChannelId, TmNSConfig, IRIGTimeDataPacketIntervalMs, LastModified, LastModifiedBy, UserTags, Broken, DoNotUse } } public abstract class CalculatedChannels { public const string Table = "tblCalculatedChannels"; public enum Fields { [DbTypeAttr("INTEGER PRIMARY KEY NOT NULL")] Id, [DbTypeAttr("INTEGER")] Operation, [DbTypeAttr("NVARCHAR(255)")] CalculatedChannelValueCode, [DbTypeAttr("BLOB")] InputChannelIds, [DbTypeAttr("NVARCHAR(255)")] CFCForInputChannels, [DbTypeAttr("NVARCHAR(255)")] CFCForOutput, [DbTypeAttr("NVARCHAR(255)")] TestSetupName, [DbTypeAttr("NVARCHAR(255)")] CCName, [DbTypeAttr("Bit")] ViewInRealtime, [DbTypeAttr("Int")] ClipLength } } public abstract class LevelTriggers { public const string Table = "tblLevelTriggers"; public enum Fields { [DbTypeAttr("NVARCHAR(255) NOT NULL")] TestSetupName, [DbTypeAttr("BIGINT NOT NULL")] ChannelId, [DbTypeAttr("NVARCHAR(255) NOT NULL")] GroupName, //[DbTypeAttr("NVARCHAR(255) NOT NULL")] //TestObjectChannelId, [DbTypeAttr("NVARCHAR(255) NOT NULL")] HardwareChannelId, [DbTypeAttr("NVARCHAR(255) NOT NULL")] SensorSerialNumber, [DbTypeAttr("BIT NOT NULL")] GreaterThanEnabled, [DbTypeAttr("FLOAT NOT NULL")] GreaterThanEU, [DbTypeAttr("BIT NOT NULL")] LessThanEnabled, [DbTypeAttr("FLOAT NOT NULL")] LessThanEU, [DbTypeAttr("FLOAT NULL")] InsideUpperEU, [DbTypeAttr("FLOAT NULL")] InsideLowerEU, [DbTypeAttr("FLOAT NULL")] OutsideUpperEU, [DbTypeAttr("FLOAT NULL")] OutsideLowerEU, [DbTypeAttr("BIT NULL")] InsideEnabled, //TriggerInside, [DbTypeAttr("BIT NULL")] OutsideEnabled, //TriggerOutside, //[DbTypeAttr("NVARCHAR(255) NOT NULL")] //TestObjectName }; } public abstract class Tags { public const string Table = "tblTags"; public enum TagFields { TagId, TagText, Obsolete } public const string TAGASSIGNMENTS_TABLE = "TagAssignments"; public enum TagAssignmentFields { ObjectID, ObjectType, TagID } } public abstract class DbVersions { public enum DbVersionFields { Version, Step, Date, Remarks, UserField } } public abstract class Settings { public const string Table = "tblSettings"; public enum UserFields { PropertyId, PropertyType, PropertyValue, UserId } } public abstract class MMEPossibleChannels { public const string Table = "tblMMEPossibleChannels"; } public abstract class LabratoryDetails { public const string Table = "tblLabratoryDetails"; public enum LabratoryDetailsFields { Name, LabratoryName, LabratoryContactName, LabratoryContactPhone, LabratoryContactFax, LabratoryContactEmail, LabratoryTestRefNumber, LabratoryProjectRefNumber, LastModified, LastModifiedBy, LocalOnly, Version } } /// /// tables and fields for user objects /// public abstract class Users { public const string USERS_TABLE = "DataPROUsers"; public enum UserFields { ID, UserName, DisplayName, Password, Role, LastModified, LastModifiedBy, LocalOnly } public const string UIITEMS_TABLE = "UIITEMS"; public enum UIItemFields { ID, Name } public const string USERUISETTINGS_TABLE = "UserUIItemSettings"; public enum UserUIItemSettingFields { UserId, UIItemID, Permission, Visible } } } }