pears.WPKLookupType

Lookups for WPK types eg ViewItemType etc

• WPKLookupTypeID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKLookupType"
-- Table comment: Lookups for WPK types eg ViewItemType etc
-- Statement count: 4
 
CREATE TABLE "pears"."WPKLookupType" (
    "WPKLookupTypeID"                CHAR(20) NOT NULL
   ,"WPKArea"                        CHAR(50) NOT NULL
   ,"VisibleValue"                   CHAR(200) NOT NULL
   ,"StoredValue"                    CHAR(100) NOT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,PRIMARY KEY ("WPKLookupTypeID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKLookupType"."WPKArea" IS 
	'ViewType, ViewItemType, ViewItemDataType'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLookupType"."SortOrder" IS 
	'Orders the items in the lookup'
GO
 
 
COMMENT ON TABLE "pears"."WPKLookupType" IS 
	'Lookups for WPK types eg ViewItemType etc'
GO