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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035144440 | VIEWNAME, DEVICEFMT_ID, STOREENT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|