WebSphere Commerce database table: VENDOR

Each row defines a Vendor who has a relationship with a Store, or all the Stores in a StoreGroup, generally to provide inventory.


Column Description(s):
Column NameColumn TypeDescription
VENDOR_ID BIGINT NOT NULL Generated unique identifier.
STOREENT_ID INTEGER NOT NULL The Vendor has a relationship with this Store, or all the Stores in this StoreGroup.
LASTUPDATE TIMESTAMP The time this row was most recently updated.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this Vendor has been marked for deletion:
0 = No.
1 = Yes, this Vendor and its associated values may be deleted from the system.
VENDORNAME CHAR(30) NOT NULL Uniquely identifies the Vendor for this StoreEntity.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000263 STOREENT_ID+VENDORNAME Unique Index
SQL050212031325750 VENDOR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_901 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_651 VENDOR_ID RA VENDOR_ID Cascade
F_664 VENDOR_ID RECEIPT VENDOR_ID Cascade
F_904 VENDOR_ID VENDORDESC VENDOR_ID Cascade

Feedback