VENDORDESC

Language-specific information about Vendors.

Column Descriptions:

NameTypeDescription
VENDOR_IDBIGINT NOT NULLUnique identifier for the Vendor.
LANGUAGE_IDINTEGER NOT NULLLanguage ID for this description. For a list of language components, see the LANGUAGE table.
STADDRESS_IDINTEGER NOT NULLRefers to address information for this Vendor in the STADDRESS table.
DESCRIPTIONVARCHAR (254)Language specific descriptive information about the Vendor.
LASTUPDATETIMESTAMPTimestamp of last update.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>VENDOR_ID+LANGUAGE_IDPrimary Key
I0000829STADDRESS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_902STADDRESS_IDSTADDRESSSTADDRESS_IDCascade
F_903LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_904VENDOR_IDVENDORVENDOR_IDCascade