pears.NominalSegment

Nominal Code segments used to build up the nominal code attached to placement income.

• NominalSegmentID

• No outgoing foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."NominalSegment"
-- Table comment: Nominal Code segments used to build up the nominal code attached to placement income.
-- Statement count: 5
 
CREATE TABLE "pears"."NominalSegment" (
    "NominalSegmentID"               CHAR(20) NOT NULL
   ,"SegmentNumber"                  SMALLINT NOT NULL
   ,"CodeFragment"                   CHAR(12) NOT NULL
   ,"Description"                    CHAR(20) NULL
   ,"PermTemp"                       CHAR(1) NOT NULL
   ,"sortorder"                      INTEGER NULL
   ,"Defunct"                        tinyint NULL
   ,PRIMARY KEY ("NominalSegmentID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."NominalSegment"."SegmentNumber" IS 
	'1 to 5'
GO
 
 
COMMENT ON COLUMN "pears"."NominalSegment"."PermTemp" IS 
	'P, T or B for both'
GO
 
 
COMMENT ON TABLE "pears"."NominalSegment" IS 
	'Nominal Code segments used to build up the nominal code attached to placement income.'
GO
 
 
CREATE UNIQUE INDEX "SegmentNumber_CodeFragment" ON "pears"."NominalSegment"
    ( "SegmentNumber","CodeFragment" )
GO