DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_PROCESS_ID] ON [dbo].[PL_REQUEST_PROCESS] ([PROCESS_ID])

GO

CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID])

GO

CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS_CHILD] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([PROCESS_ID])

GO

CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([REQ_ID])

GO

CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_CHILD_TLNAME] ON [dbo].[PL_REQUEST_PROCESS_CHILD]([TLNAME])

CREATE NONCLUSTERED INDEX [IDX_TL_SYS_ROLE_MAPPING] ON [dbo].[TL_SYS_ROLE_MAPPING]([TLNAME])

INCLUDE([ROLE_OLD],[ROLE_NEW])