This table defines the views.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index Type |
SQL050212031326210 |
VIEWNAME+DEVICEFMT_ID+STOREENT_ID |
Primary Key |
I0000830 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_908 |
DEVICEFMT_ID |
DEVICEFMT |
DEVICEFMT_ID |
Cascade |
F_907 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.