CREATE TABLE [dbo].[HARHARVEST]
(
[USRGRPOBJID] [int] NOT NULL,
[SECUREHARVEST] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__SECUR__5EBF139D] DEFAULT ('N'),
[ADMINUSER] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__ADMIN__5FB337D6] DEFAULT ('N'),
[VIEWUSER] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__VIEWU__60A75C0F] DEFAULT ('N'),
[ADMINENVIRONMENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__ADMIN__619B8048] DEFAULT ('N'),
[VIEWENVIRONMENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__VIEWE__628FA481] DEFAULT ('N'),
[ADMINREPOSITORY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__ADMIN__6383C8BA] DEFAULT ('N'),
[VIEWREPOSITORY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__VIEWR__6477ECF3] DEFAULT ('N'),
[ADMINFORMTYPE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__ADMIN__656C112C] DEFAULT ('N'),
[VIEWFORMTYPE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARHARVES__VIEWF__66603565] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARHARVEST] ADD CONSTRAINT [HARHARVEST_PK] PRIMARY KEY CLUSTERED ([USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARHARVEST] ADD CONSTRAINT [HARHARVEST_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARHARVEST table stores the definition of CA SCM object attributes. ', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Admin project access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'ADMINENVIRONMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'Admin form type access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'ADMINFORMTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Admin repository access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'ADMINREPOSITORY'
GO
EXEC sp_addextendedproperty N'Caption', N'Admin user access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'ADMINUSER'
GO
EXEC sp_addextendedproperty N'Caption', N'Secure access attribute', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'SECUREHARVEST'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'View project access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'VIEWENVIRONMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'View form type access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'VIEWFORMTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'View repository access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'VIEWREPOSITORY'
GO
EXEC sp_addextendedproperty N'Caption', N'View user access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARHARVEST', 'COLUMN', N'VIEWUSER'
GO