[dbo].[HARFORMTEMPLATES]

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key HARFORMTEMPLATES_PK: FORMTYPEOBJID\FILEEXTENSION$	FORMTYPEOBJID	int	4
$Cluster Primary Key HARFORMTEMPLATES_PK: FORMTYPEOBJID\FILEEXTENSION$	FILEEXTENSION	varchar(64)	64
	FILESIZE	int	4
	FILEDATA	image	max
	CREATORID	int	4
	CREATIONTIME	datetime	8
	MODIFIERID	int	4
	MODIFIEDTIME	datetime	8

	Name	Columns	Unique
$Cluster Primary Key HARFORMTEMPLATES_PK: FORMTYPEOBJID\FILEEXTENSION$	HARFORMTEMPLATES_PK	FORMTYPEOBJID, FILEEXTENSION

Name	Delete	Columns
HARFORMTEMPLATES_FTID_FK	Cascade	FORMTYPEOBJID->[dbo].[HARFORMTYPE].[FORMTYPEOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARFORMTEMPLATES table stores form type templates.
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	FILEDATA	Actual template form type template data
Caption	COLUMN	FILEEXTENSION	Extension name of form type template file name
Caption	COLUMN	FILESIZE	Size of form type template data in bytes
Caption	COLUMN	FORMTYPEOBJID	Object ID of form type
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier

SQL Script

CREATE TABLE [dbo].[HARFORMTEMPLATES]
(
[FORMTYPEOBJID] [int] NOT NULL,
[FILEEXTENSION] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FILESIZE] [int] NOT NULL,
[FILEDATA] [image] NULL,
[CREATORID] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORMTEMPLATES] ADD CONSTRAINT [HARFORMTEMPLATES_PK] PRIMARY KEY CLUSTERED ([FORMTYPEOBJID], [FILEEXTENSION]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORMTEMPLATES] ADD CONSTRAINT [HARFORMTEMPLATES_FTID_FK] FOREIGN KEY ([FORMTYPEOBJID]) REFERENCES [dbo].[HARFORMTYPE] ([FORMTYPEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARFORMTEMPLATES table stores form type templates. ', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Actual template form type template data', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'FILEDATA'
GO
EXEC sp_addextendedproperty N'Caption', N'Extension name of form type template file name', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'FILEEXTENSION'
GO
EXEC sp_addextendedproperty N'Caption', N'Size of form type template data in bytes', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'FILESIZE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form type', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'FORMTYPEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMTEMPLATES', 'COLUMN', N'MODIFIERID'
GO