Table of Contents



pears.CISTemplate

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Pre 2007 legislation change - Construction Industry Scheme Templates

Columns

Column Type Null Default Comment
EndDate date NULL
StartDate date NULL
TemplateName char(30) NULL
CISType char(10) NOT NULL
AuthUser char(16) NULL
CISTemplateID char(20) NOT NULL
CertificateNumber char(13) NOT NULL
ActingFor char(26) NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.Pay_Employee CISTemplate CISTemplateID CISTemplateID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CISTemplate"
-- Table comment: Pre 2007 legislation change - Construction Industry Scheme Templates  
-- Statement count: 2
 
CREATE TABLE "pears"."CISTemplate" (
    "EndDate"                        DATE NULL
   ,"StartDate"                      DATE NULL
   ,"TemplateName"                   CHAR(30) NULL
   ,"CISType"                        CHAR(10) NOT NULL
   ,"AuthUser"                       CHAR(16) NULL
   ,"CISTemplateID"                  CHAR(20) NOT NULL
   ,"CertificateNumber"              CHAR(13) NOT NULL
   ,"ActingFor"                      CHAR(26) NULL
   ,PRIMARY KEY ("CISTemplateID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CISTemplate" IS 
	'Pre 2007 legislation change - Construction Industry Scheme Templates  '
GO