CREATE TABLE [dbo].[TanksVar] (
[Id] int NOT NULL,
[CaseId] int NOT NULL,
[Ts] timestamp NOT NULL,
[IsGood] bit NOT NULL DEFAULT ((1)),
[ProductId] int NULL,
[Measured] float NOT NULL DEFAULT ((0)),
[Reconciled] decimal(26, 6) NOT NULL DEFAULT ((0)),
[Tolerance] float NOT NULL DEFAULT ((0)),
[IsSystem] bit NOT NULL DEFAULT ((0)),
[PassportState] nvarchar(50) COLLATE Cyrillic_General_CI_AS NULL,
[HasVirtual] bit NOT NULL DEFAULT ((0)),
[VirtualMass] AS (((((((((isnull([VirtualMass1],(0))+isnull([VirtualMass2],(0)))+isnull([VirtualMass3],(0)))+isnull([VirtualMass4],(0)))+isnull([VirtualMass5],(0)))+isnull([VirtualMass6],(0)))+isnull([VirtualMass7],(0)))+isnull([VirtualMass8],(0)))+isnull([VirtualMass9],(0)))+isnull([VirtualMass10],(0))),
[AI_Info01] float NULL,
[AI_Info02] float NULL,
[AI_Info03] float NULL,
[AI_Info04] float NULL,
[AI_Info05] float NULL,
[AI_Info06] float NULL,
[AI_Info07] float NULL,
[AI_Info08] float NULL,
[AI_Info09] float NULL,
[AI_Info10] float NULL,
[AI_Info11] float NULL,
[AI_Info12] float NULL,
[AI_Info13] int NULL,
[AI_Info14] nvarchar(10) COLLATE Cyrillic_General_CI_AS NULL,
[AI_Info15] float NULL,
[ObjectStatus] nchar(2) COLLATE Cyrillic_General_CI_AS NULL,
[AI_BeforeMeasuredMass] float NULL,
[AI_Info16] float NULL,
[AI_RelativeTolerance] float NULL,
[AI_Info17] float NULL,
[AI_Info18] float NULL,
[AI_Info19] float NULL,
[AI_Info20] nvarchar(50) COLLATE Cyrillic_General_CI_AS NULL,
[AI_Info21] float NULL,
[AI_Info22] float NULL,
[AI_Info23] float NULL,
[AI_Info24] float NULL,
[NachMass] float NOT NULL DEFAULT ((0)),
[AI_MeasuredMass] float NULL,
[VirtualProductId1] int NULL,
[VirtualMass1] float NULL,
[VirtualProductId2] int NULL,
[VirtualMass2] float NULL,
[VirtualProductId3] int NULL,
[VirtualMass3] float NULL,
[VirtualProductId4] int NULL,
[VirtualMass4] float NULL,
[VirtualProductId5] int NULL,
[VirtualMass5] float NULL,
[VirtualProductId6] int NULL,
[VirtualMass6] float NULL,
[VirtualProductId7] int NULL,
[VirtualMass7] float NULL,
[VirtualProductId8] int NULL,
[VirtualMass8] float NULL,
[VirtualProductId9] int NULL,
[VirtualMass9] float NULL,
[VirtualProductId10] int NULL,
[VirtualMass10] float NULL,
[Comment] nvarchar(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeasuredVolume] float NULL,
[IsSystemCategory] nvarchar(250) COLLATE Cyrillic_General_CI_AS NULL,
[NachProductId] int NULL,
[Grouping] nvarchar(250) COLLATE Cyrillic_General_CI_AS NULL,
[TechUpperBound] float NULL,
[TechLowerBound] float NULL,
[MetrUpperBound] float NULL,
[MetrLowerBound] float NULL,
[ExcessiveLosses] bit NULL,
[MinLoss] float NULL,
[MaxLoss] float NULL,
[NodalTest] bit NULL,
[NodalTestMP] bit NULL,
[GLRTest] bit NULL,
[NotPermittedFlows] bit NULL,
[FirstStruct] int NULL,
[SecondStruct] int NULL,
[ThirdStruct] int NULL,
[ExactRounding] bit NULL,
[FlowStatus] int NULL,
[Redressed] decimal(26, 6) NULL,
CONSTRAINT [PK_TanksVar]
PRIMARY KEY CLUSTERED ([Id] DESC, [CaseId] DESC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON,
DATA_COMPRESSION = PAGE )
 ON [PRIMARY],
CONSTRAINT [FK_TanksVar_Objects]
FOREIGN KEY ([Id])
REFERENCES [dbo].[Objects] ( [Id] )
)
ON [PRIMARY];
GO
ALTER TABLE [dbo].[TanksVar] SET (LOCK_ESCALATION = TABLE);
GO

/****** Object: Index [dbo].[TanksVar].[IX_TanksVar_CaseId]   Script Date: 28.10.2019 9:10:57 ******/

CREATE NONCLUSTERED INDEX [IX_TanksVar_CaseId]
ON [dbo].[TanksVar]
([CaseId])
INCLUDE (
 [Id], [Ts], [IsGood], [ProductId], [Measured], [Reconciled], [Tolerance], [IsSystem], [PassportState], [HasVirtual], [VirtualMass], [AI_Info01], [AI_Info02], [AI_Info03], [AI_Info04], [AI_Info05], [AI_Info06], [AI_Info07], [AI_Info08], [AI_Info09], [AI_Info10], [AI_Info11], [AI_Info12], [AI_Info13], [AI_Info14], [AI_Info15], [ObjectStatus], [AI_BeforeMeasuredMass], [AI_Info16], [AI_RelativeTolerance], [AI_Info17], [AI_Info18], [AI_Info19], [AI_Info20], [AI_Info21], [AI_Info22], [AI_Info23], [AI_Info24], [NachMass], [AI_MeasuredMass], [VirtualProductId1], [VirtualMass1], [VirtualProductId2], [VirtualMass2], [VirtualProductId3], [VirtualMass3], [VirtualProductId4], [VirtualMass4], [VirtualProductId5], [VirtualMass5], [VirtualProductId6], [VirtualMass6], [VirtualProductId7], [VirtualMass7], [VirtualProductId8], [VirtualMass8], [VirtualProductId9], [VirtualMass9], [VirtualProductId10], [VirtualMass10], [Comment], [MeasuredVolume], [IsSystemCategory], [NachProductId], [Grouping], [TechUpperBound], [TechLowerBound], [MetrUpperBound], [MetrLowerBound], [ExcessiveLosses], [MinLoss], [MaxLoss] 
)
WITH
(
PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ONLINE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON,
DATA_COMPRESSION = NONE
)
ON [PRIMARY];