POLICYDESC

This table stores descriptions for a business policy.


Column Descriptions:

Name Type Description
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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> POLICY_ID+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_611 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_612 POLICY_ID POLICY POLICY_ID Cascade


Related reference
Contract data model