CREATE TABLE [dbo].[prov_practice] (
    [prov_prac_key]          INT              IDENTITY (1, 1) NOT NULL,
    [prov_prac_no]           VARCHAR (20)     NULL,
    [prov_prac_name]         VARCHAR (100)    NULL,
    [prov_prac_type] VARCHAR (20)     NULL,
    [prov_prac_expiry_dt]    DATETIME         NULL,
    [modified_dt]            DATETIME         NULL,
    [modified_by_key]        UNIQUEIDENTIFIER NULL,
    CONSTRAINT [prov_practice_PK] PRIMARY KEY CLUSTERED ([prov_prac_key] ASC)
);

