Database Table: VENDORDESC

Language-specific information about Vendors.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
Language specific descriptive information about the Vendor.
LANGUAGE_ID INTEGER
NOT NULL
Language ID for this description. For a list of language components, see the LANGUAGE table.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
STADDRESS_ID INTEGER
NOT NULL
Refers to address information for this Vendor in the STADDRESS table.
VENDOR_ID BIGINT
NOT NULL
Unique identifier for the Vendor.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035143710 VENDOR_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_902 STADDRESS_ID STADDRESS STADDRESS_ID Cascade
F_903 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_904 VENDOR_ID VENDOR VENDOR_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable