[dbo].[usm_offering_rplan

Property	Value
Row Count	310
Created	11:08:07 AM Wednesday, March 07, 2007
Last Modified	1:17:01 PM Tuesday, March 30, 2010

Property

Value

Row Count

310

Created

11:08:07 AM Wednesday, March 07, 2007

Last Modified

1:17:01 PM Tuesday, March 30, 2010

	Name	Data Type	Max Length (Bytes)
	id	int	4
	base_id	int	4
$Indexes usm_offer_rplan_incl_idx_01: parent_id\child_id$	parent_id	int	4
$Indexes usm_offer_rplan_incl_idx_01: parent_id\child_id$	child_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Cluster Primary Key XPKusm_offering_rplan_inclusion: id

int

base_id

int

$Indexes usm_offer_rplan_incl_idx_01: parent_id\child_id$

parent_id

int

$Indexes usm_offer_rplan_incl_idx_01: parent_id\child_id$

child_id

int

	Name	Columns	Unique
	XPKusm_offering_rplan_inclusion	id
	usm_offer_rplan_incl_idx_01	parent_id, child_id

Name

Columns

Unique

XPKusm_offering_rplan_inclusion

usm_offer_rplan_incl_idx_01

parent_id, child_id

Name	Columns
$usm_o_r00002d0100000000	child_id->[dbo].[usm_rate_plan].[rate_plan_id]
$usm_o_r00002d0b00000000	parent_id->[dbo].[usm_offering].[offering_id]

Name

Columns

$usm_o_r00002d0100000000

child_id->[dbo].[usm_rate_plan].[rate_plan_id]

$usm_o_r00002d0b00000000

parent_id->[dbo].[usm_offering].[offering_id]

Type	Action	Owning Principal
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Select	usmgroup
Grant	Update	usmgroup

Type

Action

Owning Principal

Grant

Delete

usmgroup

Grant

Insert

usmgroup

Grant

Select

usmgroup

Grant

Update

usmgroup

SQL Script

CREATE TABLE [dbo].[usm_offering_rplan_inclusion]
(
[id] [int] NOT NULL,
[base_id] [int] NOT NULL,
[parent_id] [int] NULL,
[child_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_offering_rplan_inclusion] ADD CONSTRAINT [XPKusm_offering_rplan_inclusion] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_offer_rplan_incl_idx_01] ON [dbo].[usm_offering_rplan_inclusion] ([parent_id], [child_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_offering_rplan_inclusion] ADD CONSTRAINT [$usm_o_r00002d0100000000] FOREIGN KEY ([child_id]) REFERENCES [dbo].[usm_rate_plan] ([rate_plan_id])
GO
ALTER TABLE [dbo].[usm_offering_rplan_inclusion] ADD CONSTRAINT [$usm_o_r00002d0b00000000] FOREIGN KEY ([parent_id]) REFERENCES [dbo].[usm_offering] ([offering_id])
GO
GRANT SELECT ON  [dbo].[usm_offering_rplan_inclusion] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_offering_rplan_inclusion] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_offering_rplan_inclusion] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_offering_rplan_inclusion] TO [usmgroup]
GO