WebSphere Commerce database table: NOTIFY

Reserved for IBM internal use.

Column Descriptions
Column Name Column Type Description
NOTIFY_ID BIGINT NOT NULL Reserved for IBM internal use.
NOTIFICATIONID BIGINT Reserved for IBM internal use.
TRANSPORTATTNAME VARCHAR(254) Reserved for IBM internal use.
TRANSPORTATTVALUE VARCHAR(254) Reserved for IBM internal use.
TRANSPORT_ID INTEGER Reserved for IBM internal use.
MSGTYPE_ID INTEGER Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235215850 NOTIFY_ID Primary Key
I0000307 NOTIFICATIONID Non-Unique Index
I0000625 MSGTYPE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1022 MSGTYPE_ID MSGTYPES MSGTYPE_ID Cascade
F_1023 TRANSPORT_ID TRANSPORT TRANSPORT_ID Cascade