WebSphere Commerce database table: POLICYDESC

This table stores descriptions for a business policy.


Column Description(s):
Column NameColumn TypeDescription
POLICY_ID BIGINT NOT NULL The policy ID.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(508) NOT NULL The policy description.
LONGDESCRIPTION VARCHAR(4000) The policy long description.
TIMECREATED TIMESTAMP Time created.
TIMEUPDATED TIMESTAMP Time updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031256740 POLICY_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_611 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_612 POLICY_ID POLICY POLICY_ID Cascade

Feedback