WebSphere Commerce database table: VIEWREG

This table defines the views.


Column Description(s):
Column NameColumn TypeDescription
VIEWNAME VARCHAR(254) NOT NULL View name for this entry.
DEVICEFMT_ID INTEGER NOT NULL The identifier of the device to which the view will be sent.
STOREENT_ID INTEGER NOT NULL Store reference number for this view.
INTERFACENAME VARCHAR(254) NOT NULL Java interface for the view command name.
CLASSNAME VARCHAR(254) Java class name for the view command.
PROPERTIES VARCHAR(254) Name value pairs used by this view.
DESCRIPTION VARCHAR(254) A description of the view.
HTTPS INTEGER DEFAULT 0 Secure HTTP required for this view. HTTPS is required when this field is set to 1.
LASTUPDATE TIMESTAMP Last update for this entry.
INTERNAL INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
ALLOWEDCLIENTS VARCHAR(254) The clients allowed to access this view. This typically is the name of the webapp that will access this view.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031326210 VIEWNAME+DEVICEFMT_ID+STOREENT_ID Primary Key
I0000830 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_908 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_907 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback