[dbo].[HARAPPROVE]

Property	Value
Row Count	14
Created	4:59:31 AM Monday, March 02, 2009
Last Modified	5:00:25 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)
$Cluster Primary Key HARAPPROVE_PK: PROCESSOBJID\STATEOBJID$ $Foreign Keys HARAPPOVE_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$	PROCESSOBJID	int		4
	PROCESSNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Cluster Primary Key HARAPPROVE_PK: PROCESSOBJID\STATEOBJID$ $Foreign Keys HARAPPOVE_SPID_FK: [dbo].[HARSTATEPROCESS].STATEOBJID\PROCESSOBJID$	STATEOBJID	int		4
	CREATIONTIME	datetime		8
	CREATORID	int		4
	MODIFIEDTIME	datetime		8
	MODIFIERID	int		4
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000

	Name	Columns	Unique
$Cluster Primary Key HARAPPROVE_PK: PROCESSOBJID\STATEOBJID$	HARAPPROVE_PK	PROCESSOBJID, STATEOBJID

Name	Delete	Columns
HARAPPOVE_SPID_FK	Cascade	STATEOBJID->[dbo].[HARSTATEPROCESS].[STATEOBJID] PROCESSOBJID->[dbo].[HARSTATEPROCESS].[PROCESSOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARAPPROVE table stores the definition of an approve process.
Caption	COLUMN	CREATIONTIME	Time process was created
Caption	COLUMN	CREATORID	Object ID of user to create
Caption	COLUMN	MODIFIEDTIME	Time process was modified
Caption	COLUMN	MODIFIERID	Object ID of user to modify
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	PROCESSNAME	Name of the process
Caption	COLUMN	PROCESSOBJID	Object ID of process
Caption	COLUMN	STATEOBJID	Object ID of state

SQL Script

CREATE TABLE [dbo].[HARAPPROVE]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[STATEOBJID] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAPPROVE] ADD CONSTRAINT [HARAPPROVE_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID], [STATEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAPPROVE] ADD CONSTRAINT [HARAPPOVE_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAPPROVE table stores the definition of an approve process.', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time process was created', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user to create', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time process was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user to modify', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARAPPROVE', 'COLUMN', N'STATEOBJID'
GO