CREATE TABLE [dbo].[survey_tracking]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[del] [int] NOT NULL,
[tplid] [int] NULL,
[cntid] [binary] (16) NULL,
[object_type] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[object_id] [int] NULL,
[status] [int] NULL,
[notif_dt] [int] NULL,
[recv_dt] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[survey_tracking] ADD CONSTRAINT [XPKsurvey_tracking] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [survey_tracking_x1] ON [dbo].[survey_tracking] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[survey_tracking] TO [service_desk_admin_group]
GRANT INSERT ON [dbo].[survey_tracking] TO [service_desk_admin_group]
GRANT DELETE ON [dbo].[survey_tracking] TO [service_desk_admin_group]
GRANT UPDATE ON [dbo].[survey_tracking] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[survey_tracking] TO [service_desk_ro_group]
GO
[dbo].[survey_tracking]
