Database Table: POLICYDESC

This table stores descriptions for a business policy.

Column Name Column Type Column Description
DESCRIPTION VARCHAR (508)
NOT NULL
The policy description.
LANGUAGE_ID INTEGER
NOT NULL
The language ID. For a list of language components, see the LANGUAGE table.
LONGDESCRIPTION VARCHAR (4000)
NULL
The policy long description.
POLICY_ID BIGINT
NOT NULL
The policy ID.
TIMECREATED TIMESTAMP
NULL
Time created.
TIMEUPDATED TIMESTAMP
NULL
Time updated.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035037260 POLICY_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_611 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_612 POLICY_ID POLICY POLICY_ID Cascade

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