[dbo].[usm_subscription

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

Property

Value

Row Count

5244

Created

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

Last Modified

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

	Name	Data Type	Collation	Max Length (Bytes)	Default
	id	int		4
$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$ $Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$	account_no	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	account_label	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS	256
	parent_domain	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$	offering_id	int		4
$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$	rate_plan_id	int		4
$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$	item_id	int		4
$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$ $Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$	status	int		4
$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$	subscription_type	int		4
	instance_name	varchar(64)	SQL_Latin1_General_CP1_CS_AS	64
	subscribed_date	datetime		8
	unsubscribed_date	datetime		8
	charge_date	datetime		8
	last_charge_date	datetime		8
	code	nvarchar(64)	SQL_Latin1_General_CP1_CI_AS	128
$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$	charge	int		4
	installments	int		4
	tiered_item_id	int		4
	tiered_last_date	datetime		8
	text_1	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	text_2	nvarchar(50)	SQL_Latin1_General_CP1_CS_AS	100
	text_3	nvarchar(256)	SQL_Latin1_General_CP1_CS_AS	512
	text_4	nvarchar(256)	SQL_Latin1_General_CP1_CS_AS	512
	text_5	nvarchar(100)	SQL_Latin1_General_CP1_CS_AS	200
	text_6	nvarchar(50)	SQL_Latin1_General_CP1_CS_AS	100
	text_7	nvarchar(50)	SQL_Latin1_General_CP1_CS_AS	100
$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$	enum_1	int		4
	enum_2	int		4
	enum_3	int		4
	enum_4	int		4
	enum_5	int		4
	numeric_1	float		8
	numeric_2	float		8
	request_id	int		4
	request_type	int		4
	domain	varchar(50)	SQL_Latin1_General_CP1_CS_AS	50
	group_id	int		4	((1))
	sd_row	int		4

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

Default

Cluster Primary Key XPKusm_subscription_detail: id

int

Foreign Keys $usm_s_r00002c1b00000000: [dbo].[usm_billing_account].account_no

$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$ $Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$

account_no

varchar(50)

SQL_Latin1_General_CP1_CS_AS

account_label

nvarchar(128)

SQL_Latin1_General_CP1_CI_AS

256

parent_domain

varchar(50)

SQL_Latin1_General_CP1_CS_AS

Foreign Keys $usm_s_r00002c3900000000: [dbo].[usm_offering].offering_id

$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$

offering_id

int

Foreign Keys $usm_s_r00002c2f00000000: [dbo].[usm_rate_plan].rate_plan_id

$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$

rate_plan_id

int

Foreign Keys $usm_s_r00002c2500000000: [dbo].[usm_rate_definition].item_id

$Indexes usm_subscription_detail_idx_02: status\offering_id\rate_plan_id\item_id\account_no$ $Indexes usm_subscription_detail_idx_03: status\rate_plan_id\item_id\account_no$

item_id

int

status

int

$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$

subscription_type

int

instance_name

varchar(64)

SQL_Latin1_General_CP1_CS_AS

subscribed_date

datetime

unsubscribed_date

datetime

charge_date

datetime

last_charge_date

datetime

code

nvarchar(64)

SQL_Latin1_General_CP1_CI_AS

128

$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$

charge

int

installments

int

tiered_item_id

int

tiered_last_date

datetime

text_1

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

text_2

nvarchar(50)

SQL_Latin1_General_CP1_CS_AS

100

text_3

nvarchar(256)

SQL_Latin1_General_CP1_CS_AS

512

text_4

nvarchar(256)

SQL_Latin1_General_CP1_CS_AS

512

text_5

nvarchar(100)

SQL_Latin1_General_CP1_CS_AS

200

text_6

nvarchar(50)

SQL_Latin1_General_CP1_CS_AS

100

text_7

nvarchar(50)

SQL_Latin1_General_CP1_CS_AS

100

$Indexes usm_subscription_detail_idx_01: account_no\status\charge\subscription_type\enum_1$

enum_1

int

enum_2

int

enum_3

int

enum_4

int

enum_5

int

numeric_1

float

numeric_2

float

request_id

int

request_type

int

domain

varchar(50)

SQL_Latin1_General_CP1_CS_AS

group_id

int

((1))

sd_row

int

	Name	Columns	Unique
	XPKusm_subscription_detail	id
	usm_subscription_detail_idx_01	account_no, status, charge, subscription_type, enum_1
	usm_subscription_detail_idx_02	status, offering_id, rate_plan_id, item_id, account_no
	usm_subscription_detail_idx_03	status, rate_plan_id, item_id, account_no

Name

Columns

Unique

XPKusm_subscription_detail

usm_subscription_detail_idx_01

account_no, status, charge, subscription_type, enum_1

usm_subscription_detail_idx_02

status, offering_id, rate_plan_id, item_id, account_no

usm_subscription_detail_idx_03

status, rate_plan_id, item_id, account_no

Name	Columns
$usm_s_r00002c1b00000000	account_no->[dbo].[usm_billing_account].[account_no]
$usm_s_r00002c2500000000	item_id->[dbo].[usm_rate_definition].[item_id]
$usm_s_r00002c2f00000000	rate_plan_id->[dbo].[usm_rate_plan].[rate_plan_id]
$usm_s_r00002c3900000000	offering_id->[dbo].[usm_offering].[offering_id]
$usm_s_r00002e4b00000000	account_no->[dbo].[usm_billing_account].[account_no]
$usm_s_r00002e5500000000	item_id->[dbo].[usm_rate_definition].[item_id]
$usm_s_r00002e5f00000000	rate_plan_id->[dbo].[usm_rate_plan].[rate_plan_id]
$usm_s_r00002e6900000000	offering_id->[dbo].[usm_offering].[offering_id]
XFKusm_subscription_detail1	domain->[dbo].[usm_tenant_ext].[tenant_id]

Name

Columns

$usm_s_r00002c1b00000000

account_no->[dbo].[usm_billing_account].[account_no]

$usm_s_r00002c2500000000

item_id->[dbo].[usm_rate_definition].[item_id]

$usm_s_r00002c2f00000000

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

$usm_s_r00002c3900000000

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

$usm_s_r00002e4b00000000

account_no->[dbo].[usm_billing_account].[account_no]

$usm_s_r00002e5500000000

item_id->[dbo].[usm_rate_definition].[item_id]

$usm_s_r00002e5f00000000

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

$usm_s_r00002e6900000000

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

XFKusm_subscription_detail1

domain->[dbo].[usm_tenant_ext].[tenant_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_subscription_detail]
(
[id] [int] NOT NULL,
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[account_label] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[parent_domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[offering_id] [int] NOT NULL,
[rate_plan_id] [int] NOT NULL,
[item_id] [int] NOT NULL,
[status] [int] NOT NULL,
[subscription_type] [int] NOT NULL,
[instance_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subscribed_date] [datetime] NOT NULL,
[unsubscribed_date] [datetime] NULL,
[charge_date] [datetime] NOT NULL,
[last_charge_date] [datetime] NULL,
[code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[charge] [int] NULL,
[installments] [int] NULL,
[tiered_item_id] [int] NULL,
[tiered_last_date] [datetime] NULL,
[text_1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_3] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_4] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_5] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_6] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_7] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enum_1] [int] NULL,
[enum_2] [int] NULL,
[enum_3] [int] NULL,
[enum_4] [int] NULL,
[enum_5] [int] NULL,
[numeric_1] [float] NULL,
[numeric_2] [float] NULL,
[request_id] [int] NULL,
[request_type] [int] NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[group_id] [int] NOT NULL CONSTRAINT [DF__usm_subsc__group__1B49CA47] DEFAULT ((1)),
[sd_row] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [XPKusm_subscription_detail] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_subscription_detail_idx_01] ON [dbo].[usm_subscription_detail] ([account_no], [status], [charge], [subscription_type], [enum_1]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_subscription_detail_idx_02] ON [dbo].[usm_subscription_detail] ([status], [offering_id], [rate_plan_id], [item_id], [account_no]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_subscription_detail_idx_03] ON [dbo].[usm_subscription_detail] ([status], [rate_plan_id], [item_id], [account_no]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002c1b00000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002c2500000000] FOREIGN KEY ([item_id]) REFERENCES [dbo].[usm_rate_definition] ([item_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002c2f00000000] FOREIGN KEY ([rate_plan_id]) REFERENCES [dbo].[usm_rate_plan] ([rate_plan_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002c3900000000] FOREIGN KEY ([offering_id]) REFERENCES [dbo].[usm_offering] ([offering_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002e4b00000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002e5500000000] FOREIGN KEY ([item_id]) REFERENCES [dbo].[usm_rate_definition] ([item_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002e5f00000000] FOREIGN KEY ([rate_plan_id]) REFERENCES [dbo].[usm_rate_plan] ([rate_plan_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [$usm_s_r00002e6900000000] FOREIGN KEY ([offering_id]) REFERENCES [dbo].[usm_offering] ([offering_id])
GO
ALTER TABLE [dbo].[usm_subscription_detail] ADD CONSTRAINT [XFKusm_subscription_detail1] FOREIGN KEY ([domain]) REFERENCES [dbo].[usm_tenant_ext] ([tenant_id])
GO
GRANT SELECT ON  [dbo].[usm_subscription_detail] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_subscription_detail] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_subscription_detail] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_subscription_detail] TO [usmgroup]
GO