Table of Contents



pears.SubsidyType

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

Columns

Column Type Null Default Comment
SubsidyTypeID char(2) NOT NULL
Description char(40) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."SubsidyType"
-- Table comment: 
-- Statement count: 1
 
CREATE TABLE "pears"."SubsidyType" (
    "SubsidyTypeID"                  CHAR(2) NOT NULL
   ,"Description"                    CHAR(40) NULL
   ,PRIMARY KEY ("SubsidyTypeID" ASC) 
)
GO