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 |