Tables [dbo].[CustomFields]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:05 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_CustomFields_ID: IDIDint4
False
1 - 1
DeviceField1Enabledbit1
False
((0))
DeviceField1Namenvarchar(50)100
True
DeviceField2Enabledbit1
False
((0))
DeviceField2Namenvarchar(50)100
True
DeviceField3Enabledbit1
False
((0))
DeviceField3Namenvarchar(50)100
True
DeviceField4Enabledbit1
False
((0))
DeviceField4Namenvarchar(50)100
True
DeviceField5Enabledbit1
False
((0))
DeviceField5Namenvarchar(50)100
True
DeviceField6Enabledbit1
False
((0))
DeviceField6Namenvarchar(50)100
True
DeviceField7Enabledbit1
False
((0))
DeviceField7Namenvarchar(50)100
True
DeviceField8Enabledbit1
False
((0))
DeviceField8Namenvarchar(50)100
True
AccountField1Enabledbit1
False
((0))
AccountField1Namenvarchar(50)100
True
AccountField2Enabledbit1
False
((0))
AccountField2Namenvarchar(50)100
True
AccountField3Enabledbit1
False
((0))
AccountField3Namenvarchar(50)100
True
AccountField4Enabledbit1
False
((0))
AccountField4Namenvarchar(50)100
True
AccountField5Enabledbit1
False
((0))
AccountField5Namenvarchar(50)100
True
AccountField6Enabledbit1
False
((0))
AccountField6Namenvarchar(50)100
True
AccountField7Enabledbit1
False
((0))
AccountField7Namenvarchar(50)100
True
AccountField8Enabledbit1
False
((0))
AccountField8Namenvarchar(50)100
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_CustomFields_ID: IDPK_CustomFields_IDID
True
CREATE TABLE [dbo].[CustomFields]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DeviceField1Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField1Enabled] DEFAULT ((0)),
[DeviceField1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField2Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField2Enabled] DEFAULT ((0)),
[DeviceField2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField3Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField3Enabled] DEFAULT ((0)),
[DeviceField3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField4Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField4Enabled] DEFAULT ((0)),
[DeviceField4Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField5Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField5Enabled] DEFAULT ((0)),
[DeviceField5Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField6Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField6Enabled] DEFAULT ((0)),
[DeviceField6Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField7Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField7Enabled] DEFAULT ((0)),
[DeviceField7Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceField8Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_DeviceField8Enabled] DEFAULT ((0)),
[DeviceField8Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField1Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField1Enabled] DEFAULT ((0)),
[AccountField1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField2Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField2Enabled] DEFAULT ((0)),
[AccountField2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField3Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField3Enabled] DEFAULT ((0)),
[AccountField3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField4Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField4Enabled] DEFAULT ((0)),
[AccountField4Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField5Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField5Enabled] DEFAULT ((0)),
[AccountField5Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField6Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField6Enabled] DEFAULT ((0)),
[AccountField6Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField7Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField7Enabled] DEFAULT ((0)),
[AccountField7Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountField8Enabled] [bit] NOT NULL CONSTRAINT [DF_CustomFields_AccountField8Enabled] DEFAULT ((0)),
[AccountField8Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CustomFields] ADD CONSTRAINT [PK_CustomFields_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO