Tables [dbo].[EquipmentMeter]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:20 AM Thursday, March 21, 2019
Last Modified12:57:20 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
EquipmentIDint4
True
MeterIDint4
True
MeterDescriptionvarchar(255)255
True
MeterTypeIDint4
True
LastMeterDisplaydecimal(14,4)9
True
LastMeterActualdecimal(14,4)9
True
LastMeterDatedatetime8
True
SanityDisplaydecimal(14,4)9
True
MeterDigitsint4
True
CREATE TABLE [dbo].[EquipmentMeter]
(
[EquipmentID] [int] NULL,
[MeterID] [int] NULL,
[MeterDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterTypeID] [int] NULL,
[LastMeterDisplay] [decimal] (14, 4) NULL,
[LastMeterActual] [decimal] (14, 4) NULL,
[LastMeterDate] [datetime] NULL,
[SanityDisplay] [decimal] (14, 4) NULL,
[MeterDigits] [int] NULL
) ON [PRIMARY]
GO