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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I775148 SPECNAME Unique Index
SQL050212031300270 SPEC_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_638 SPEC_ID PVCMDLSPEC SPEC_ID Cascade

Feedback