Table of Contents



pears.NominalSegment

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

Description

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

Columns

Column Type Null Default Comment
NominalSegmentID char(20) NOT NULL
SegmentNumber smallint NOT NULL 1 to 5
CodeFragment char(12) NOT NULL
Description char(20) NULL
PermTemp char(1) NOT NULL P, T or B for both
sortorder integer NULL
Defunct tinyint NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.SegmentTarget NominalSegment NominalSegmentID NominalSegmentID

Indexes

Name Type Columns Detail
SegmentNumber_CodeFragment Unique index SegmentNumber, CodeFragment

Triggers

Original SQL

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