[dbo].[HARFORMHISTORY]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	50
Created	4:59:46 AM Monday, March 02, 2009
Last Modified	5:00:26 AM Monday, March 02, 2009

Name	Data Type	Max Length (Bytes)
FORMOBJID	int	4
USROBJID	int	4
EXECDTIME	datetime	8
ACTION	varchar(128)	128

Name	Columns
HARFORMHIST_IND	FORMOBJID

Name	Delete	Columns
HARFORMHIST_FORMID_FK	Cascade	FORMOBJID->[dbo].[HARFORM].[FORMOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARFORMHISTORY table stores the definition of a history form.
Caption	COLUMN	ACTION	Action taken on object
Caption	COLUMN	EXECDTIME	Time of object execution
Caption	COLUMN	FORMOBJID	Object ID of form
Caption	COLUMN	USROBJID	Object ID of user

SQL Script

CREATE TABLE [dbo].[HARFORMHISTORY]
(
[FORMOBJID] [int] NOT NULL,
[USROBJID] [int] NOT NULL,
[EXECDTIME] [datetime] NOT NULL,
[ACTION] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARFORMHIST_IND] ON [dbo].[HARFORMHISTORY] ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORMHISTORY] ADD CONSTRAINT [HARFORMHIST_FORMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARFORMHISTORY table stores the definition of a history form. ', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMHISTORY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Action taken on object', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMHISTORY', 'COLUMN', N'ACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of object execution', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMHISTORY', 'COLUMN', N'EXECDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMHISTORY', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMHISTORY', 'COLUMN', N'USROBJID'
GO