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 |