CREATE TABLE [dbo].[process_step]
(
	[proc_step_id] INT NOT NULL, 
    [proc_step_title] NVARCHAR(50) NOT NULL, 
    [proc_step_description] NVARCHAR(MAX) NULL, 
    [proc_step_action] NVARCHAR(MAX) NULL, 
    [proc_step_number] INT NOT NULL, 
    [proc_type_id] INT NOT NULL, 
    [active] BIT NOT NULL DEFAULT 1, 
    [proc_step_edit_enabled] BIT NOT NULL DEFAULT 0, 
    [proc_lock] BIT NOT NULL DEFAULT 0, 
    CONSTRAINT [PK_process_step] PRIMARY KEY ([proc_step_id]), 
    CONSTRAINT [FK_process_step_to_process_type] FOREIGN KEY ([proc_type_id]) REFERENCES [process_type]([proc_type_id])
)
