OFFERDESC

Each row in this table contains language-dependent information for an Offer.

Column Descriptions:

NameTypeDescription
OFFER_IDBIGINT NOT NULLThe Offer being described.
LANGUAGE_IDINTEGER NOT NULLThe language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTIONVARCHAR (254)A description of the Offer, suitable for display to customers.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>OFFER_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_470OFFER_IDOFFEROFFER_IDCascade
F_471LANGUAGE_IDLANGUAGELANGUAGE_IDCascade