CREATE TABLE [dbo].[HARUSDPACKAGEINFO]
(
[FORMOBJID] [int] NULL,
[DEPLOYDATE] [datetime] NULL,
[DEPLOYHOUR] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPLOYMINUTE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SOFTWAREVENDOR] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGENAMEPREFIX] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEVERSION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDPACKAGEINFO_FRM_IND] ON [dbo].[HARUSDPACKAGEINFO] ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSDPACKAGEINFO] ADD CONSTRAINT [HARUSDPACKAGEINFO_FRMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDPACKAGEINFO table maintains common USD package information.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Deployment date', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'DEPLOYDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'Deployment hour', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'DEPLOYHOUR'
GO
EXEC sp_addextendedproperty N'Caption', N'Deployment minute', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'DEPLOYMINUTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of software supplier', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'SOFTWAREVENDOR'
GO
EXEC sp_addextendedproperty N'Caption', N'The prefix value used to construct each USD package name', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'USDPACKAGENAMEPREFIX'
GO
EXEC sp_addextendedproperty N'Caption', N'The version of the software', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGEINFO', 'COLUMN', N'USDPACKAGEVERSION'
GO