Tables [dbo].[RPPresMappings]
PropertyValue
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 NullsIdentity
Cluster Primary Key PK_RPPresMappings: MapIDMapIDint4
False
1 - 1
AccountIDint4
False
DeptIDint4
True
ModelCategoryIDint4
True
MeterTypeIDint4
True
TransactionTypeIDint4
False
Percentagedecimal(8,5)5
True
PresAccountIDint4
True
CategoryIDint4
True
Foreign Keys FK_RPPresMappings_ConfigurationID_RPPresConfiguration: [dbo].[RPPresConfiguration].ConfigurationIDConfigurationIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RPPresMappings: MapIDPK_RPPresMappingsMapID
True
80
NameColumns
FK_RPPresMappings_ConfigurationID_RPPresConfigurationConfigurationID->[dbo].[RPPresConfiguration].[ConfigurationID]
CREATE TABLE [dbo].[RPPresMappings]
(
[MapID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[DeptID] [int] NULL,
[ModelCategoryID] [int] NULL,
[MeterTypeID] [int] NULL,
[TransactionTypeID] [int] NOT NULL,
[Percentage] [decimal] (8, 5) NULL,
[PresAccountID] [int] NULL,
[CategoryID] [int] NULL,
[ConfigurationID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPresMappings] ADD CONSTRAINT [PK_RPPresMappings] PRIMARY KEY CLUSTERED  ([MapID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPresMappings] ADD CONSTRAINT [FK_RPPresMappings_ConfigurationID_RPPresConfiguration] FOREIGN KEY ([ConfigurationID]) REFERENCES [dbo].[RPPresConfiguration] ([ConfigurationID])
GO