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. |
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 |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_383 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |