Table of Contents



pears.CompanyStatus

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

Description

Look-up of company statuses (both inbuilt and user defined)

Columns

Column Type Null Default Comment
CompanyStatusID char(1) NOT NULL
Name char(40) NOT NULL
Help char(40) NULL
IsFixed smallint NULL 0
Sortorder integer NULL
GridSortorder integer NULL
BackgroundColour integer NULL 16777215
FontColour integer NULL 0
OverrideFormColour tinyint NULL 0

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.Company companystatus status CompanyStatusID

Indexes

Triggers

Name Timing Event
WPK_companystatus_COMPANYSTATUS after insert,delete,update order 1

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CompanyStatus"
-- Table comment: Look-up of company statuses (both inbuilt and user defined)
-- Statement count: 4
 
CREATE TABLE "pears"."CompanyStatus" (
    "CompanyStatusID"                CHAR(1) NOT NULL
   ,"Name"                           CHAR(40) NOT NULL
   ,"Help"                           CHAR(40) NULL
   ,"IsFixed"                        SMALLINT NULL DEFAULT 0
   ,"Sortorder"                      INTEGER NULL
   ,"GridSortorder"                  INTEGER NULL
   ,"BackgroundColour"               INTEGER NULL DEFAULT 16777215
   ,"FontColour"                     INTEGER NULL DEFAULT 0
   ,"OverrideFormColour"             tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("CompanyStatusID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CompanyStatus" IS 
	'Look-up of company statuses (both inbuilt and user defined)'
GO
 
 
CREATE TRIGGER "WPK_companystatus_COMPANYSTATUS" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."companystatus"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('P','COMPANYSTATUS')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."CompanyStatus"."WPK_companystatus_COMPANYSTATUS" IS 
{CREATE TRIGGER WPK_companystatus_COMPANYSTATUS 
 after INSERT,DELETE,UPDATE ORDER 1 ON
companystatus
FOR each statement
BEGIN
  CALL WPKTrackChange('P','COMPANYSTATUS')
END
}
GO