Create table template for Processware Database

Language:: T-SQL
Type:: Back-end Persistence
Context:: Standard database script to create a table with standard columns.

• ProcessWare 2019
• Upsert stored procedure template for ProcessWare database
• Generate Stored Procs with Standards

Snippet

CREATE TABLE TABLE_NAME (
    ID bigint NOT NULL IDENTITY(1,1),
    ProcessID BIGINT NOT NULL,
    -- Additional Columns
    
    -- Standard Columns
    CreatedDate DATETIME DEFAULT GetDate(),
    CreatedBy BIGINT NOT NULL,
    ModifiedDate DATETIME NULL,
    ModifiedBy BIGINT NULL,
    IsActive BIT NOT NULL DEFAULT (1),
    
    CONSTRAINT PK_TABLE_NAME PRIMARY KEY (ID)
)

Dependencies:: MS Sql

Type:: snippet