pears.CISTemplate

Pre 2007 legislation change - Construction Industry Scheme Templates

• CISTemplateID

• No outgoing foreign keys found.

• No indexes found.

• No triggers found.

-- 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