SyteLine Custom Table CREATE Script Generator (with Standard Columns)

-- Custom table following SyteLine conventions. Test in a development database first.
CREATE TABLE dbo.ue_tool_crib_log_mst (
  site_ref nvarchar(8) NOT NULL,
  log_id nvarchar(30) NOT NULL,
  tool_id nvarchar(30) NOT NULL,
  issued_to nvarchar(30) NULL,
  issue_date datetime NULL,
  qty decimal(19,8) NOT NULL DEFAULT 0,
  NoteExistsFlag tinyint NOT NULL DEFAULT 0,
  RecordDate datetime NOT NULL DEFAULT GETDATE(),
  RowPointer uniqueidentifier NOT NULL DEFAULT NEWID(),
  CreatedBy nvarchar(128) NOT NULL DEFAULT SUSER_SNAME(),
  UpdatedBy nvarchar(128) NOT NULL DEFAULT SUSER_SNAME(),
  CreateDate datetime NOT NULL DEFAULT GETDATE(),
  InWorkflow tinyint NOT NULL DEFAULT 0,
  CONSTRAINT PK_ue_tool_crib_log_mst PRIMARY KEY CLUSTERED (site_ref, log_id)
);
GO

CREATE UNIQUE NONCLUSTERED INDEX IX_ue_tool_crib_log_mst_RowPointer
  ON dbo.ue_tool_crib_log_mst (RowPointer);
GO

-- Insert and read back one row, then roll back
BEGIN TRAN;
INSERT INTO dbo.ue_tool_crib_log_mst (site_ref, log_id) VALUES (N'DEFAULT', N'TEST-001');
SELECT TOP (5) * FROM dbo.ue_tool_crib_log_mst;
ROLLBACK TRAN;