Reference > Database > WebSphere Commerce database tables > V
WebSphere Commerce database table: VENDORDESC
Language-specific information about Vendors.
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 SQL100520030445650 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
_vcc_freeselect_bottom_