Skip to main content
Skip table of contents

ExtSchemaDefForeignKey (ver7.11.0)

This table contains foreign key definitions for database extension tables.

Column Name

Initial Version

Data Type

Description

ConstraintName

7.11.0

Varchar2(30)

Name of the constraint created in the child table. Required.

ExtSchemaDefTable_ID

7.11.0

Number(10)

Internal number, ID, of the related ExtSchemaDefTable record. Required.

FieldName

7.11.0

Varchar2(30)

The field name used in when creating the foreign keyed field in the child table. Required.

ID

7.11.0

Number(10)

Sequential number generated by the application, uniqueness in the table is not guaranteed. Required.

OnDeleteCascade

7.11.0

Number(1)

1 indicates the child records will automatically be deleted upon deletion of the parent record. Valid values: 1 = True, 0 = False. Defaults to 1. Required.

ParentTable

7.11.0

Varchar2(30)

The referenced database table name. Required.

ParentField

7.11.0

Varchar2(30)

The referenced database column of the ParentTable. Required.

WhenCreated

7.11.0

Timestamp(6)

Date and time the record was created. Defaults to system date.

WhenModified

7.11.0

Timestamp(6)

Date and time the record was modified. Defaults to system date.

WhoCreated

7.11.0

Varchar2(100)

The user login that created the record. Defaults to database user.

WhoModified

7.11.0

Varchar2(100)

The user login that modified the record. Defaults to database user.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.