CREATE TABLE [dbo].[HARTESTINGINFO]
(
[FORMOBJID] [int] NOT NULL,
[DEVDATE] [datetime] NULL,
[TESTDATE] [datetime] NULL,
[DEVELOPER] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TESTER] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEVCOMMENTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TESTCOMMENTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TESTCASES] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TESTRESULTS] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARTESTINGINFO] ADD CONSTRAINT [HARTESTINGINFO_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARTESTINGINFO] ADD CONSTRAINT [HARTESTINGINFO_FORMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARTESTINGINFO table stores the definition of a testing form. ', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'DEVCOMMENTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'DEVDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'DEVELOPER'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'TESTCASES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'TESTCOMMENTS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'TESTDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'TESTER'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARTESTINGINFO', 'COLUMN', N'TESTRESULTS'
GO