MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES

General Info

Caption MD_ADDITIONAL_PROPERTIES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK CONNECTION_ID_FK Number YES NO NO Connection to which this belongs //PARENTFIELD
REF_ID_FK Number YES NO NO The object to which this property blongs
REF_TYPE Varchar2(4000 ) YES NO NO Type of object that this property belongs to
PROPERTY_ORDER Number NO NO NO This is to handle a situation where multiple properties have a relevant order, or multiple properties have multiple values
PROP_KEY Varchar2(4000 ) YES NO NO The keyname for this property
VALUE Varchar2(4000 ) NO NO NO The value for this property
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_ADDITIONAL_PROPERTIES__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_ADDITIONAL_PROPERTIES_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MD_ADDITIONAL_PROPERTIES_IDX PROP_KEY NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTY_TRG

Comments

This table is used to store additional properties in key-value pairs. It is designed to store "other information" that is not supported in the main database object table.

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES

General Info

Caption MD_APPLICATIONFILES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK APPLICATIONS_ID_FK Number YES NO NO
NAME Varchar2(200 ) YES NO NO file name //OBJECTNAME
URI Varchar2(4000 ) YES NO NO The uri is the part of the file url after the base dir has been removed. See MD_APPLICATION for base dir
TYPE Varchar2(100 ) YES NO NO This will denote the type of file we have, including DIR, FILE (text), BINARY, IGNORE (where we choose to ignore files)
STATE Varchar2(100 ) YES NO NO State will be how this file is operated on. For example. it will be OPEN, NEW, FIXED, IGNORED, REVIEWED, COMPLETE
LANGUAGE Varchar2(100 ) NO NO NO Language of the file that has been processed.
SECURITY_GROUP_ID Number YES NO NO 0 APEX
CREATED_ON Date YES NO NO sysdate APEX
CREATED_BY Varchar2(4000 ) NO NO NO APEX
UPDATED_ON Date NO NO NO APEX
UPDATED_BY Varchar2(4000 ) NO NO NO APEX

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_ARTIFACT_FILE_FK Non-identifying MIGRATION_WORKBENCH.MD_APPLICATIONFILES MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS 1:N
MD_FILE_APP_FK Non-identifying MIGRATION_WORKBENCH.MD_APPLICATIONS MIGRATION_WORKBENCH.MD_APPLICATIONFILES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_APPLICATIONFILES_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MD_APP_FILE_TYPE_IDX TYPE, ID NO
MD_STATE_TYPE__ID STATE, TYPE, ID NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.INS_APPLICATIONFILE_TRG

Comments

Holds a tuple for each file that is being processed whether it is changed or not.

 

MIGRATION_WORKBENCH.MD_APPLICATIONS

General Info

Caption MD_APPLICATIONS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
NAME Varchar2(4000 ) NO NO NO Name of the application suite //OBJECTNAME
DESCRIPTION Varchar2(4000 ) NO NO NO Overview of what the application does.
BASE_DIR Varchar2(4000 ) NO NO NO This is the base src directory for the application. It could be an svn checkout, a clearcase view or something similar
OUTPUT_DIR Varchar2(4000 ) NO NO NO This is the output directory where the scanner will present the converted files, if there are converted or modified.
BACKUP_DIR Varchar2(4000 ) NO NO NO This is the directory in which the application files are backed up if a backp is chosen
INPLACE Number NO NO NO Designates whether the changes have been made inplace, in the source directory or not
FK CONNECTION_ID_FK Number YES NO NO captured model of the database(s) this application relates to
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_APP_CONN_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_APPLICATIONS 1:N
MD_FILE_APP_FK Non-identifying MIGRATION_WORKBENCH.MD_APPLICATIONS MIGRATION_WORKBENCH.MD_APPLICATIONFILES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_APPLICATIONS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.INS_APPLICATION_TRG

Comments

This is the base table for application projects. It holds the base information for applications associated with a database

 

MIGRATION_WORKBENCH.MD_CATALOGS

General Info

Caption MD_CATALOGS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK CONNECTION_ID_FK Number YES NO NO Foreign key into the connections table - Shows what connection this catalog belongs to //PARENTFIELD
CATALOG_NAME Varchar2(4000 ) NO NO NO Name of the catalog //OBJECTNAME
DUMMY_FLAG Char(1 ) NO NO NO 'N' Flag to show if this catalog is a "dummy" catalog which is used as a placeholder for those platforms that do not support catalogs. 'N' signifies that this is NOT a dummy catalog, while 'Y' signifies that it is.
NATIVE_SQL Clob NO NO NO THe SQL used to create this catalog
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique identifier used to identify the catalog at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_CATALOGS_MD_CONNECTION_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_CATALOGS 1:N
MD_SCHEMAS_MD_CATALOGS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CATALOGS MIGRATION_WORKBENCH.MD_SCHEMAS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_CATALOGS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_CATALOGS_TRG

Comments

Store catalogs in this table.

 

MIGRATION_WORKBENCH.MD_COLUMNS

General Info

Caption MD_COLUMNS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK TABLE_ID_FK Number YES NO NO The table that this column is part of //PARENTFIELD
COLUMN_NAME Varchar2(4000 ) YES NO NO The name of the column //OBJECTNAME
COLUMN_ORDER Number YES NO NO The order this appears in the table
COLUMN_TYPE Varchar2(4000 ) NO NO NO The type of the column
PRECISION Number NO NO NO The precision on the column
SCALE Number NO NO NO The scale of the column
NULLABLE Char(1 ) NO NO NO Yes or No. Null signifies NO
DEFAULT_VALUE Varchar2(4000 ) NO NO NO Default value on the column
NATIVE_SQL Clob NO NO NO The SQL used to create this column at source
NATIVE_KEY Varchar2(4000 ) NO NO NO Unique identifier for this object at source
DATATYPE_TRANSFORMED_FLAG Char(1 ) NO NO NO This is set to 'Y' to show if the data type was transformed. This is useful so we don't apply more than 1 datatype transformation to a column
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_BY Varchar2(255 ) NO NO NO
CREATED_ON Date YES NO NO sysdate
LAST_UPDATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_COLUMNS_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_COLUMNS 1:N
MD_CONSTRAINT_DETAILS_MD__FK2 Non-identifying MIGRATION_WORKBENCH.MD_COLUMNS MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS 1:N
MD_INDEX_DETAILS_MD_COLUM_FK1 Non-identifying MIGRATION_WORKBENCH.MD_COLUMNS MIGRATION_WORKBENCH.MD_INDEX_DETAILS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_COLUMNS_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MD_COLUMNS_PERF_IDX "TABLE_ID_FK",UPPER(TRIM("COLUMN_NAME")),"ID" NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_COLUMNS_TRG

Comments

Column information is stored in this table.

 

MIGRATION_WORKBENCH.MD_CONNECTIONS

General Info

Caption MD_CONNECTIONS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary key
FK PROJECT_ID_FK Number YES NO NO The project to which this connection belongs //PARENTFIELD
TYPE Varchar2(4000 ) NO NO NO The type of the connection - For example it could be used to store "ORACLE" or "MYSQL"
HOST Varchar2(4000 ) NO NO NO The host to which this connection connects.
PORT Number NO NO NO The port to which this connection connects
USERNAME Varchar2(4000 ) NO NO NO The username used to make the connection
PASSWORD Varchar2(4000 ) NO NO NO The password used to make this connection
DBURL Varchar2(4000 ) NO NO NO The database url used to make this connection
NAME Varchar2(255 ) NO NO NO //OBJECTNAME
NATIVE_SQL Clob NO NO NO The native sql used to create this connection
STATUS Varchar2(30 ) NO NO NO Status of Migration, = captured,converted,generated,datamoved
NUM_CATALOGS Number NO NO NO
NUM_COLUMNS Number NO NO NO
NUM_CONSTRAINTS Number NO NO NO
NUM_GROUPS Number NO NO NO
NUM_ROLES Number NO NO NO
NUM_INDEXES Number NO NO NO
NUM_OTHER_OBJECTS Number NO NO NO
NUM_PACKAGES Number NO NO NO
NUM_PRIVILEGES Number NO NO NO
NUM_SCHEMAS Number NO NO NO
NUM_SEQUENCES Number NO NO NO
NUM_STORED_PROGRAMS Number NO NO NO
NUM_SYNONYMS Number NO NO NO
NUM_TABLES Number NO NO NO
NUM_TABLESPACES Number NO NO NO
NUM_TRIGGERS Number NO NO NO
NUM_USER_DEFINED_DATA_TYPES Number NO NO NO
NUM_USERS Number NO NO NO
NUM_VIEWS Number NO NO NO
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_ADDITIONAL_PROPERTIES__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES 1:N
MD_APP_CONN_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_APPLICATIONS 1:N
MD_CATALOGS_MD_CONNECTION_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_CATALOGS 1:N
MD_CONNECTIONS_MD_PROJECT_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PROJECTS MIGRATION_WORKBENCH.MD_CONNECTIONS 1:N
MD_DERIVATIVES_MD_CONNECT_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_DERIVATIVES 1:N
MIGR_DEPENDENCY_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY 1:N
MIGR_GENERATION_ORDER_MD__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER 1:N
MIGR_PARAMETER_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_PARAMETER 1:N
MIGR_WEAKDEP_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP 1:N

Keys

Key Type Constraint Name Attributes
PK MD_CONNECTIONS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_CONNECTIONS_TRG

Comments

This table is used to store connection information. For example, in migrations, we could be carrying out a consolidation which occurs across many connections.

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS

General Info

Caption MD_CONSTRAINT_DETAILS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
REF_FLAG Char(1 ) NO NO NO 'N' "N" or Null signify that this column is the colum that is used in the constraint. A flag of Y signifies that the colum is a referenced column (i.e. part of a foreign key constraint)
FK CONSTRAINT_ID_FK Number YES NO NO Constraint that this detail belongs to //PARENTFIELD
FK COLUMN_ID_FK Number NO NO NO
COLUMN_PORTION Number NO NO NO The portion of a column this detail belongs (e.g. for constrints on substrings)
CONSTRAINT_TEXT Clob NO NO NO The text of the constraint
DETAIL_ORDER Number YES NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_CONSTRAINT_DETAILS_MD__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONSTRAINTS MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS 1:N
MD_CONSTRAINT_DETAILS_MD__FK2 Non-identifying MIGRATION_WORKBENCH.MD_COLUMNS MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_CONSTRAINT_DETAILS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS_TRG

Comments

Constraint details show what columns are "involved" in a constraint.

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS

General Info

Caption MD_CONSTRAINTS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
DELETE_CLAUSE Varchar2(4000 ) NO NO NO delete option , can be either CASCADE, RESTRICT or NULL
NAME Varchar2(4000 ) NO NO NO Name of the constraint //OBJECTNAME
CONSTRAINT_TYPE Varchar2(4000 ) NO NO NO Type of the constraint (e.g. CHECK)
FK TABLE_ID_FK Number YES NO NO Table on which this constraint exists //PARENTFIELD
REFTABLE_ID_FK Number NO NO NO Used in foreign keys - this gives the table that we refer to.
CONSTRAINT_TEXT Clob NO NO NO The text of the constraint
LANGUAGE Varchar2(40 ) YES NO NO //PUBLIC
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_CONSTRAINTS_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_CONSTRAINTS 1:N
MD_CONSTRAINT_DETAILS_MD__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONSTRAINTS MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_CONSTRAINTS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_CONSTRAINTS_TRG

Comments

Table for storing information about a constraint

 

MIGRATION_WORKBENCH.MD_DERIVATIVES

General Info

Caption MD_DERIVATIVES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
SRC_ID Number YES NO NO
SRC_TYPE Varchar2(4000 ) NO NO NO
DERIVED_ID Number YES NO NO
DERIVED_TYPE Varchar2(4000 ) NO NO NO
FK DERIVED_CONNECTION_ID_FK Number YES NO NO
TRANSFORMED Char(1 ) NO NO NO Set this field to 'Y' if we carry out any sort of transformation on teh derived object.
ORIGINAL_IDENTIFIER Varchar2(4000 ) NO NO NO
NEW_IDENTIFIER Varchar2(4000 ) NO NO NO
DERIVED_OBJECT_NAMESPACE Varchar2(40 ) NO NO NO
DERIVATIVE_REASON Varchar2(10 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_DERIVATIVES_MD_CONNECT_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_DERIVATIVES 1:N

Keys

Key Type Constraint Name Attributes
PK MIGRDREIVATIVES_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MD_DERIVATIVES_PERF_IDX SRC_ID, DERIVED_CONNECTION_ID_FK NO
MD_DERIVATIVES_PERF_IDX1 SRC_TYPE, DERIVATIVE_REASON NO
MD_DERIVATIVES_PERF_IDX2 NEW_IDENTIFIER NO
MD_DERIVATIVES_PERF_IDX3 ORIGINAL_IDENTIFIER NO
MD_DERIVATIVES_PERF_IDX4 DERIVED_ID, DERIVED_TYPE, DERIVED_CONNECTION_ID_FK NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_DERIVATIVES_TRG

Comments

This table is used to store objects that are derived from each other. For example in a migration an auto-increment column in a source model could be mapped to a primary key, and a sequence, and a trigger. The MD_DERIVATIVES table would store the fact that these 3 objects are derived from the auto-increment column.

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS

General Info

Caption MD_FILE_ARTIFACTS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK APPLICATIONFILES_ID Number YES NO NO
PATTERN Varchar2(4000 ) NO NO NO Pattern used to search source file for interesting artifiacts
STRING_FOUND Varchar2(4000 ) NO NO NO String found in source from the pattern supplied
STRING_REPLACED Varchar2(4000 ) NO NO NO This is the string which replace the string found if it was replaced.
TYPE Varchar2(200 ) NO NO NO This is the type of the replacement. It could be a straight replace from a replacement pattern, or we could have passed the string to a translator which would change the string depending on the database.
STATUS Varchar2(4000 ) NO NO NO Pattern used to search source file for interesting artifiacts
LINE Number NO NO NO
PATTERN_START Number NO NO NO
PATTERN_END Number NO NO NO
DUE_DATE Date NO NO NO Due date is used by the TODO mechanism to manage the validation and work to complete this change
DB_TYPE Varchar2(100 ) NO NO NO Source database calls type
CODE_TYPE Varchar2(1000 ) NO NO NO Source code db api, like dblib, jdbc
DESCRIPTION Varchar2(4000 ) NO NO NO This is a description of the artifact which will have a default generated by the scanner and then can be modified by the user to be more appropriate for their use
PRIORITY Integer NO NO NO The priority is set for the TODOs so they can be managed by the user
SECURITY_GROUP_ID Varchar2(20 ) YES NO NO '0'
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(4000 ) NO NO NO
LAST_UPDATED Date NO NO NO
LAST_UPDATED_BY Varchar2(4000 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_ARTIFACT_FILE_FK Non-identifying MIGRATION_WORKBENCH.MD_APPLICATIONFILES MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_FILE_ARTIFACTS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.INS_FILE_ARTIFACT_TRG

Comments

Holds a tuple for each interesting thing the scanner finds in a file

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS

General Info

Caption MD_GROUP_MEMBERS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK GROUP_ID_FK Number YES NO NO
FK USER_ID_FK Number NO NO NO Id of member
FK GROUP_MEMBER_ID_FK Number NO NO NO groups can be members of groups
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUPMEMBERS_MD_GROUPS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N
MD_GROUPMEMBERS_MD_GROUPS_FK2 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N
MD_GROUPMEMBERS_MD_USERS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_USERS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_GROUP_MEMBERS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_GROUP_MEMBERS_TRG

Comments

This table is used to store the members of a group.

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES

General Info

Caption MD_GROUP_PRIVILEGES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
PK ID Number YES NO NO
FK GROUP_ID_FK Number YES NO NO
FK PRIVILEGE_ID_FK Number YES NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUP_PRIVILEGES_MD_GR_FK1 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES 1:N
MD_GROUP_PRIVILEGES_MD_PR_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PRIVILEGES MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_GROUP_PRIVILEGES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES_TRG

Comments

This table stores the privileges granted to a group (or role)

 

MIGRATION_WORKBENCH.MD_GROUPS

General Info

Caption MD_GROUPS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema in which this object belongs //PARENTFIELD
GROUP_NAME Varchar2(4000 ) NO NO NO Name of the group //OBJECTNAME
GROUP_FLAG Char(1 ) NO NO NO This is a flag to signify a group or a role. If this is 'R' it means the group is known as a Role. Any other value means it is known as a group.
NATIVE_SQL Clob NO NO NO SQL Used to generate this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO Unique id for this object at source
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUPMEMBERS_MD_GROUPS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N
MD_GROUPMEMBERS_MD_GROUPS_FK2 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N
MD_GROUPS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_GROUPS 1:N
MD_GROUP_PRIVILEGES_MD_GR_FK1 Non-identifying MIGRATION_WORKBENCH.MD_GROUPS MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_GROUPS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_GROUPS_TRG

Comments

Groups of users in a schema

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS

General Info

Caption MD_INDEX_DETAILS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK INDEX_ID_FK Number YES NO NO The index to which this detail belongs. //PARENTFIELD
FK COLUMN_ID_FK Number YES NO NO
INDEX_PORTION Number NO NO NO To support indexing on part of a field
DETAIL_ORDER Number YES NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_INDEX_DETAILS_MD_COLUM_FK1 Non-identifying MIGRATION_WORKBENCH.MD_COLUMNS MIGRATION_WORKBENCH.MD_INDEX_DETAILS 1:N
MD_INDEX_DETAILS_MD_INDEX_FK1 Non-identifying MIGRATION_WORKBENCH.MD_INDEXES MIGRATION_WORKBENCH.MD_INDEX_DETAILS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_INDEX_DETAILS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_INDEX_DETAILS_TRG

Comments

This table stores the details of an index. It shows what columns are "part" of the index.

 

MIGRATION_WORKBENCH.MD_INDEXES

General Info

Caption MD_INDEXES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
INDEX_TYPE Varchar2(4000 ) NO NO NO Type of the index e.g. PRIMARY
FK TABLE_ID_FK Number YES NO NO Table that this index is on //PARENTFIELD
INDEX_NAME Varchar2(4000 ) NO NO NO Name of the index //OBJECTNAME
NATIVE_SQL Clob NO NO NO SQL used to create the index at source
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique identifier for this object at the source
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(4000 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_INDEXES_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_INDEXES 1:N
MD_INDEX_DETAILS_MD_INDEX_FK1 Non-identifying MIGRATION_WORKBENCH.MD_INDEXES MIGRATION_WORKBENCH.MD_INDEX_DETAILS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_INDEXES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_INDEXES_TRG

Comments

This table is used to store information about the indexes in a schema

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY

General Info

Caption MD_MIGR_DEPENDENCY

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK CONNECTION_ID_FK Number YES NO NO The connection that this exists in //PARENTFIELD
PARENT_ID Number YES NO NO
CHILD_ID Number YES NO NO
PARENT_OBJECT_TYPE Varchar2(4000 ) YES NO NO
CHILD_OBJECT_TYPE Varchar2(4000 ) YES NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_DEPENDENCY_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_DEPENDENCY_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY_TRG

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER

General Info

Caption MD_MIGR_PARAMETER

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK CONNECTION_ID_FK Number YES NO NO the connection in which this belongs //PARENTFIELD
OBJECT_ID Number YES NO NO
OBJECT_TYPE Varchar2(4000 ) YES NO NO
PARAM_EXISTING Number YES NO NO 1 represents a new parameter for PL/SQL that was not present in the origional. 0 represents a n existing parameter that was present in the origional
PARAM_ORDER Number YES NO NO IF -1 THEN THIS PARAM IS A RETURN PARAMETER. 1 WILL BE THE FIRST PARAMETER IN THE PARAMETER LIST
PARAM_NAME Varchar2(4000 ) YES NO NO
PARAM_TYPE Varchar2(4000 ) YES NO NO
PARAM_DATA_TYPE Varchar2(4000 ) YES NO NO
PERCISION Number NO NO NO
SCALE Number NO NO NO
NULLABLE Char(1 ) YES NO NO
DEFAULT_VALUE Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_PARAMETER_FK Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_PARAMETER 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_PARAMETER_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_MIGR_PARAMETER_TRG

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP

General Info

Caption MD_MIGR_WEAKDEP

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK CONNECTION_ID_FK Number YES NO NO
FK SCHEMA_ID_FK Number YES NO NO
PARENT_ID Number YES NO NO
CHILD_NAME Varchar2(4000 ) YES NO NO name of the child, as weak dependencies dont have reference to child id
PARENT_TYPE Varchar2(4000 ) YES NO NO MD_<tablename>
CHILD_TYPE Varchar2(4000 ) YES NO NO Generic Type (not MD_<tablename>)
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_WEAKDEP_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP 1:N
MIGR_WEAKDEP_FK2 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_WEAKDEP_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP_TRG

 

MIGRATION_WORKBENCH.MD_NUMROW$SOURCE

General Info

Caption MD_NUMROW$SOURCE

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
NUMROWS Number(10,0) NO NO NO
NAME Varchar2(4000 ) NO NO NO
OBJID Number(10,0) NO NO NO

 

MIGRATION_WORKBENCH.MD_NUMROW$TARGET

General Info

Caption MD_NUMROW$TARGET

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
NUMROWS Number(10,0) NO NO NO
NAME Varchar2(4000 ) NO NO NO
OBJID Number(10,0) NO NO NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS

General Info

Caption MD_OTHER_OBJECTS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema to which this object blongs. //PARENTFIELD
NAME Varchar2(4000 ) NO NO NO Name of this object //OBJECTNAME
NATIVE_SQL Clob NO NO NO The native SQL used to create this object
NATIVE_KEY Varchar2(4000 ) NO NO NO A key that identifies this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_OTHER_OBJECTS_MD_SCHEM_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_OTHER_OBJECTS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_OTHER_OBJECTS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_OTHER_OBJECTS_TRG

Comments

For storing objects that don''t belong anywhere else

 

MIGRATION_WORKBENCH.MD_PACKAGES

General Info

Caption MD_PACKAGES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO the schema in which this package resides //PARENTFIELD
NAME Varchar2(4000 ) YES NO NO Name of this package //OBJECTNAME
PACKAGE_HEADER Clob NO NO NO
NATIVE_SQL Clob NO NO NO The SQL used to create this package at source
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique identifer for this object at source.
LANGUAGE Varchar2(40 ) YES NO NO //PUBLIC
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_PACKAGES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_PACKAGES 1:N
MD_STORED_PROGRAMS_MD_PAC_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PACKAGES MIGRATION_WORKBENCH.MD_STORED_PROGRAMS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_PACKAGES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_PACKAGES_TRG

Comments

For storing packages

 

MIGRATION_WORKBENCH.MD_PRIVILEGES

General Info

Caption MD_PRIVILEGES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO The schema to which this object belongs //PARENTFIELD
PRIVILEGE_NAME Varchar2(4000 ) YES NO NO The name of the privilege //OBJECTNAME
PRIVELEGE_OBJECT_ID Number NO NO NO This references the table, view, etc on which the privelege exists. This can be NULL for things like system wide privileges
PRIVELEGEOBJECTTYPE Varchar2(4000 ) YES NO NO The type the privelege is on (e.g. INDEX)
PRIVELEGE_TYPE Varchar2(4000 ) YES NO NO e.g.select
ADMIN_OPTION Char(1 ) NO NO NO Flag to show if this was granted with admin option. 'Y' means it was granted with admin option 'N' means it was NOT granted with admin option. NULL means not applicable (e.g. not known, not supported by source platform, etc.)
NATIVE_SQL Clob YES NO NO The SQL used to create this privilege at source
NATIVE_KEY Varchar2(4000 ) NO NO NO An identifier for this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUP_PRIVILEGES_MD_PR_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PRIVILEGES MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES 1:N
MD_PRIVILEGES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_PRIVILEGES 1:N
MD_USER_PRIVILEGES_MD_PRI_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PRIVILEGES MIGRATION_WORKBENCH.MD_USER_PRIVILEGES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_PRIVILEGES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_PRIVILEGES_TRG

Comments

This table stores privilege information

 

MIGRATION_WORKBENCH.MD_PROJECTS

General Info

Caption MD_PROJECTS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary key
PROJECT_NAME Varchar2(4000 ) YES NO NO Name of the project //OBJECTNAME
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_CONNECTIONS_MD_PROJECT_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PROJECTS MIGRATION_WORKBENCH.MD_CONNECTIONS 1:N
MIGR_DATATYPE_TRANSFORM_M_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PROJECTS MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP 1:N

Keys

Key Type Constraint Name Attributes
PK MD_PROJECTS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_PROJECTS_TRG

Comments

This is a top level container for a set of connections.

 

MIGRATION_WORKBENCH.MD_REGISTRY

General Info

Caption MD_REGISTRY

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
PK OBJECT_TYPE Varchar2(30 ) YES NO NO
PK OBJECT_NAME Varchar2(30 ) YES NO NO
DESC_OBJECT_NAME Varchar2(30 ) NO NO NO

Keys

Key Type Constraint Name Attributes
PK MD_REGISTRY_PK OBJECT_TYPE, OBJECT_NAME

Comments

Table to store information on the MD_ repository. This lists the objects to be dropped if you wish to remove the repository

 

MIGRATION_WORKBENCH.MD_REPOVERSIONS

General Info

Caption MD_REPOVERSIONS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
REVISION Number YES NO NO

Comments

This table is used to version this schema for future requirements.

 

MIGRATION_WORKBENCH.MD_SCHEMAS

General Info

Caption MD_SCHEMAS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK CATALOG_ID_FK Number YES NO NO Catalog to which this schema blongs //PARENTFIELD
NAME Varchar2(4000 ) NO NO NO Name of the schema //OBJECTNAME
TYPE Char(1 ) NO NO NO Type of this schema. Eaxamples are 'CAPTURED' OR 'CONVERTED'
CHARACTER_SET Varchar2(4000 ) NO NO NO The characterset of this schema
VERSION_TAG Varchar2(40 ) NO NO NO A version string that can be used for tagging/baseling a schema
NATIVE_SQL Clob NO NO NO The native SQL used to create this schema
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique identifier that this schema is known as in its source state.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUPS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_GROUPS 1:N
MD_OTHER_OBJECTS_MD_SCHEM_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_OTHER_OBJECTS 1:N
MD_PACKAGES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_PACKAGES 1:N
MD_PRIVILEGES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_PRIVILEGES 1:N
MD_SCHEMAS_MD_CATALOGS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_CATALOGS MIGRATION_WORKBENCH.MD_SCHEMAS 1:N
MD_SEQUENCES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_SEQUENCES 1:N
MD_STORED_PROGRAMS_MD_SCH_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_STORED_PROGRAMS 1:N
MD_SYNONYMS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_SYNONYMS 1:N
MD_TABLESPACES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_TABLESPACES 1:N
MD_TABLES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_TABLES 1:N
MD_USERS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_USERS 1:N
MD_USER_DEFINED_DATA_TYPE_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES 1:N
MD_VIEWS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_VIEWS 1:N
MIGR_WEAKDEP_FK2 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP 1:N

Keys

Key Type Constraint Name Attributes
PK MD_SCHEMAS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_SCHEMAS_TRG

Comments

This is the holder for schemas

 

MIGRATION_WORKBENCH.MD_SEQUENCES

General Info

Caption MD_SEQUENCES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO The schema to which this object belongs. //PARENTFIELD
NAME Varchar2(4000 ) YES NO NO Name of this sequence //OBJECTNAME
SEQ_START Number YES NO NO Starting point of the sequence
INCR Number YES NO NO 1 Increment value of the sequence
NATIVE_SQL Clob NO NO NO SQL used to create this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO Identifier for this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) YES NO NO '0'
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_SEQUENCES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_SEQUENCES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_SEQUENCES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_SEQUENCES_TRG

Comments

For storing information on sequences.

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS

General Info

Caption MD_STORED_PROGRAMS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema to which this object belongs. Note that the PACKAGE_ID_FK (if present also leads us to the relevant schema), however a stored program may or may not belong in a package. If it is in a package, then the SCHEMA_ID_FK and the SCHEME_ID_FK in the parent package should match //PARENTFIELD
PROGRAMTYPE Varchar2(20 ) NO NO NO Java/TSQL/PLSQL, etc.
NAME Varchar2(4000 ) NO NO NO Name of the stored program //OBJECTNAME
FK PACKAGE_ID_FK Number NO NO NO The package to which this object belongs
NATIVE_SQL Clob NO NO NO The SQL used to create this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique indetifier for this object at source
LANGUAGE Varchar2(40 ) YES NO NO //PUBLIC
COMMENTS Varchar2(4000 ) NO NO NO
LINECOUNT Number NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_STORED_PROGRAMS_MD_PAC_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PACKAGES MIGRATION_WORKBENCH.MD_STORED_PROGRAMS 1:N
MD_STORED_PROGRAMS_MD_SCH_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_STORED_PROGRAMS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_STORED_PROGRAMS_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MD_STORED_PROGRAS_IDX2 "SCHEMA_ID_FK",UPPER("NAME") NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_STORED_PROGRAMS_TRG

Comments

Container for stored programs.

 

MIGRATION_WORKBENCH.MD_SYNONYMS

General Info

Caption MD_SYNONYMS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO The schema to which this object belongs //PARENTFIELD
NAME Varchar2(4000 ) YES NO NO Synonym name //OBJECTNAME
SYNONYM_FOR_ID Number YES NO NO What object this is a synonym for
FOR_OBJECT_TYPE Varchar2(4000 ) YES NO NO The type this is a synonym for (e.g. INDEX)
PRIVATE_VISIBILITY Char(1 ) NO NO NO Visibility - Private or Public. If Private_visibility = 'Y' means this is a private synonym. Anything else means it is a public synonym
NATIVE_SQL Clob NO NO NO The SQL used to create this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO An identifier for this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_SYNONYMS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_SYNONYMS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_SYNONYMS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_SYNONYMS_TRG

Comments

For storing synonym information.

 

MIGRATION_WORKBENCH.MD_TABLES

General Info

Caption MD_TABLES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema in which this table resides //PARENTFIELD
TABLE_NAME Varchar2(4000 ) YES NO NO Name of the table //OBJECTNAME
NATIVE_SQL Clob NO NO NO SQL Used to create this table at soruce
NATIVE_KEY Varchar2(4000 ) NO NO NO Unique identifier for this table at source
QUALIFIED_NATIVE_NAME Varchar2(4000 ) YES NO NO
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_COLUMNS_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_COLUMNS 1:N
MD_CONSTRAINTS_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_CONSTRAINTS 1:N
MD_INDEXES_MD_TABLES_FK1 Non-identifying MIGRATION_WORKBENCH.MD_TABLES MIGRATION_WORKBENCH.MD_INDEXES 1:N
MD_TABLES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_TABLES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_TABLES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_TABLES_TRG
MIGRATION_WORKBENCH.DEL_MD_TRIGGERS_T_TRG

Comments

Table used to store information about tables.

 

MIGRATION_WORKBENCH.MD_TABLESPACES

General Info

Caption MD_TABLESPACES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema to which this tablespace belongs //PARENTFIELD
TABLESPACE_NAME Varchar2(4000 ) NO NO NO Name of the table space //OBJECTNAME
NATIVE_SQL Clob NO NO NO The SQL used to create this tablespace
NATIVE_KEY Varchar2(4000 ) NO NO NO A unique identifier for this object at source
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_TABLESPACES_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_TABLESPACES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_TABLESPACES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_TABLESPACES_TRG

Comments

For storing information about tablespaces.

 

MIGRATION_WORKBENCH.MD_TRIGGERS

General Info

Caption MD_TRIGGERS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
TABLE_OR_VIEW_ID_FK Number YES NO NO Table on which this trigger fires
TRIGGER_ON_FLAG Char(1 ) YES NO NO Flag to show iif the trigger is on a table or a view. If it is a table this should be 'T'. If it is on a view this should be 'V'
TRIGGER_NAME Varchar2(4000 ) NO NO NO Name of the trigger //OBJECTNAME
TRIGGER_TIMING Varchar2(4000 ) NO NO NO before, after ,etc.
TRIGGER_OPERATION Varchar2(4000 ) NO NO NO insert, delete, etc.
TRIGGER_EVENT Varchar2(4000 ) NO NO NO The actual trigger that gets fired
NATIVE_SQL Clob NO NO NO The full definition
NATIVE_KEY Varchar2(4000 ) NO NO NO UInique identifer for this object at source
LANGUAGE Varchar2(40 ) YES NO NO //PUBLIC
COMMENTS Varchar2(4000 ) NO NO NO
LINECOUNT Number NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Keys

Key Type Constraint Name Attributes
PK MD_TRIGGERS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_TRIGGERS_TRG

Comments

For storing information about triggers.

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES

General Info

Caption MD_USER_DEFINED_DATA_TYPES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Schema to which this object blongs. //PARENTFIELD
DATA_TYPE_NAME Varchar2(4000 ) YES NO NO The name of the data type //OBJECTNAME
DEFINITION Varchar2(4000 ) YES NO NO The definition of the data type
NATIVE_SQL Clob YES NO NO The native SQL used to create this object
NATIVE_KEY Varchar2(4000 ) NO NO NO An unique identifier for this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_USER_DEFINED_DATA_TYPE_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_USER_DEFINED_DATA_TYPES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES_TRG

Comments

For storing information on user defined data types.

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES

General Info

Caption MD_USER_PRIVILEGES

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK USER_ID_FK Number YES NO NO User
FK PRIVILEGE_ID_FK Number NO NO NO Privilege
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UDPATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_USER_PRIVILEGES_MD_PRI_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PRIVILEGES MIGRATION_WORKBENCH.MD_USER_PRIVILEGES 1:N
MD_USER_PRIVILEGES_MD_USE_FK1 Non-identifying MIGRATION_WORKBENCH.MD_USERS MIGRATION_WORKBENCH.MD_USER_PRIVILEGES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_USER_PRIVILEGES_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_USER_PRIVILEGES_TRG

Comments

This table stores privileges granted to individual users

 

MIGRATION_WORKBENCH.MD_USERS

General Info

Caption MD_USERS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO Shema in which this object belongs //PARENTFIELD
USERNAME Varchar2(4000 ) YES NO NO Username for login //OBJECTNAME
PASSWORD Varchar2(4000 ) NO NO NO Password for login
NATIVE_SQL Clob NO NO NO SQL Used to create this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO Unique identifier for this object at source.
COMMENTS Varchar2(4000 ) NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_GROUPMEMBERS_MD_USERS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_USERS MIGRATION_WORKBENCH.MD_GROUP_MEMBERS 1:N
MD_USERS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_USERS 1:N
MD_USER_PRIVILEGES_MD_USE_FK1 Non-identifying MIGRATION_WORKBENCH.MD_USERS MIGRATION_WORKBENCH.MD_USER_PRIVILEGES 1:N

Keys

Key Type Constraint Name Attributes
PK MD_USERS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_USERS_TRG

Comments

User information.

 

MIGRATION_WORKBENCH.MD_VIEWS

General Info

Caption MD_VIEWS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK SCHEMA_ID_FK Number YES NO NO The schema to which this obect blongs. //PARENTFIELD
VIEW_NAME Varchar2(4000 ) NO NO NO The name of the view //OBJECTNAME
NATIVE_SQL Clob NO NO NO The SQL used to create this object at source
NATIVE_KEY Varchar2(4000 ) NO NO NO An identifier for this object at source.
LANGUAGE Varchar2(40 ) YES NO NO //PUBLIC
COMMENTS Varchar2(4000 ) NO NO NO
LINECOUNT Number NO NO NO
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MD_VIEWS_MD_SCHEMAS_FK1 Non-identifying MIGRATION_WORKBENCH.MD_SCHEMAS MIGRATION_WORKBENCH.MD_VIEWS 1:N

Keys

Key Type Constraint Name Attributes
PK MD_VIEWS_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MD_VIEWS_TRG
MIGRATION_WORKBENCH.DEL_MD_TRIGGERS_V_TRG

Comments

For storing information on views.

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP

General Info

Caption MIGR_DATATYPE_TRANSFORM_MAP

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK PROJECT_ID_FK Number YES NO NO //PARENTFIELD
MAP_NAME Varchar2(4000 ) NO NO NO A name for the map
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_DATATYPE_TRANSFORM_M_FK1 Non-identifying MIGRATION_WORKBENCH.MD_PROJECTS MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP 1:N
MIGR_DATATYPE_TRANSFORM_R_FK1 Non-identifying MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_DATATYPE_TRANSFORM_M_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MIGR_DATATYPE_MAP_TRG

Comments

Table for storing data type maps. A map is simply a collection of rules

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE

General Info

Caption MIGR_DATATYPE_TRANSFORM_RULE

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO Primary Key
FK MAP_ID_FK Number YES NO NO The map to which this rule belongs //PARENTFIELD
SOURCE_DATA_TYPE_NAME Varchar2(4000 ) YES NO NO Source data type
SOURCE_PRECISION Number NO NO NO Precison to match
SOURCE_SCALE Number NO NO NO scale to match
TARGET_DATA_TYPE_NAME Varchar2(4000 ) YES NO NO data type name to transform to
TARGET_PRECISION Number NO NO NO precision to map to
TARGET_SCALE Number NO NO NO scale to map to
SECURITY_GROUP_ID Number YES NO NO 0
CREATED_ON Date YES NO NO sysdate
CREATED_BY Varchar2(255 ) NO NO NO
LAST_UPDATED_ON Date NO NO NO
LAST_UPDATED_BY Varchar2(255 ) NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_DATATYPE_TRANSFORM_R_FK1 Non-identifying MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_DATATYPE_TRANSFORM_R_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MIGR_DATATYPE_RULE_TRG

 

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER

General Info

Caption MIGR_GENERATION_ORDER

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default Comments
PK ID Number YES NO NO
FK CONNECTION_ID_FK Number YES NO NO //PARENTFIELD
OBJECT_ID Number YES NO NO
OBJECT_TYPE Varchar2(4000 ) YES NO NO
GENERATION_ORDER Number YES NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_GENERATION_ORDER_MD__FK1 Non-identifying MIGRATION_WORKBENCH.MD_CONNECTIONS MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER 1:N

Keys

Key Type Constraint Name Attributes
PK MIGR_GENERATION_ORDER_PK ID

Triggers

Trigger Name
MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER_TRG

 

MIGRATION_WORKBENCH.MIGRATION_RESERVED_WORDS

General Info

Caption MIGRATION_RESERVED_WORDS

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
KEYWORD Varchar2(40 ) YES NO NO

 

MIGRATION_WORKBENCH.MIGRLOG

General Info

Caption MIGRLOG

Attributes

Key Attribute Name Domain Data Type Not Null Unique Check Default
PK ID Number YES NO NO
FK PARENT_LOG_ID Number NO NO NO
LOG_DATE Timestamp(6) YES NO NO
SEVERITY Number(4,0) YES NO NO
LOGTEXT Varchar2(4000 ) NO NO NO
PHASE Varchar2(20 ) NO NO NO
REF_OBJECT_ID Number NO NO NO
REF_OBJECT_TYPE Varchar2(4000 ) NO NO NO
CONNECTION_ID_FK Number NO NO NO

Relationships

Relationship Name Relationship Type Parent Entity Child Entity Card.
MIGR_MIGRLOG_FK Non-identifying MIGRATION_WORKBENCH.MIGRLOG MIGRATION_WORKBENCH.MIGRLOG 1:N
MIGR_MIGRLOG_FK Non-identifying MIGRATION_WORKBENCH.MIGRLOG MIGRATION_WORKBENCH.MIGRLOG 1:N

Keys

Key Type Constraint Name Attributes
PK MIGRLOG_PK ID

Indexes

Index Name Attributes Unique Descending Clustered
MIGRLOG_PERF_IDX REF_OBJECT_ID, SEVERITY NO

Triggers

Trigger Name
MIGRATION_WORKBENCH.MIGRLOG_TRG