WebSphere Commerce database table: PVCDEVSPEC

This table represents minimum specification of pervasive computing devices which are categorized by PVCMDLSPEC. Records of this table will be set in the appropriate adapter.

Column Descriptions
Column Name Column Type Description
SPEC_ID INTEGER NOT NULL Reference number to identify the specification.
SPECNAME VARCHAR(80) NOT NULL Name of the specification.
SESSIONTYPE VARCHAR(32) Type of carrier. For example, iMode. This column is deprecated and is provided for backward compatibility only.
MAXCONTENTLENGTH INTEGER The maximum content length in bytes.
MAXURLLENGTH INTEGER The maximum URL length in bytes.
LCDWIDTH INTEGER Width of the LCD panel in pixels.
LCDHEIGHT INTEGER Height of the LCD panel in pixels.
LCDCOLORS INTEGER Number of colors the LCD panel can display.
LCDMONOCHROME CHAR(1) Specifies whether the LCD panel has a monochromatic display. Valid values are as follows:
  • 0=No
  • 1=Yes
IMAGEFORMAT VARCHAR(80) The supported image formats. For example, JPG, GIF, or BMP.
SOUNDFORMAT VARCHAR(80) Supported sound formats. For example, WAV or MIDI.
DOCUMENTFORMAT VARCHAR(80) The supported document format. For example, HTML, CHTML, HDML, WML, or MML.
DOCUMENTVERSION VARCHAR(8) The supported document version. For example 1.0, 2.0, or 3.0.
CONTENTDIR VARCHAR(80) NOT NULL Directory which contains contents for device models of this specification.
DESCRIPTION VARCHAR(128) Short description of the device specification.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I775148 SPECNAME Unique Index
SQL060903235237930 SPEC_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_638 SPEC_ID PVCMDLSPEC SPEC_ID Cascade

Related reference