Database Table: IITEMLIST

Each row in this table represents an InterestItemList.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NOT NULL, DEFAULT ''
A mnemonic description of the IItemList, entered by the customer and suitable for display to the customer.
IITEMLIST_ID BIGINT
NOT NULL
Generated unique key.
LASTUPDATE TIMESTAMP
NULL
The last time this IItemList was updated.
MEMBER_ID BIGINT
NOT NULL
The owner of the IItemList.
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
May be used by a user interface to control the sequence of IItemLists in a list.
Indexes:
Index Name Indexed Column Names Index Type
I0000132 IITEMLIST_ID, SEQUENCE, MEMBER_ID Unique Index
I0000133 IITEMLIST_ID, MEMBER_ID Unique Index
SQL030416034944750 IITEMLIST_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_383 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_239 IITEMLIST_ID CIITEMLIST IITEMLIST_ID Cascade
F_379 IITEMLIST_ID IITEM IITEMLIST_ID Cascade