Database Table: VIEWREG

This table defines the views.

Column Name Column Type Column Description
CLASSNAME VARCHAR (254)
NULL
Java class name for the view command.
DESCRIPTION VARCHAR (254)
NULL
A description of the view.
DEVICEFMT_ID INTEGER
NOT NULL
The identifier of the device to which the view will be sent.
HTTPS INTEGER
NULL, DEFAULT 0
Secure HTTP required for this view. HTTPS is required when this field is set to 1.
INTERFACENAME VARCHAR (254)
NOT NULL
Java interface for the view command name.
INTERNAL INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
LASTUPDATE TIMESTAMP
NULL
Last update for this entry.
PROPERTIES VARCHAR (254)
NULL
Name value pairs used by this view.
STOREENT_ID INTEGER
NOT NULL
Store reference number for this view.
VIEWNAME VARCHAR (254)
NOT NULL
View name for this entry.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035144440 VIEWNAME, DEVICEFMT_ID, STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_907 STOREENT_ID STOREENT STOREENT_ID Cascade
F_908 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable