WebSphere Commerce database table: VENDORDESC

Language-specific information about Vendors.

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235306210 VENDOR_ID+LANGUAGE_ID Primary Key
I0000829 STADDRESS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference