[dbo].[jmo_modeltemp]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:18 AM Wednesday, March 07, 2007
Last Modified	11:10:02 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

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

Last Modified

11:10:02 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	reportid	char(11)	11
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	year	int	4
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	month	smallint	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	day	smallint	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	hour	smallint	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	minute	smallint	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	second	smallint	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	objecttype	char(2)	2
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	objectname	varchar(137)	137
	causingobjecttype	char(2)	2
	causingobjectname	varchar(137)	137
	newstatus	char(2)	2
	units	char(5)	5

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

reportid

char(11)

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

year

int

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

month

smallint

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

day

smallint

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

hour

smallint

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

minute

smallint

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

second

smallint

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

objecttype

char(2)

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

objectname

varchar(137)

137

causingobjecttype

char(2)

causingobjectname

varchar(137)

137

newstatus

char(2)

units

char(5)

	Name	Columns	Unique
$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$	baseidx_jmo_modeltemp	reportid, year, month, day, hour, minute, second, objecttype, objectname

Name

Columns

Unique

$Cluster Key baseidx_jmo_modeltemp: reportid\year\month\day\hour\minute\second\objecttype\objectname$

baseidx_jmo_modeltemp

reportid, year, month, day, hour, minute, second, objecttype, objectname

Type	Action	Owning Principal
Grant	Insert	uniadmin
Grant	Delete	emadmin
Grant	Insert	emadmin
Grant	Delete	jmoadmin
Grant	Insert	jmoadmin
Grant	Delete	uniadmin
Grant	Select	emadmin
Grant	Update	emadmin
Grant	Select	emuser
Grant	Select	jmoadmin
Grant	Update	jmoadmin
Grant	Select	jmouser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

Type

Action

Owning Principal

Grant

Insert

uniadmin

Grant

Delete

emadmin

Grant

Insert

emadmin

Grant

Delete

jmoadmin

Grant

Insert

jmoadmin

Grant

Delete

uniadmin

Grant

Select

emadmin

Grant

Update

emadmin

Grant

Select

emuser

Grant

Select

jmoadmin

Grant

Update

jmoadmin

Grant

Select

jmouser

Grant

Select

uniadmin

Grant

Update

uniadmin

Grant

Select

uniuser

SQL Script

CREATE TABLE [dbo].[jmo_modeltemp]
(
[reportid] [char] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[year] [int] NOT NULL,
[month] [smallint] NOT NULL,
[day] [smallint] NOT NULL,
[hour] [smallint] NOT NULL,
[minute] [smallint] NOT NULL,
[second] [smallint] NOT NULL,
[objecttype] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[objectname] [varchar] (137) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[causingobjecttype] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[causingobjectname] [varchar] (137) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[newstatus] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[units] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_modeltemp] ON [dbo].[jmo_modeltemp] ([reportid], [year], [month], [day], [hour], [minute], [second], [objecttype], [objectname]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_modeltemp] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_modeltemp] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_modeltemp] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_modeltemp] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_modeltemp] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_modeltemp] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_modeltemp] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_modeltemp] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_modeltemp] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_modeltemp] TO [uniuser]
GO