[dbo].[usm_payment

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKusm_payment_method: account_no\id$ $Indexes usm_payment_method_idx_01: account_no\status\type_1$ $Indexes usm_payment_method_idx_02: account_no\type_1$	account_no	varchar(50)	50
$Cluster Primary Key XPKusm_payment_method: account_no\id$	id	int	4
	domain	varchar(50)	50
	parent_domain	varchar(50)	50
$Indexes usm_payment_method_idx_01: account_no\status\type_1$	status	int	4
$Indexes usm_payment_method_idx_01: account_no\status\type_1$ $Indexes usm_payment_method_idx_02: account_no\type_1$	type_1	varchar(50)	50
	type_2	int	4
	p_name	nvarchar(50)	100
	p_title	nvarchar(50)	100
	p_address1	nvarchar(50)	100
	p_address2	nvarchar(50)	100
	p_city	nvarchar(50)	100
	p_state	nvarchar(50)	100
	p_zip	nvarchar(50)	100
	p_country	nvarchar(50)	100
	p_tel	nvarchar(50)	100
	p_fax	nvarchar(50)	100
	p_email	nvarchar(50)	100
	opened_date	datetime	8
	closed_date	datetime	8
	active_date	datetime	8
	inactive_date	datetime	8
	enum_1	int	4
	text_1	nvarchar(50)	100
	text_2	nvarchar(50)	100
	text_3	nvarchar(50)	100
	numeric_1	float	8
	numeric_2	float	8
	date_1	datetime	8

	Name	Columns
$Cluster Primary Key XPKusm_payment_method: account_no\id$	XPKusm_payment_method	account_no, id
	usm_payment_method_idx_01	account_no, status, type_1
	usm_payment_method_idx_02	account_no, type_1

Name	Columns
$usm_p_r000027d900000000	account_no->[dbo].[usm_billing_account].[account_no]

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

SQL Script

CREATE TABLE [dbo].[usm_payment_method]
(
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[id] [int] NOT NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[parent_domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[status] [int] NOT NULL,
[type_1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[type_2] [int] NULL,
[p_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_title] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_address1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_address2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_state] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_zip] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_country] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_tel] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_fax] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[p_email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[opened_date] [datetime] NOT NULL,
[closed_date] [datetime] NULL,
[active_date] [datetime] NULL,
[inactive_date] [datetime] NULL,
[enum_1] [int] NULL,
[text_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text_3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[numeric_1] [float] NULL,
[numeric_2] [float] NULL,
[date_1] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_payment_method] ADD CONSTRAINT [XPKusm_payment_method] PRIMARY KEY CLUSTERED ([account_no], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_payment_method_idx_01] ON [dbo].[usm_payment_method] ([account_no], [status], [type_1]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_payment_method_idx_02] ON [dbo].[usm_payment_method] ([account_no], [type_1]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_payment_method] ADD CONSTRAINT [$usm_p_r000027d900000000] FOREIGN KEY ([account_no]) REFERENCES [dbo].[usm_billing_account] ([account_no])
GO
GRANT SELECT ON  [dbo].[usm_payment_method] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_payment_method] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_payment_method] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_payment_method] TO [usmgroup]
GO