WebSphere Commerce database table: VENDORDESC

Language-specific information about Vendors.


Column Description(s):
Column NameColumn TypeDescription
VENDOR_ID BIGINT NOT NULL Unique identifier for the Vendor.
LANGUAGE_ID INTEGER NOT NULL Language ID for this description. For a list of language components, see the LANGUAGE table.
STADDRESS_ID INTEGER NOT NULL Refers to address information for this Vendor in the STADDRESS table.
DESCRIPTION VARCHAR(254) Language specific descriptive information about the Vendor.
LASTUPDATE TIMESTAMP Timestamp of last update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031325950 VENDOR_ID+LANGUAGE_ID Primary Key
I0000829 STADDRESS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_903 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_902 STADDRESS_ID STADDRESS STADDRESS_ID Cascade
F_904 VENDOR_ID VENDOR VENDOR_ID Cascade

Feedback