CREATE TABLE [dbo].[HARFORM]
(
[FORMOBJID] [int] NOT NULL,
[FORMTYPEOBJID] [int] NOT NULL,
[FORMNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORM] ADD CONSTRAINT [HARFORM_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARFORM_IND] ON [dbo].[HARFORM] ([FORMNAME], [FORMTYPEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORM] ADD CONSTRAINT [HARFORM_FTID_FK] FOREIGN KEY ([FORMTYPEOBJID]) REFERENCES [dbo].[HARFORMTYPE] ([FORMTYPEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARFORM table stores the definition of an object information form. ', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of form', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'FORMNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form type', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'FORMTYPEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARFORM', 'COLUMN', N'MODIFIERID'
GO