Tables [dbo].[PlasticProviderType]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)3
Created4:09:41 PM Thursday, December 6, 2018
Last Modified7:35:07 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PlasticProviderType: ProviderTypeIDProviderTypeIDint4
No
1 - 1
Indexes IX_PlasticProviderType_TypeCode: TypeCodeTypeCodevarchar(4)4
No
Indexes IX_PlasticProviderType_TypeName: TypeNameTypeNamevarchar(50)50
No
Brandvarchar(10)10
Yes
ProdHppBaseUrlvarchar(255)255
Yes
TestHppBaseUrlvarchar(255)255
Yes
GatewaySubDirvarchar(50)50
Yes
UsesSeparateNameFieldsbit1
No
((0))
SupportsAuthCapturebit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PlasticProviderType: ProviderTypeIDPK_PlasticProviderTypeProviderTypeID
Yes
IX_PlasticProviderType_TypeCodeTypeCode
Yes
IX_PlasticProviderType_TypeNameTypeName
Yes
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PlasticProviderType]
(
[ProviderTypeID] [int] NOT NULL IDENTITY(1, 1),
[TypeCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TypeName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Brand] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProdHppBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TestHppBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GatewaySubDir] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UsesSeparateNameFields] [bit] NOT NULL CONSTRAINT [DF_PlasticProviderType_UsesSeparateNameFields] DEFAULT ((0)),
[SupportsAuthCapture] [bit] NOT NULL CONSTRAINT [DF_PlasticProviderType_SupportsAuthCapture] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [PK_PlasticProviderType] PRIMARY KEY CLUSTERED  ([ProviderTypeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [IX_PlasticProviderType_TypeCode] UNIQUE NONCLUSTERED  ([TypeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [IX_PlasticProviderType_TypeName] UNIQUE NONCLUSTERED  ([TypeName]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticProviderType] TO [MssExec]
GO
Uses
Used By