[dbo].[HARUSDPACKAGENAMES]
CREATE TABLE [dbo].[HARUSDPACKAGENAMES]
(
[NAMEVERSION] [varchar] (172) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEVERSION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDPACKAGENAMES_NAME_IND] ON [dbo].[HARUSDPACKAGENAMES] ([NAMEVERSION]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDPACKAGENAMES table maintains USD package names. This information is synchronized on an interval basis. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGENAMES', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Combination of the previous two columns, for the sole purpose of populating the combo box', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGENAMES', 'COLUMN', N'NAMEVERSION'
GO
EXEC sp_addextendedproperty N'Caption', N'The name of the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGENAMES', 'COLUMN', N'USDPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The USD UUID of the package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGENAMES', 'COLUMN', N'USDPACKAGEUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The USD package version', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPACKAGENAMES', 'COLUMN', N'USDPACKAGEVERSION'
GO
