Tables [dbo].[CreditWarningSetting]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)5
Created3:52:55 PM Thursday, December 6, 2018
Last Modified3:53:09 PM Thursday, December 6, 2018
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_CreditWarningSetting: CreditWarningSettingIDCreditWarningSettingIDint4
No
1 - 1
Descriptionvarchar(64)64
No
ShowDialogbit1
No
((0))
AllowSelectionbit1
No
((0))
EmailCollectorbit1
No
((0))
EmailCustombit1
No
((0))
CustomEmailAddressesvarchar(256)256
Yes
AddNotebit1
No
((0))
Valuedecimal(10,2)9
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_CreditWarningSetting: CreditWarningSettingIDPK_CreditWarningSettingCreditWarningSettingID
Yes
Check Constraints Check Constraints
NameConstraint
CK_CreditWarningSetting_Valid_Setting(NOT ([ShowDialog]=(0) AND [AllowSelection]=(0)))
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[CreditWarningSetting]
(
[CreditWarningSettingID] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShowDialog] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_ShowDialog] DEFAULT ((0)),
[AllowSelection] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_AllowSelection] DEFAULT ((0)),
[EmailCollector] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_EmailCollector] DEFAULT ((0)),
[EmailCustom] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_EmailCustom] DEFAULT ((0)),
[CustomEmailAddresses] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AddNote] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_AddNote] DEFAULT ((0)),
[Value] [decimal] (10, 2) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CreditWarningSetting] ADD CONSTRAINT [CK_CreditWarningSetting_Valid_Setting] CHECK ((NOT ([ShowDialog]=(0) AND [AllowSelection]=(0))))
GO
ALTER TABLE [dbo].[CreditWarningSetting] ADD CONSTRAINT [PK_CreditWarningSetting] PRIMARY KEY NONCLUSTERED  ([CreditWarningSettingID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT INSERT ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT DELETE ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT UPDATE ON  [dbo].[CreditWarningSetting] TO [MssExec]
GO
Uses