Database Table: URLREG

This table defines all the controller commands and their corresponding URI.

Column Name Column Type Column Description
AUTHENTICATED INTEGER
NULL
User sign-in is required for this URI.
DESCRIPTION VARCHAR (254)
NULL
Description for this URI.
HTTPS INTEGER
NOT NULL, DEFAULT 0
Secure HTTP required for this URI.
INTERFACENAME VARCHAR (254)
NOT NULL
Controller command Java Interface Name.
INTERNAL INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
STOREENT_ID INTEGER
NOT NULL
Store reference number for this URI.
URL VARCHAR (254)
NOT NULL
URI name.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035140360 STOREENT_ID, URL Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_887 STOREENT_ID STOREENT STOREENT_ID Cascade

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