CREATE TABLE [dbo].[harharvest]
(
[usrgrpobjid] [int] NOT NULL,
[secureharvest] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__secur__4341E1B1] DEFAULT ('N'),
[adminuser] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__admin__443605EA] DEFAULT ('N'),
[viewuser] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__viewu__452A2A23] DEFAULT ('N'),
[adminenvironment] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__admin__461E4E5C] DEFAULT ('N'),
[viewenvironment] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__viewe__47127295] DEFAULT ('N'),
[adminrepository] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__admin__480696CE] DEFAULT ('N'),
[viewrepository] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__viewr__48FABB07] DEFAULT ('N'),
[adminformtype] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__admin__49EEDF40] DEFAULT ('N'),
[viewformtype] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harharves__viewf__4AE30379] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harharvest] ADD CONSTRAINT [XPKharharvest] 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
GRANT SELECT ON  [dbo].[harharvest] TO [harvest_group]
GRANT INSERT ON  [dbo].[harharvest] TO [harvest_group]
GRANT DELETE ON  [dbo].[harharvest] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harharvest] TO [harvest_group]
GRANT SELECT ON  [dbo].[harharvest] TO [harvest_rep]
GO