Tables [dbo].[RPPresConfiguration]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:44 AM Thursday, March 21, 2019
Last Modified1:13:59 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_RPPresConfiguration: ConfigurationIDConfigurationIDint4
False
1 - 1
ConfigNamevarchar(64)64
True
Descriptionvarchar(255)255
True
Foreign Keys FK_RPPresConfiguration_PresTypeID_RPPresTypes: [dbo].[RPPresTypes].PresTypeIDPresTypeIDint4
True
Activebit1
False
SalesRepCountint4
False
((0))
SalesMgrCountint4
False
((0))
SalesSupCountint4
False
((0))
ServiceTechCountint4
False
((0))
ServiceMgrCountint4
False
((0))
ServiceDispCountint4
False
((0))
AdminCountint4
False
((0))
AdminWarehouseCountint4
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RPPresConfiguration: ConfigurationIDPK_RPPresConfigurationConfigurationID
True
80
NameColumns
FK_RPPresConfiguration_PresTypeID_RPPresTypesPresTypeID->[dbo].[RPPresTypes].[PresTypeID]
CREATE TABLE [dbo].[RPPresConfiguration]
(
[ConfigurationID] [int] NOT NULL IDENTITY(1, 1),
[ConfigName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PresTypeID] [int] NULL,
[Active] [bit] NOT NULL,
[SalesRepCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_SalesRepCount] DEFAULT ((0)),
[SalesMgrCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_SalesMgrCount] DEFAULT ((0)),
[SalesSupCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_SalesSupCount] DEFAULT ((0)),
[ServiceTechCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_ServiceTechCount] DEFAULT ((0)),
[ServiceMgrCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_ServiceMgrCount] DEFAULT ((0)),
[ServiceDispCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_ServiceDispCount] DEFAULT ((0)),
[AdminCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_AdminCount] DEFAULT ((0)),
[AdminWarehouseCount] [int] NOT NULL CONSTRAINT [DF_RPPresConfiguration_AdminWarehouseCount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPresConfiguration] ADD CONSTRAINT [PK_RPPresConfiguration] PRIMARY KEY CLUSTERED  ([ConfigurationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPresConfiguration] ADD CONSTRAINT [FK_RPPresConfiguration_PresTypeID_RPPresTypes] FOREIGN KEY ([PresTypeID]) REFERENCES [dbo].[RPPresTypes] ([PresTypeID])
GO