CREATE TABLE [dbo].[prov_discipline] (
    [prov_discipline_code]          INT          NOT NULL,
    [prov_discipline_desc]          VARCHAR (60) NOT NULL,
    [prov_discipline_group_1_key]   INT          NOT NULL,
    [prov_discipline_group_1_desc]  VARCHAR (50) NOT NULL,
    [prov_discipline_group_2_key]   INT          NOT NULL,
    [prov_discipline_group_2_desc]  VARCHAR (50) NOT NULL,
    [prov_cat_1_key]                INT          NULL,
    [prov_cat_1_desc]               VARCHAR (50) NULL,
    [prov_discipline_display_order] INT          NULL,
    [prov_discipline_active]        BIT          NOT NULL,
    CONSTRAINT [PK__prov_dis__918DB32DB3D0FB88] PRIMARY KEY CLUSTERED ([prov_discipline_code] ASC)
);


GO
CREATE NONCLUSTERED INDEX [prov_discipline_group_2_key_idx]
    ON [dbo].[prov_discipline]([prov_discipline_group_2_key] ASC);


GO
CREATE NONCLUSTERED INDEX [prov_discipline_group_1_key_idx]
    ON [dbo].[prov_discipline]([prov_discipline_group_1_key] ASC);


GO
CREATE NONCLUSTERED INDEX [prov_discipline_code_idx]
    ON [dbo].[prov_discipline]([prov_discipline_code] ASC);


GO
CREATE NONCLUSTERED INDEX [prov_cat_1_key_idx]
    ON [dbo].[prov_discipline]([prov_cat_1_key] ASC);

