Table of Contents



pears.ExpenseBenefitChoice

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

Description

Lookup of choices for Expense Benefit Scheme Items

Columns

Column Type Null Default Comment
ExpenseBenefitChoiceID char(20) NOT NULL
ExpenseBenefitTypeID char(20) NULL
Description char(50) NULL
Value double NULL
SortOrder integer NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
ExpenseBenefitType ExpenseBenefitTypeID pears.ExpenseBenefitType (ExpenseBenefitTypeID) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ExpenseBenefitChoice"
-- Table comment: Lookup of choices for Expense Benefit Scheme Items
-- Statement count: 3
 
CREATE TABLE "pears"."ExpenseBenefitChoice" (
    "ExpenseBenefitChoiceID"         CHAR(20) NOT NULL
   ,"ExpenseBenefitTypeID"           CHAR(20) NULL
   ,"Description"                    CHAR(50) NULL
   ,"Value"                          DOUBLE NULL
   ,"SortOrder"                      INTEGER NULL
   ,PRIMARY KEY ("ExpenseBenefitChoiceID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."ExpenseBenefitChoice" IS 
	'Lookup of choices for Expense Benefit Scheme Items'
GO
 
 
ALTER TABLE "pears"."ExpenseBenefitChoice"
    ADD FOREIGN KEY "ExpenseBenefitType" ("ExpenseBenefitTypeID" ASC)
    REFERENCES "pears"."ExpenseBenefitType" ("ExpenseBenefitTypeID")
    ON DELETE CASCADE
GO