CREATE TABLE [dbo].[kt_report_card]
(
[id] [int] NOT NULL,
[subject_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[past_days] [int] NULL,
[org_statistics] [int] NULL,
[documents_submitted] [int] NULL,
[documents_published] [int] NULL,
[total_hits] [int] NULL,
[average_effectiveness_rating] [int] NULL,
[total_solution_count] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[total_votes] [int] NULL,
[avg_rating] [float] NULL,
[user_slv_cnt] [int] NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[linked_knowledge_by_others] [int] NULL,
[linked_knowledge_by_me] [int] NULL,
[closed_tickets] [int] NULL,
[tickets_with_knowledge] [int] NULL,
[tickets_had_search_activities] [int] NULL,
[knowledge_submit_from_ticket] [int] NULL,
[time_to_publish] [int] NULL,
[my_comments] [int] NULL,
[documents_retired] [int] NULL,
[time_to_fix] [int] NULL,
[flags_fixed] [int] NULL,
[comments_on_my_documents] [int] NULL,
[first_call_res_with_know] [int] NULL,
[first_call_res_without_know] [int] NULL,
[all_org_ref_id] [int] NULL,
[avg_hits] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[avg_rating_text] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contributor_uuid] [binary] (16) NULL,
[documents_published_percent] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[is_supervisor] [int] NULL,
[last_mod_dt_text] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[my_org_ref_id] [int] NULL,
[past_days_text] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[supervisor_uuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[kt_report_card] ADD CONSTRAINT [XPKkt_report_card] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x7] ON [dbo].[kt_report_card] ([all_org_ref_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x2] ON [dbo].[kt_report_card] ([avg_rating]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x4] ON [dbo].[kt_report_card] ([contributor_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x6] ON [dbo].[kt_report_card] ([my_org_ref_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [kt_report_card_x0] ON [dbo].[kt_report_card] ([subject_id], [past_days], [org_statistics]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x5] ON [dbo].[kt_report_card] ([supervisor_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x1] ON [dbo].[kt_report_card] ([total_votes]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kt_report_card_x3] ON [dbo].[kt_report_card] ([user_slv_cnt]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[kt_report_card] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[kt_report_card] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[kt_report_card] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[kt_report_card] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[kt_report_card] TO [service_desk_ro_group]
GO