[usmuser].[usm_mr_iresult

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	8
Created	5:49:10 PM Tuesday, December 15, 2009
Last Modified	5:49:10 PM Tuesday, December 15, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

5:49:10 PM Tuesday, December 15, 2009

Last Modified

5:49:10 PM Tuesday, December 15, 2009

	Name	Data Type	Max Length (Bytes)
$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$	account_no	varchar(50)	50
$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$	service_code	int	4
	value	float	8
$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$	group_id	int	4
$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$	sequence_no	int	4
$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$	action	int	4
$Indexes usm_mr_iresult_100019idx3: sm_start_time\sm_end_time$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$	sm_start_time	datetime	8
$Indexes usm_mr_iresult_100019idx3: sm_start_time\sm_end_time$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$	sm_end_time	datetime	8
	data1	varchar(50)	50
	data2	varchar(50)	50
	data3	varchar(50)	50
	bulk_id	int	4
	status	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$

account_no

varchar(50)

$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$

service_code

int

value

float

$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$

group_id

int

$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$

sequence_no

int

$Indexes usm_mr_iresult_100019idx1: group_id\action\sequence_no\account_no\service_code$

action

int

$Indexes usm_mr_iresult_100019idx3: sm_start_time\sm_end_time$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$

sm_start_time

datetime

$Indexes usm_mr_iresult_100019idx3: sm_start_time\sm_end_time$ $Indexes usm_mr_iresult_100019idx2: sm_start_time\sm_end_time\account_no\service_code$

sm_end_time

datetime

data1

varchar(50)

data2

varchar(50)

data3

varchar(50)

bulk_id

int

status

int

Name	Columns
usm_mr_iresult_100019idx1	group_id, action, sequence_no, account_no, service_code
usm_mr_iresult_100019idx2	sm_start_time, sm_end_time, account_no, service_code
usm_mr_iresult_100019idx3	sm_start_time, sm_end_time

Name

Columns

usm_mr_iresult_100019idx1

group_id, action, sequence_no, account_no, service_code

usm_mr_iresult_100019idx2

sm_start_time, sm_end_time, account_no, service_code

usm_mr_iresult_100019idx3

sm_start_time, sm_end_time

SQL Script

CREATE TABLE [usmuser].[usm_mr_iresult_100019]
(
[account_no] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_code] [int] NULL,
[value] [float] NULL,
[group_id] [int] NULL,
[sequence_no] [int] NULL,
[action] [int] NULL,
[sm_start_time] [datetime] NULL,
[sm_end_time] [datetime] NULL,
[data1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bulk_id] [int] NULL,
[status] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iresult_100019idx1] ON [usmuser].[usm_mr_iresult_100019] ([group_id], [action], [sequence_no], [account_no], [service_code]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iresult_100019idx3] ON [usmuser].[usm_mr_iresult_100019] ([sm_start_time], [sm_end_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iresult_100019idx2] ON [usmuser].[usm_mr_iresult_100019] ([sm_start_time], [sm_end_time], [account_no], [service_code]) ON [PRIMARY]
GO