MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020936

Comments

Connection to which this belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020941

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020935

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.PROP_KEY

General Info

Caption PROP_KEY
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020939

Comments

The keyname for this property

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.PROPERTY_ORDER

General Info

Caption PROPERTY_ORDER
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

This is to handle a situation where multiple properties have a relevant order, or multiple properties have multiple values

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.REF_ID_FK

General Info

Caption REF_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020937

Comments

The object to which this property blongs

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.REF_TYPE

General Info

Caption REF_TYPE
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020938

Comments

Type of object that this property belongs to

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020940

 

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES.VALUE

General Info

Caption VALUE
Entity Name MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The value for this property

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.APPLICATIONS_ID_FK

General Info

Caption APPLICATIONS_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020820

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

APEX

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020826

Comments

APEX

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020819

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(100 )
Not Null NO
Unique NO

Comments

Language of the file that has been processed.

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(200 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020821

Comments

file name //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020825

Comments

APEX

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.STATE

General Info

Caption STATE
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(100 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020824

Comments

State will be how this file is operated on. For example. it will be OPEN, NEW, FIXED, IGNORED, REVIEWED, COMPLETE

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.TYPE

General Info

Caption TYPE
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(100 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020823

Comments

This will denote the type of file we have, including DIR, FILE (text), BINARY, IGNORE (where we choose to ignore files)

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.UPDATED_BY

General Info

Caption UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

APEX

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.UPDATED_ON

General Info

Caption UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

Comments

APEX

 

MIGRATION_WORKBENCH.MD_APPLICATIONFILES.URI

General Info

Caption URI
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONFILES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020822

Comments

The uri is the part of the file url after the base dir has been removed. See MD_APPLICATION for base dir

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.BACKUP_DIR

General Info

Caption BACKUP_DIR
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

This is the directory in which the application files are backed up if a backp is chosen

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.BASE_DIR

General Info

Caption BASE_DIR
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

This is the base src directory for the application. It could be an svn checkout, a clearcase view or something similar

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020815

Comments

captured model of the database(s) this application relates to

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020817

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.DESCRIPTION

General Info

Caption DESCRIPTION
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Overview of what the application does.

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020814

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.INPLACE

General Info

Caption INPLACE
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

Designates whether the changes have been made inplace, in the source directory or not

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the application suite //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.OUTPUT_DIR

General Info

Caption OUTPUT_DIR
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

This is the output directory where the scanner will present the converted files, if there are converted or modified.

 

MIGRATION_WORKBENCH.MD_APPLICATIONS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_APPLICATIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020816

 

MIGRATION_WORKBENCH.MD_CATALOGS.CATALOG_NAME

General Info

Caption CATALOG_NAME
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the catalog //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_CATALOGS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CATALOGS.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020856

Comments

Foreign key into the connections table - Shows what connection this catalog belongs to //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_CATALOGS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CATALOGS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020858

 

MIGRATION_WORKBENCH.MD_CATALOGS.DUMMY_FLAG

General Info

Caption DUMMY_FLAG
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO
Default 'N'

Comments

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.

 

MIGRATION_WORKBENCH.MD_CATALOGS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020855

 

MIGRATION_WORKBENCH.MD_CATALOGS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CATALOGS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CATALOGS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique identifier used to identify the catalog at source.

 

MIGRATION_WORKBENCH.MD_CATALOGS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

THe SQL used to create this catalog

 

MIGRATION_WORKBENCH.MD_CATALOGS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_CATALOGS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020857

 

MIGRATION_WORKBENCH.MD_COLUMNS.COLUMN_NAME

General Info

Caption COLUMN_NAME
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020871

Comments

The name of the column //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_COLUMNS.COLUMN_ORDER

General Info

Caption COLUMN_ORDER
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020872

Comments

The order this appears in the table

 

MIGRATION_WORKBENCH.MD_COLUMNS.COLUMN_TYPE

General Info

Caption COLUMN_TYPE
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The type of the column

 

MIGRATION_WORKBENCH.MD_COLUMNS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_COLUMNS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_COLUMNS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020874

 

MIGRATION_WORKBENCH.MD_COLUMNS.DATATYPE_TRANSFORMED_FLAG

General Info

Caption DATATYPE_TRANSFORMED_FLAG
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

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

 

MIGRATION_WORKBENCH.MD_COLUMNS.DEFAULT_VALUE

General Info

Caption DEFAULT_VALUE
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Default value on the column

 

MIGRATION_WORKBENCH.MD_COLUMNS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020869

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_COLUMNS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_COLUMNS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_COLUMNS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Unique identifier for this object at source

 

MIGRATION_WORKBENCH.MD_COLUMNS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this column at source

 

MIGRATION_WORKBENCH.MD_COLUMNS.NULLABLE

General Info

Caption NULLABLE
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

Yes or No. Null signifies NO

 

MIGRATION_WORKBENCH.MD_COLUMNS.PRECISION

General Info

Caption PRECISION
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

The precision on the column

 

MIGRATION_WORKBENCH.MD_COLUMNS.SCALE

General Info

Caption SCALE
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

The scale of the column

 

MIGRATION_WORKBENCH.MD_COLUMNS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020873

 

MIGRATION_WORKBENCH.MD_COLUMNS.TABLE_ID_FK

General Info

Caption TABLE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_COLUMNS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020870

Comments

The table that this column is part of //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020879

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.DBURL

General Info

Caption DBURL
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The database url used to make this connection

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.HOST

General Info

Caption HOST
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The host to which this connection connects.

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020876

Comments

Primary key

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

Comments

//OBJECTNAME

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The native sql used to create this connection

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_CATALOGS

General Info

Caption NUM_CATALOGS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_COLUMNS

General Info

Caption NUM_COLUMNS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_CONSTRAINTS

General Info

Caption NUM_CONSTRAINTS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_GROUPS

General Info

Caption NUM_GROUPS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_INDEXES

General Info

Caption NUM_INDEXES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_OTHER_OBJECTS

General Info

Caption NUM_OTHER_OBJECTS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_PACKAGES

General Info

Caption NUM_PACKAGES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_PRIVILEGES

General Info

Caption NUM_PRIVILEGES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_ROLES

General Info

Caption NUM_ROLES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_SCHEMAS

General Info

Caption NUM_SCHEMAS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_SEQUENCES

General Info

Caption NUM_SEQUENCES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_STORED_PROGRAMS

General Info

Caption NUM_STORED_PROGRAMS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_SYNONYMS

General Info

Caption NUM_SYNONYMS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_TABLES

General Info

Caption NUM_TABLES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_TABLESPACES

General Info

Caption NUM_TABLESPACES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_TRIGGERS

General Info

Caption NUM_TRIGGERS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_USER_DEFINED_DATA_TYPES

General Info

Caption NUM_USER_DEFINED_DATA_TYPES
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_USERS

General Info

Caption NUM_USERS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.NUM_VIEWS

General Info

Caption NUM_VIEWS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.PASSWORD

General Info

Caption PASSWORD
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The password used to make this connection

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.PORT

General Info

Caption PORT
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

The port to which this connection connects

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.PROJECT_ID_FK

General Info

Caption PROJECT_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020877

Comments

The project to which this connection belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020878

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.STATUS

General Info

Caption STATUS
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(30 )
Not Null NO
Unique NO

Comments

Status of Migration, = captured,converted,generated,datamoved

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.TYPE

General Info

Caption TYPE
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The type of the connection - For example it could be used to store "ORACLE" or "MYSQL"

 

MIGRATION_WORKBENCH.MD_CONNECTIONS.USERNAME

General Info

Caption USERNAME
Entity Name MIGRATION_WORKBENCH.MD_CONNECTIONS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The username used to make the connection

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.COLUMN_ID_FK

General Info

Caption COLUMN_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.COLUMN_PORTION

General Info

Caption COLUMN_PORTION
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

The portion of a column this detail belongs (e.g. for constrints on substrings)

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.CONSTRAINT_ID_FK

General Info

Caption CONSTRAINT_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021050

Comments

Constraint that this detail belongs to //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.CONSTRAINT_TEXT

General Info

Caption CONSTRAINT_TEXT
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The text of the constraint

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021053

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.DETAIL_ORDER

General Info

Caption DETAIL_ORDER
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021051

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021049

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.REF_FLAG

General Info

Caption REF_FLAG
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO
Default 'N'

Comments

"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)

 

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021052

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.CONSTRAINT_TEXT

General Info

Caption CONSTRAINT_TEXT
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The text of the constraint

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.CONSTRAINT_TYPE

General Info

Caption CONSTRAINT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Type of the constraint (e.g. CHECK)

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020915

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.DELETE_CLAUSE

General Info

Caption DELETE_CLAUSE
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

delete option , can be either CASCADE, RESTRICT or NULL

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020911

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020913

Comments

//PUBLIC

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the constraint //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.REFTABLE_ID_FK

General Info

Caption REFTABLE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

Used in foreign keys - this gives the table that we refer to.

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020914

 

MIGRATION_WORKBENCH.MD_CONSTRAINTS.TABLE_ID_FK

General Info

Caption TABLE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_CONSTRAINTS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020912

Comments

Table on which this constraint exists //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020998

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.DERIVATIVE_REASON

General Info

Caption DERIVATIVE_REASON
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(10 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.DERIVED_CONNECTION_ID_FK

General Info

Caption DERIVED_CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020996

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.DERIVED_ID

General Info

Caption DERIVED_ID
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020995

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.DERIVED_OBJECT_NAMESPACE

General Info

Caption DERIVED_OBJECT_NAMESPACE
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.DERIVED_TYPE

General Info

Caption DERIVED_TYPE
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020993

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.NEW_IDENTIFIER

General Info

Caption NEW_IDENTIFIER
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.ORIGINAL_IDENTIFIER

General Info

Caption ORIGINAL_IDENTIFIER
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020997

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.SRC_ID

General Info

Caption SRC_ID
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020994

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.SRC_TYPE

General Info

Caption SRC_TYPE
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_DERIVATIVES.TRANSFORMED

General Info

Caption TRANSFORMED
Entity Name MIGRATION_WORKBENCH.MD_DERIVATIVES
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

Set this field to 'Y' if we carry out any sort of transformation on teh derived object.

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.APPLICATIONFILES_ID

General Info

Caption APPLICATIONFILES_ID
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name MD_APPL_FILE_FK_NONULL

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.CODE_TYPE

General Info

Caption CODE_TYPE
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(1000 )
Not Null NO
Unique NO

Comments

Source code db api, like dblib, jdbc

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020831

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.DB_TYPE

General Info

Caption DB_TYPE
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(100 )
Not Null NO
Unique NO

Comments

Source database calls type

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.DESCRIPTION

General Info

Caption DESCRIPTION
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

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

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.DUE_DATE

General Info

Caption DUE_DATE
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

Comments

Due date is used by the TODO mechanism to manage the validation and work to complete this change

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name MD_APP_FILE_ART_NONULL

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.LAST_UPDATED

General Info

Caption LAST_UPDATED
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.LINE

General Info

Caption LINE
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.PATTERN

General Info

Caption PATTERN
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Pattern used to search source file for interesting artifiacts

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.PATTERN_END

General Info

Caption PATTERN_END
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.PATTERN_START

General Info

Caption PATTERN_START
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.PRIORITY

General Info

Caption PRIORITY
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Integer
Not Null NO
Unique NO

Comments

The priority is set for the TODOs so they can be managed by the user

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(20 )
Not Null YES
Unique NO
Default '0'

Attribute Properties

Constraint NotNull Name SYS_C0020830

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.STATUS

General Info

Caption STATUS
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Pattern used to search source file for interesting artifiacts

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.STRING_FOUND

General Info

Caption STRING_FOUND
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

String found in source from the pattern supplied

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.STRING_REPLACED

General Info

Caption STRING_REPLACED
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

This is the string which replace the string found if it was replaced.

 

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS.TYPE

General Info

Caption TYPE
Entity Name MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(200 )
Not Null NO
Unique NO

Comments

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.

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020853

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.GROUP_ID_FK

General Info

Caption GROUP_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020851

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.GROUP_MEMBER_ID_FK

General Info

Caption GROUP_MEMBER_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null NO
Unique NO

Comments

groups can be members of groups

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020850

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020852

 

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS.USER_ID_FK

General Info

Caption USER_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUP_MEMBERS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null NO
Unique NO

Comments

Id of member

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020965

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.GROUP_ID_FK

General Info

Caption GROUP_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020962

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020961

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.PRIVILEGE_ID_FK

General Info

Caption PRIVILEGE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020963

 

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020964

 

MIGRATION_WORKBENCH.MD_GROUPS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUPS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUPS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020933

 

MIGRATION_WORKBENCH.MD_GROUPS.GROUP_FLAG

General Info

Caption GROUP_FLAG
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

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.

 

MIGRATION_WORKBENCH.MD_GROUPS.GROUP_NAME

General Info

Caption GROUP_NAME
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the group //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_GROUPS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020930

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_GROUPS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUPS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_GROUPS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Unique id for this object at source

 

MIGRATION_WORKBENCH.MD_GROUPS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

SQL Used to generate this object at source

 

MIGRATION_WORKBENCH.MD_GROUPS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020931

Comments

Schema in which this object belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_GROUPS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_GROUPS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020932

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.COLUMN_ID_FK

General Info

Caption COLUMN_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020901

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020904

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.DETAIL_ORDER

General Info

Caption DETAIL_ORDER
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020902

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020899

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.INDEX_ID_FK

General Info

Caption INDEX_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020900

Comments

The index to which this detail belongs. //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.INDEX_PORTION

General Info

Caption INDEX_PORTION
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

To support indexing on part of a field

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEX_DETAILS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_INDEX_DETAILS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020903

 

MIGRATION_WORKBENCH.MD_INDEXES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEXES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEXES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020976

 

MIGRATION_WORKBENCH.MD_INDEXES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020973

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_INDEXES.INDEX_NAME

General Info

Caption INDEX_NAME
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the index //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_INDEXES.INDEX_TYPE

General Info

Caption INDEX_TYPE
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Type of the index e.g. PRIMARY

 

MIGRATION_WORKBENCH.MD_INDEXES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEXES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_INDEXES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique identifier for this object at the source

 

MIGRATION_WORKBENCH.MD_INDEXES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

SQL used to create the index at source

 

MIGRATION_WORKBENCH.MD_INDEXES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020975

 

MIGRATION_WORKBENCH.MD_INDEXES.TABLE_ID_FK

General Info

Caption TABLE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_INDEXES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020974

Comments

Table that this index is on //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.CHILD_ID

General Info

Caption CHILD_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021018

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.CHILD_OBJECT_TYPE

General Info

Caption CHILD_OBJECT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021020

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021016

Comments

The connection that this exists in //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021022

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021015

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.PARENT_ID

General Info

Caption PARENT_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021017

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.PARENT_OBJECT_TYPE

General Info

Caption PARENT_OBJECT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021019

 

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021021

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020887

Comments

the connection in which this belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020897

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.DEFAULT_VALUE

General Info

Caption DEFAULT_VALUE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020886

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.NULLABLE

General Info

Caption NULLABLE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020895

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.OBJECT_ID

General Info

Caption OBJECT_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020888

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.OBJECT_TYPE

General Info

Caption OBJECT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020889

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PARAM_DATA_TYPE

General Info

Caption PARAM_DATA_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020894

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PARAM_EXISTING

General Info

Caption PARAM_EXISTING
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020890

Comments

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

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PARAM_NAME

General Info

Caption PARAM_NAME
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020892

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PARAM_ORDER

General Info

Caption PARAM_ORDER
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020891

Comments

IF -1 THEN THIS PARAM IS A RETURN PARAMETER. 1 WILL BE THE FIRST PARAMETER IN THE PARAMETER LIST

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PARAM_TYPE

General Info

Caption PARAM_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020893

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.PERCISION

General Info

Caption PERCISION
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.SCALE

General Info

Caption SCALE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_PARAMETER
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020896

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.CHILD_NAME

General Info

Caption CHILD_NAME
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021043

Comments

name of the child, as weak dependencies dont have reference to child id

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.CHILD_TYPE

General Info

Caption CHILD_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021045

Comments

Generic Type (not MD_<tablename>)

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.CONNECTION_ID_FK

General Info

Caption CONNECTION_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021040

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021047

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021039

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.PARENT_ID

General Info

Caption PARENT_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021042

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.PARENT_TYPE

General Info

Caption PARENT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021044

Comments

MD_<tablename>

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021041

 

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021046

 

MIGRATION_WORKBENCH.MD_NUMROW$SOURCE.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$SOURCE
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_NUMROW$SOURCE.NUMROWS

General Info

Caption NUMROWS
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$SOURCE
Primary Key NO
Foreign Key NO
Data Type Number(10,0)
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_NUMROW$SOURCE.OBJID

General Info

Caption OBJID
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$SOURCE
Primary Key NO
Foreign Key NO
Data Type Number(10,0)
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_NUMROW$TARGET.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$TARGET
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_NUMROW$TARGET.NUMROWS

General Info

Caption NUMROWS
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$TARGET
Primary Key NO
Foreign Key NO
Data Type Number(10,0)
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_NUMROW$TARGET.OBJID

General Info

Caption OBJID
Entity Name MIGRATION_WORKBENCH.MD_NUMROW$TARGET
Primary Key NO
Foreign Key NO
Data Type Number(10,0)
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020909

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020906

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of this object //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A key that identifies this object at source.

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The native SQL used to create this object

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020907

Comments

Schema to which this object blongs. //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_OTHER_OBJECTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020908

 

MIGRATION_WORKBENCH.MD_PACKAGES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PACKAGES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PACKAGES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020959

 

MIGRATION_WORKBENCH.MD_PACKAGES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020954

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_PACKAGES.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020957

Comments

//PUBLIC

 

MIGRATION_WORKBENCH.MD_PACKAGES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PACKAGES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PACKAGES.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020956

Comments

Name of this package //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_PACKAGES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique identifer for this object at source.

 

MIGRATION_WORKBENCH.MD_PACKAGES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this package at source

 

MIGRATION_WORKBENCH.MD_PACKAGES.PACKAGE_HEADER

General Info

Caption PACKAGE_HEADER
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PACKAGES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020955

Comments

the schema in which this package resides //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_PACKAGES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_PACKAGES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020958

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.ADMIN_OPTION

General Info

Caption ADMIN_OPTION
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

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.)

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021031

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021024

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

An identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021029

Comments

The SQL used to create this privilege at source

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.PRIVELEGE_OBJECT_ID

General Info

Caption PRIVELEGE_OBJECT_ID
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

Comments

This references the table, view, etc on which the privelege exists. This can be NULL for things like system wide privileges

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.PRIVELEGE_TYPE

General Info

Caption PRIVELEGE_TYPE
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021028

Comments

e.g.select

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.PRIVELEGEOBJECTTYPE

General Info

Caption PRIVELEGEOBJECTTYPE
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021027

Comments

The type the privelege is on (e.g. INDEX)

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.PRIVILEGE_NAME

General Info

Caption PRIVILEGE_NAME
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021026

Comments

The name of the privilege //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021025

Comments

The schema to which this object belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_PRIVILEGES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021030

 

MIGRATION_WORKBENCH.MD_PROJECTS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PROJECTS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PROJECTS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020884

 

MIGRATION_WORKBENCH.MD_PROJECTS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020881

Comments

Primary key

 

MIGRATION_WORKBENCH.MD_PROJECTS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PROJECTS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_PROJECTS.PROJECT_NAME

General Info

Caption PROJECT_NAME
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020882

Comments

Name of the project //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_PROJECTS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_PROJECTS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020883

 

MIGRATION_WORKBENCH.MD_REGISTRY.DESC_OBJECT_NAME

General Info

Caption DESC_OBJECT_NAME
Entity Name MIGRATION_WORKBENCH.MD_REGISTRY
Primary Key NO
Foreign Key NO
Data Type Varchar2(30 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_REGISTRY.OBJECT_NAME

General Info

Caption OBJECT_NAME
Entity Name MIGRATION_WORKBENCH.MD_REGISTRY
Primary Key YES
Foreign Key NO
Data Type Varchar2(30 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020991

 

MIGRATION_WORKBENCH.MD_REGISTRY.OBJECT_TYPE

General Info

Caption OBJECT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_REGISTRY
Primary Key YES
Foreign Key NO
Data Type Varchar2(30 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020990

 

MIGRATION_WORKBENCH.MD_REPOVERSIONS.REVISION

General Info

Caption REVISION
Entity Name MIGRATION_WORKBENCH.MD_REPOVERSIONS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020843

 

MIGRATION_WORKBENCH.MD_SCHEMAS.CATALOG_ID_FK

General Info

Caption CATALOG_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020986

Comments

Catalog to which this schema blongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_SCHEMAS.CHARACTER_SET

General Info

Caption CHARACTER_SET
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The characterset of this schema

 

MIGRATION_WORKBENCH.MD_SCHEMAS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SCHEMAS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SCHEMAS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020988

 

MIGRATION_WORKBENCH.MD_SCHEMAS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020985

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_SCHEMAS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SCHEMAS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SCHEMAS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the schema //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_SCHEMAS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique identifier that this schema is known as in its source state.

 

MIGRATION_WORKBENCH.MD_SCHEMAS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The native SQL used to create this schema

 

MIGRATION_WORKBENCH.MD_SCHEMAS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020987

 

MIGRATION_WORKBENCH.MD_SCHEMAS.TYPE

General Info

Caption TYPE
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

Type of this schema. Eaxamples are 'CAPTURED' OR 'CONVERTED'

 

MIGRATION_WORKBENCH.MD_SCHEMAS.VERSION_TAG

General Info

Caption VERSION_TAG
Entity Name MIGRATION_WORKBENCH.MD_SCHEMAS
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null NO
Unique NO

Comments

A version string that can be used for tagging/baseling a schema

 

MIGRATION_WORKBENCH.MD_SEQUENCES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SEQUENCES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null YES
Unique NO
Default '0'

Attribute Properties

Constraint NotNull Name SYS_C0020867

 

MIGRATION_WORKBENCH.MD_SEQUENCES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020866

 

MIGRATION_WORKBENCH.MD_SEQUENCES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020860

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_SEQUENCES.INCR

General Info

Caption INCR
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 1

Attribute Properties

Constraint NotNull Name SYS_C0020864

Comments

Increment value of the sequence

 

MIGRATION_WORKBENCH.MD_SEQUENCES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SEQUENCES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SEQUENCES.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020862

Comments

Name of this sequence //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_SEQUENCES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_SEQUENCES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

SQL used to create this object at source

 

MIGRATION_WORKBENCH.MD_SEQUENCES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020861

Comments

The schema to which this object belongs. //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_SEQUENCES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020865

 

MIGRATION_WORKBENCH.MD_SEQUENCES.SEQ_START

General Info

Caption SEQ_START
Entity Name MIGRATION_WORKBENCH.MD_SEQUENCES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020863

Comments

Starting point of the sequence

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021059

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021055

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021057

Comments

//PUBLIC

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.LINECOUNT

General Info

Caption LINECOUNT
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the stored program //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique indetifier for this object at source

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this object at source

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.PACKAGE_ID_FK

General Info

Caption PACKAGE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null NO
Unique NO

Comments

The package to which this object belongs

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.PROGRAMTYPE

General Info

Caption PROGRAMTYPE
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(20 )
Not Null NO
Unique NO

Comments

Java/TSQL/PLSQL, etc.

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021056

Comments

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

 

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_STORED_PROGRAMS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021058

 

MIGRATION_WORKBENCH.MD_SYNONYMS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SYNONYMS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SYNONYMS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021006

 

MIGRATION_WORKBENCH.MD_SYNONYMS.FOR_OBJECT_TYPE

General Info

Caption FOR_OBJECT_TYPE
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021004

Comments

The type this is a synonym for (e.g. INDEX)

 

MIGRATION_WORKBENCH.MD_SYNONYMS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021000

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_SYNONYMS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SYNONYMS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_SYNONYMS.NAME

General Info

Caption NAME
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021002

Comments

Synonym name //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_SYNONYMS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

An identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_SYNONYMS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this object at source

 

MIGRATION_WORKBENCH.MD_SYNONYMS.PRIVATE_VISIBILITY

General Info

Caption PRIVATE_VISIBILITY
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null NO
Unique NO

Comments

Visibility - Private or Public. If Private_visibility = 'Y' means this is a private synonym. Anything else means it is a public synonym

 

MIGRATION_WORKBENCH.MD_SYNONYMS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021001

Comments

The schema to which this object belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_SYNONYMS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021005

 

MIGRATION_WORKBENCH.MD_SYNONYMS.SYNONYM_FOR_ID

General Info

Caption SYNONYM_FOR_ID
Entity Name MIGRATION_WORKBENCH.MD_SYNONYMS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021003

Comments

What object this is a synonym for

 

MIGRATION_WORKBENCH.MD_TABLES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020952

 

MIGRATION_WORKBENCH.MD_TABLES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020947

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_TABLES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Unique identifier for this table at source

 

MIGRATION_WORKBENCH.MD_TABLES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

SQL Used to create this table at soruce

 

MIGRATION_WORKBENCH.MD_TABLES.QUALIFIED_NATIVE_NAME

General Info

Caption QUALIFIED_NATIVE_NAME
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020950

 

MIGRATION_WORKBENCH.MD_TABLES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020948

Comments

Schema in which this table resides //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_TABLES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020951

 

MIGRATION_WORKBENCH.MD_TABLES.TABLE_NAME

General Info

Caption TABLE_NAME
Entity Name MIGRATION_WORKBENCH.MD_TABLES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020949

Comments

Name of the table //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_TABLESPACES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLESPACES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLESPACES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020836

 

MIGRATION_WORKBENCH.MD_TABLESPACES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020833

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_TABLESPACES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLESPACES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TABLESPACES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A unique identifier for this object at source

 

MIGRATION_WORKBENCH.MD_TABLESPACES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this tablespace

 

MIGRATION_WORKBENCH.MD_TABLESPACES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020834

Comments

Schema to which this tablespace belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_TABLESPACES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020835

 

MIGRATION_WORKBENCH.MD_TABLESPACES.TABLESPACE_NAME

General Info

Caption TABLESPACE_NAME
Entity Name MIGRATION_WORKBENCH.MD_TABLESPACES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the table space //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_TRIGGERS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TRIGGERS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TRIGGERS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0021013

 

MIGRATION_WORKBENCH.MD_TRIGGERS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021008

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_TRIGGERS.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021011

Comments

//PUBLIC

 

MIGRATION_WORKBENCH.MD_TRIGGERS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TRIGGERS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TRIGGERS.LINECOUNT

General Info

Caption LINECOUNT
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_TRIGGERS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

UInique identifer for this object at source

 

MIGRATION_WORKBENCH.MD_TRIGGERS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The full definition

 

MIGRATION_WORKBENCH.MD_TRIGGERS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0021012

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TABLE_OR_VIEW_ID_FK

General Info

Caption TABLE_OR_VIEW_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021009

Comments

Table on which this trigger fires

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TRIGGER_EVENT

General Info

Caption TRIGGER_EVENT
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The actual trigger that gets fired

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TRIGGER_NAME

General Info

Caption TRIGGER_NAME
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Name of the trigger //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TRIGGER_ON_FLAG

General Info

Caption TRIGGER_ON_FLAG
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Char(1 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0021010

Comments

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'

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TRIGGER_OPERATION

General Info

Caption TRIGGER_OPERATION
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

insert, delete, etc.

 

MIGRATION_WORKBENCH.MD_TRIGGERS.TRIGGER_TIMING

General Info

Caption TRIGGER_TIMING
Entity Name MIGRATION_WORKBENCH.MD_TRIGGERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

before, after ,etc.

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020923

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.DATA_TYPE_NAME

General Info

Caption DATA_TYPE_NAME
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020919

Comments

The name of the data type //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.DEFINITION

General Info

Caption DEFINITION
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020920

Comments

The definition of the data type

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020917

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

An unique identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020921

Comments

The native SQL used to create this object

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020918

Comments

Schema to which this object blongs. //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020922

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020841

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020838

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.LAST_UDPATED_BY

General Info

Caption LAST_UDPATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.PRIVILEGE_ID_FK

General Info

Caption PRIVILEGE_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null NO
Unique NO

Comments

Privilege

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020840

 

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES.USER_ID_FK

General Info

Caption USER_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_USER_PRIVILEGES
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020839

Comments

User

 

MIGRATION_WORKBENCH.MD_USERS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USERS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USERS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020848

 

MIGRATION_WORKBENCH.MD_USERS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020844

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_USERS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USERS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_USERS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Unique identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_USERS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

SQL Used to create this object at source

 

MIGRATION_WORKBENCH.MD_USERS.PASSWORD

General Info

Caption PASSWORD
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

Password for login

 

MIGRATION_WORKBENCH.MD_USERS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020845

Comments

Shema in which this object belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_USERS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020847

 

MIGRATION_WORKBENCH.MD_USERS.USERNAME

General Info

Caption USERNAME
Entity Name MIGRATION_WORKBENCH.MD_USERS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020846

Comments

Username for login //OBJECTNAME

 

MIGRATION_WORKBENCH.MD_VIEWS.COMMENTS

General Info

Caption COMMENTS
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_VIEWS.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_VIEWS.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020971

 

MIGRATION_WORKBENCH.MD_VIEWS.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020967

Comments

Primary Key

 

MIGRATION_WORKBENCH.MD_VIEWS.LANGUAGE

General Info

Caption LANGUAGE
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(40 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020969

Comments

//PUBLIC

 

MIGRATION_WORKBENCH.MD_VIEWS.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_VIEWS.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_VIEWS.LINECOUNT

General Info

Caption LINECOUNT
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MD_VIEWS.NATIVE_KEY

General Info

Caption NATIVE_KEY
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

An identifier for this object at source.

 

MIGRATION_WORKBENCH.MD_VIEWS.NATIVE_SQL

General Info

Caption NATIVE_SQL
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Clob
Not Null NO
Unique NO

Comments

The SQL used to create this object at source

 

MIGRATION_WORKBENCH.MD_VIEWS.SCHEMA_ID_FK

General Info

Caption SCHEMA_ID_FK
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020968

Comments

The schema to which this obect blongs. //PARENTFIELD

 

MIGRATION_WORKBENCH.MD_VIEWS.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020970

 

MIGRATION_WORKBENCH.MD_VIEWS.VIEW_NAME

General Info

Caption VIEW_NAME
Entity Name MIGRATION_WORKBENCH.MD_VIEWS
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

The name of the view //OBJECTNAME

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020928

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020925

Comments

Primary Key

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.MAP_NAME

General Info

Caption MAP_NAME
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null NO
Unique NO

Comments

A name for the map

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.PROJECT_ID_FK

General Info

Caption PROJECT_ID_FK
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020926

Comments

//PARENTFIELD

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020927

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.CREATED_BY

General Info

Caption CREATED_BY
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.CREATED_ON

General Info

Caption CREATED_ON
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Date
Not Null YES
Unique NO
Default sysdate

Attribute Properties

Constraint NotNull Name SYS_C0020983

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.ID

General Info

Caption ID
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key YES
Foreign Key NO
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020978

Comments

Primary Key

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.LAST_UPDATED_BY

General Info

Caption LAST_UPDATED_BY
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Varchar2(255 )
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.LAST_UPDATED_ON

General Info

Caption LAST_UPDATED_ON
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Date
Not Null NO
Unique NO

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.MAP_ID_FK

General Info

Caption MAP_ID_FK
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key YES
Data Type Number
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020979

Comments

The map to which this rule belongs //PARENTFIELD

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.SECURITY_GROUP_ID

General Info

Caption SECURITY_GROUP_ID
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Number
Not Null YES
Unique NO
Default 0

Attribute Properties

Constraint NotNull Name SYS_C0020982

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.SOURCE_DATA_TYPE_NAME

General Info

Caption SOURCE_DATA_TYPE_NAME
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key NO
Foreign Key NO
Data Type Varchar2(4000 )
Not Null YES
Unique NO

Attribute Properties

Constraint NotNull Name SYS_C0020980

Comments

Source data type

 

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.SOURCE_PRECISION

General Info

Caption SOURCE_PRECISION
Entity Name MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE
Primary Key