WebSphere Commerce database table: URLREG

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


Column Description(s):
Column NameColumn TypeDescription
URL VARCHAR(254) NOT NULL URI name.
STOREENT_ID INTEGER NOT NULL Store reference number for this URI.
INTERFACENAME VARCHAR(254) NOT NULL Controller command Java Interface Name.
HTTPS INTEGER NOT NULL DEFAULT 0 Secure HTTP required for this URI.
DESCRIPTION VARCHAR(254) Description for this URI.
AUTHENTICATED INTEGER User sign-in is required for this URI.
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 URL. This is typically the webapp that call this URL.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031324610 STOREENT_ID+URL Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_887 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback