Tables [dbo].[SHBulkUpdateLinks]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:42 AM Thursday, March 21, 2019
Last Modified1:15:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
LinkIDint4
False
1 - 1
Foreign Keys FK_SHBulkUpdateLinks_ListDialogType_ListDialogTypes: [dbo].[ListDialogTypes].ListDialogTypeListDialogTypevarchar(32)32
False
UpdateDescriptionvarchar(32)32
False
UpdateTableNamevarchar(32)32
False
UpdateTableIDFieldvarchar(32)32
False
Foreign Keys FK_SHBulkUpdateLinks_LookUpCtrlType_LookUpCtrlTypes: [dbo].[LookUpCtrlTypes].LookUpCtrlTypeLookUpCtrlTypevarchar(25)25
True
SetDescriptionvarchar(64)64
False
SetFieldNamevarchar(32)32
False
AdditionalUpdatevarchar(1024)1024
False
('')
AdditionalUpdateWherevarchar(1024)1024
False
('')
AdditionalUpdateIDFieldvarchar(32)32
False
('')
Foreign Keys FK_SHBulkUpdateLinks_DataTypeID_LdDataTypes: [dbo].[LdDataTypes].DataTypeIDDataTypeIDint4
False
Lengthint4
False
((0))
CalcFormatvarchar(8)8
True
CalcDecPlacesint4
False
((0))
ShowCalcbit1
False
((0))
LastUpdateFieldNamevarchar(32)32
True
UpdatorIDFieldNamevarchar(32)32
True
UpdateWherevarchar(1024)1024
True
IsHiddenbit1
False
((0))
NameColumns
FK_SHBulkUpdateLinks_DataTypeID_LdDataTypesDataTypeID->[dbo].[LdDataTypes].[DataTypeID]
FK_SHBulkUpdateLinks_ListDialogType_ListDialogTypesListDialogType->[dbo].[ListDialogTypes].[DialogType]
FK_SHBulkUpdateLinks_LookUpCtrlType_LookUpCtrlTypesLookUpCtrlType->[dbo].[LookUpCtrlTypes].[Type]
CREATE TABLE [dbo].[SHBulkUpdateLinks]
(
[LinkID] [int] NOT NULL IDENTITY(1, 1),
[ListDialogType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateDescription] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateTableName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateTableIDField] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LookUpCtrlType] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SetDescription] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SetFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AdditionalUpdate] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdate] DEFAULT (''),
[AdditionalUpdateWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdateWhere] DEFAULT (''),
[AdditionalUpdateIDField] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdateIDField] DEFAULT (''),
[DataTypeID] [int] NOT NULL,
[Length] [int] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_Length] DEFAULT ((0)),
[CalcFormat] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalcDecPlaces] [int] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_CalcDecPlaces] DEFAULT ((0)),
[ShowCalc] [bit] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_ShowCalc] DEFAULT ((0)),
[LastUpdateFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatorIDFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdateWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsHidden] [bit] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_IsHidden] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_DataTypeID_LdDataTypes] FOREIGN KEY ([DataTypeID]) REFERENCES [dbo].[LdDataTypes] ([DataTypeID])
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_ListDialogType_ListDialogTypes] FOREIGN KEY ([ListDialogType]) REFERENCES [dbo].[ListDialogTypes] ([DialogType])
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_LookUpCtrlType_LookUpCtrlTypes] FOREIGN KEY ([LookUpCtrlType]) REFERENCES [dbo].[LookUpCtrlTypes] ([Type])
GO