PPM_INT_SOLUTIONS

This table stores solutions from a top level.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

SOLUTION_ID

NOT NULL

NUMBER

Primary key

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

VERSION

NOT NULL

NUMBER

System field for persistent layer, this field has nothing to do with the business

NAME

NOT NULL

VARCHAR2(400)

Name of the solution. This field will be MLUed and translation provided in LOC table.

DESCRIPTION

NOT NULL

VARCHAR2(2048)

Description of the solution. This field will be MLUed

PPM_VERSIONS

NOT NULL

VARCHAR2(200)

Version or versions of PPM.

EXTERNAL_SYSTEM_NAME

NOT NULL

VARCHAR2(200)

Name of external system

EXTERNAL_SYSTEM_VERSIONS

NOT NULL

VARCHAR2(200)

Version or versions of external system

CONFIGURATION_TEMPLATE

NULLABLE

CLOB

Template for configuration. It is optional and plan to be used by the generic configuration module (to be implemented).

CONFIGURATION_CLASS_NAME

NULLABLE

VARCHAR2(512)

Name of the class who handle configuration

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

Language to define the configuration

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

Derive from name with underscore prefix (for seeded only).

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005200861

UNIQUE

1

REFERENCE_CODE

SYS_C005201893

UNIQUE

1

SOLUTION_ID

Sequences

This table uses no sequences.