MD_ADDITIONAL_PROPERTIES__FK1

General Info

Caption MD_ADDITIONAL_PROPERTIES__FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MD_APP_CONN_FK

General Info

Caption MD_APP_CONN_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_APPLICATIONS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MD_ARTIFACT_FILE_FK

General Info

Caption MD_ARTIFACT_FILE_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Child Entity MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_APPLICATIONFILES_PK' ID APPLICATIONFILES_ID

 

MD_CATALOGS_MD_CONNECTION_FK1

General Info

Caption MD_CATALOGS_MD_CONNECTION_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_CATALOGS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MD_COLUMNS_MD_TABLES_FK1

General Info

Caption MD_COLUMNS_MD_TABLES_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_TABLES
Child Entity MIGRATION_WORKBENCH.MD_COLUMNS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_TABLES_PK' ID TABLE_ID_FK

 

MD_CONNECTIONS_MD_PROJECT_FK1

General Info

Caption MD_CONNECTIONS_MD_PROJECT_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_PROJECTS
Child Entity MIGRATION_WORKBENCH.MD_CONNECTIONS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_PROJECTS_PK' ID PROJECT_ID_FK

 

MD_CONSTRAINT_DETAILS_MD__FK1

General Info

Caption MD_CONSTRAINT_DETAILS_MD__FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONSTRAINTS
Child Entity MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONSTRAINTS_PK' ID CONSTRAINT_ID_FK

 

MD_CONSTRAINT_DETAILS_MD__FK2

General Info

Caption MD_CONSTRAINT_DETAILS_MD__FK2
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_COLUMNS
Child Entity MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_COLUMNS_PK' ID COLUMN_ID_FK

 

MD_CONSTRAINTS_MD_TABLES_FK1

General Info

Caption MD_CONSTRAINTS_MD_TABLES_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_TABLES
Child Entity MIGRATION_WORKBENCH.MD_CONSTRAINTS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_TABLES_PK' ID TABLE_ID_FK

 

MD_DERIVATIVES_MD_CONNECT_FK1

General Info

Caption MD_DERIVATIVES_MD_CONNECT_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_DERIVATIVES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID DERIVED_CONNECTION_ID_FK

 

MD_FILE_APP_FK

General Info

Caption MD_FILE_APP_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_APPLICATIONS
Child Entity MIGRATION_WORKBENCH.MD_APPLICATIONFILES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_APPLICATIONS_PK' ID APPLICATIONS_ID_FK

 

MD_GROUP_PRIVILEGES_MD_GR_FK1

General Info

Caption MD_GROUP_PRIVILEGES_MD_GR_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_GROUPS
Child Entity MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_GROUPS_PK' ID GROUP_ID_FK

 

MD_GROUP_PRIVILEGES_MD_PR_FK1

General Info

Caption MD_GROUP_PRIVILEGES_MD_PR_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_PRIVILEGES
Child Entity MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_PRIVILEGES_PK' ID PRIVILEGE_ID_FK

 

MD_GROUPMEMBERS_MD_GROUPS_FK1

General Info

Caption MD_GROUPMEMBERS_MD_GROUPS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_GROUPS
Child Entity MIGRATION_WORKBENCH.MD_GROUP_MEMBERS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_GROUPS_PK' ID GROUP_ID_FK

 

MD_GROUPMEMBERS_MD_GROUPS_FK2

General Info

Caption MD_GROUPMEMBERS_MD_GROUPS_FK2
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_GROUPS
Child Entity MIGRATION_WORKBENCH.MD_GROUP_MEMBERS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_GROUPS_PK' ID GROUP_MEMBER_ID_FK

 

MD_GROUPMEMBERS_MD_USERS_FK1

General Info

Caption MD_GROUPMEMBERS_MD_USERS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_USERS
Child Entity MIGRATION_WORKBENCH.MD_GROUP_MEMBERS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_USERS_PK' ID USER_ID_FK

 

MD_GROUPS_MD_SCHEMAS_FK1

General Info

Caption MD_GROUPS_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_GROUPS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_INDEX_DETAILS_MD_COLUM_FK1

General Info

Caption MD_INDEX_DETAILS_MD_COLUM_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_COLUMNS
Child Entity MIGRATION_WORKBENCH.MD_INDEX_DETAILS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_COLUMNS_PK' ID COLUMN_ID_FK

 

MD_INDEX_DETAILS_MD_INDEX_FK1

General Info

Caption MD_INDEX_DETAILS_MD_INDEX_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_INDEXES
Child Entity MIGRATION_WORKBENCH.MD_INDEX_DETAILS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_INDEXES_PK' ID INDEX_ID_FK

 

MD_INDEXES_MD_TABLES_FK1

General Info

Caption MD_INDEXES_MD_TABLES_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_TABLES
Child Entity MIGRATION_WORKBENCH.MD_INDEXES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_TABLES_PK' ID TABLE_ID_FK

 

MD_OTHER_OBJECTS_MD_SCHEM_FK1

General Info

Caption MD_OTHER_OBJECTS_MD_SCHEM_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_OTHER_OBJECTS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_PACKAGES_MD_SCHEMAS_FK1

General Info

Caption MD_PACKAGES_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_PACKAGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_PRIVILEGES_MD_SCHEMAS_FK1

General Info

Caption MD_PRIVILEGES_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_PRIVILEGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_SCHEMAS_MD_CATALOGS_FK1

General Info

Caption MD_SCHEMAS_MD_CATALOGS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CATALOGS
Child Entity MIGRATION_WORKBENCH.MD_SCHEMAS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CATALOGS_PK' ID CATALOG_ID_FK

 

MD_SEQUENCES_MD_SCHEMAS_FK1

General Info

Caption MD_SEQUENCES_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_SEQUENCES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_STORED_PROGRAMS_MD_PAC_FK1

General Info

Caption MD_STORED_PROGRAMS_MD_PAC_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_PACKAGES
Child Entity MIGRATION_WORKBENCH.MD_STORED_PROGRAMS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_PACKAGES_PK' ID PACKAGE_ID_FK

 

MD_STORED_PROGRAMS_MD_SCH_FK1

General Info

Caption MD_STORED_PROGRAMS_MD_SCH_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_STORED_PROGRAMS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_SYNONYMS_MD_SCHEMAS_FK1

General Info

Caption MD_SYNONYMS_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_SYNONYMS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_TABLES_MD_SCHEMAS_FK1

General Info

Caption MD_TABLES_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_TABLES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_TABLESPACES_MD_SCHEMAS_FK1

General Info

Caption MD_TABLESPACES_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_TABLESPACES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_USER_DEFINED_DATA_TYPE_FK1

General Info

Caption MD_USER_DEFINED_DATA_TYPE_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_USER_PRIVILEGES_MD_PRI_FK1

General Info

Caption MD_USER_PRIVILEGES_MD_PRI_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_PRIVILEGES
Child Entity MIGRATION_WORKBENCH.MD_USER_PRIVILEGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_PRIVILEGES_PK' ID PRIVILEGE_ID_FK

 

MD_USER_PRIVILEGES_MD_USE_FK1

General Info

Caption MD_USER_PRIVILEGES_MD_USE_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_USERS
Child Entity MIGRATION_WORKBENCH.MD_USER_PRIVILEGES

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_USERS_PK' ID USER_ID_FK

 

MD_USERS_MD_SCHEMAS_FK1

General Info

Caption MD_USERS_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_USERS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MD_VIEWS_MD_SCHEMAS_FK1

General Info

Caption MD_VIEWS_MD_SCHEMAS_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_VIEWS

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK

 

MIGR_DATATYPE_TRANSFORM_M_FK1

General Info

Caption MIGR_DATATYPE_TRANSFORM_M_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_PROJECTS
Child Entity MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_PROJECTS_PK' ID PROJECT_ID_FK

 

MIGR_DATATYPE_TRANSFORM_R_FK1

General Info

Caption MIGR_DATATYPE_TRANSFORM_R_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Child Entity MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MIGR_DATATYPE_TRANSFORM_M_PK' ID MAP_ID_FK

 

MIGR_DEPENDENCY_FK

General Info

Caption MIGR_DEPENDENCY_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MIGR_GENERATION_ORDER_MD__FK1

General Info

Caption MIGR_GENERATION_ORDER_MD__FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MIGR_MIGRLOG_FK

General Info

Caption MIGR_MIGRLOG_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent NO
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MIGRLOG
Child Entity MIGRATION_WORKBENCH.MIGRLOG

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MIGRLOG_PK' ID PARENT_LOG_ID

 

MIGR_PARAMETER_FK

General Info

Caption MIGR_PARAMETER_FK
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_MIGR_PARAMETER

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MIGR_WEAKDEP_FK1

General Info

Caption MIGR_WEAKDEP_FK1
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_CONNECTIONS
Child Entity MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_CONNECTIONS_PK' ID CONNECTION_ID_FK

 

MIGR_WEAKDEP_FK2

General Info

Caption MIGR_WEAKDEP_FK2
Relationship Type Non-identifying Cardinality 1:N
Mandatory Parent YES
Mandatory Child NO
Parent Entity MIGRATION_WORKBENCH.MD_SCHEMAS
Child Entity MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP

Referential Integrity

Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

Keys

Key Type Parent Key Child Key
Primary Key 'MD_SCHEMAS_PK' ID SCHEMA_ID_FK