Tables [dbo].[RatePlans]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)25
Created4:57:09 PM Thursday, September 7, 2006
Last Modified7:28:22 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefaultDescription
Cluster Primary Key PK_RatePlans: RPPriKeyRPPriKeyint4
No
1 - 1The primary key.
Indexes IX_Unique_Rate_Plan_Name: RatePlanNameRatePlanNamevarchar(12)12
No
The name of the rate plan.
Descriptionvarchar(30)30
No
The description of the rate plan.
IsLocalvarchar(1)1
Yes
Flag indicating if the rate plan is for local. 1 for true, 0 for false.
VanLineCodevarchar(16)16
Yes
The van line code for the rate plan.
IsSelectablebit1
No
((1))Determines if the rate plan can be selected through the application.
Foreign Keys FK_RatePlans_PointToPointType: [dbo].[PointToPointType].PointToPointTypeFIDPointToPointTypeFIDint4
Yes
Foreign Keys FK_RatePlans_RateEffectiveDateBasis: [dbo].[RateEffectiveDateBasis].RateEffectiveDateBasisFIDRateEffectiveDateBasisFIDint4
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_RatePlans: RPPriKeyPK_RatePlansRPPriKey
Yes
80
IX_Unique_Rate_Plan_NameRatePlanName
Yes
80
Foreign Keys Foreign Keys
NameColumns
FK_RatePlans_PointToPointTypePointToPointTypeFID->[dbo].[PointToPointType].[PointToPointTypeID]
FK_RatePlans_RateEffectiveDateBasisRateEffectiveDateBasisFID->[dbo].[RateEffectiveDateBasis].[RateEffectiveDateBasisID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[RatePlans]
(
[RPPriKey] [int] NOT NULL IDENTITY(1, 1),
[RatePlanName] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsLocal] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VanLineCode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsSelectable] [bit] NOT NULL CONSTRAINT [DF_RatePlans_IsSelectable] DEFAULT ((1)),
[PointToPointTypeFID] [int] NULL,
[RateEffectiveDateBasisFID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RatePlans] ADD CONSTRAINT [PK_RatePlans] PRIMARY KEY CLUSTERED  ([RPPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RatePlans] ADD CONSTRAINT [IX_Unique_Rate_Plan_Name] UNIQUE NONCLUSTERED  ([RatePlanName]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RatePlans] ADD CONSTRAINT [FK_RatePlans_PointToPointType] FOREIGN KEY ([PointToPointTypeFID]) REFERENCES [dbo].[PointToPointType] ([PointToPointTypeID])
GO
ALTER TABLE [dbo].[RatePlans] ADD CONSTRAINT [FK_RatePlans_RateEffectiveDateBasis] FOREIGN KEY ([RateEffectiveDateBasisFID]) REFERENCES [dbo].[RateEffectiveDateBasis] ([RateEffectiveDateBasisID])
GO
GRANT SELECT ON  [dbo].[RatePlans] TO [MssExec]
GRANT INSERT ON  [dbo].[RatePlans] TO [MssExec]
GRANT DELETE ON  [dbo].[RatePlans] TO [MssExec]
GRANT UPDATE ON  [dbo].[RatePlans] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'The description of the rate plan.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'Description'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Flag indicating if the rate plan is for local. 1 for true, 0 for false.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'IsLocal'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Determines if the rate plan can be selected through the application.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'IsSelectable'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name of the rate plan.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'RatePlanName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'RPPriKey'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The van line code for the rate plan.', 'SCHEMA', N'dbo', 'TABLE', N'RatePlans', 'COLUMN', N'VanLineCode'
GO
Uses
Used By