[dbo].[STATJOB]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	17
Created	3:44:41 PM Friday, June 13, 2003
Last Modified	3:44:41 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

3:44:41 PM Friday, June 13, 2003

Last Modified

3:44:41 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$	UDOMID	int	4
$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$	UNITID	int	4
$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$	JDOMID	int	4
$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$	JOBID	int	4
	STATUS	int	4
	STCOUNT	int	4
	STQCOUNT	int	4
	STDATE	int	4
	STELAPSE	int	4
	STTEXT	varchar(127)	127
	STREV	int	4
	STFLAG	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$

UDOMID

int

$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$

UNITID

int

$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$

JDOMID

int

$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$

JOBID

int

STATUS

int

STCOUNT

int

STQCOUNT

int

STDATE

int

STELAPSE

int

STTEXT

varchar(127)

127

STREV

int

STFLAG

int

	Name	Columns	Unique
$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$	STATJOB_PK	UNITID, JOBID, UDOMID, JDOMID

Name

Columns

Unique

$Primary Key STATJOB_PK: UNITID\JOBID\UDOMID\JDOMID$

STATJOB_PK

UNITID, JOBID, UDOMID, JDOMID

SQL Script

CREATE TABLE [dbo].[STATJOB]
(
[UDOMID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[JDOMID] [int] NOT NULL,
[JOBID] [int] NOT NULL,
[STATUS] [int] NULL,
[STCOUNT] [int] NULL,
[STQCOUNT] [int] NULL,
[STDATE] [int] NULL,
[STELAPSE] [int] NULL,
[STTEXT] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STREV] [int] NULL,
[STFLAG] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[STATJOB] ADD CONSTRAINT [STATJOB_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [JOBID], [UDOMID], [JDOMID]) ON [PRIMARY]
GO