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 Name Column Type Column Description
CONTENTDIR VARCHAR (80)
NOT NULL
Directory which contains contents for device models of this specification.
DESCRIPTION VARCHAR (128)
NULL
Short description of the device specification.
DOCUMENTFORMAT VARCHAR (80)
NULL
The supported document format. For example, HTML, CHTML, HDML, WML, or MML.
DOCUMENTVERSION VARCHAR (8)
NULL
The supported document version. For example 1.0, 2.0, or 3.0.
IMAGEFORMAT VARCHAR (80)
NULL
The supported image formats. For example, JPG, GIF, or BMP.
LCDCOLORS INTEGER
NULL
Number of colors the LCD panel can display.
LCDHEIGHT INTEGER
NULL
Height of the LCD panel in pixels.
LCDMONOCHROME CHARACTER (1)
NULL
Specifies whether the LCD panel has a monochromatic display. Valid values:
0 = No or 1 = Yes.
LCDWIDTH INTEGER
NULL
Width of the LCD panel in pixels.
MAXCONTENTLENGTH INTEGER
NULL
The maximum content length in bytes.
MAXURLLENGTH INTEGER
NULL
The maximum URL length in bytes.
SESSIONTYPE VARCHAR (32)
NULL
Type of carrier. For example, iMode. This column is deprecated and is provided for backward compatibility only.
SOUNDFORMAT VARCHAR (80)
NULL
Supported sound formats. For example, WAV or MIDI.
SPECNAME VARCHAR (80)
NOT NULL
Name of the specification.
SPEC_ID INTEGER
NOT NULL
Reference number to identify the specification.
Indexes:
Index Name Indexed Column Names Index Type
I775148 SPECNAME Unique Index
SQL030416035043200 SPEC_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

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