Toad Data Modeler - HTML Report

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	NO
Foreign Key	NO
Data Type	Number
Not Null	NO
Unique	NO

Comments

Precison to match

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.SOURCE_SCALE

General Info

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

Comments

scale to match

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.TARGET_DATA_TYPE_NAME

General Info

Caption	TARGET_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_C0020981

Comments

data type name to transform to

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.TARGET_PRECISION

General Info

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

Comments

precision to map to

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE.TARGET_SCALE

General Info

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

Comments

scale to map to

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER.CONNECTION_ID_FK

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021034

Comments

//PARENTFIELD

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER.GENERATION_ORDER

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021037

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER.ID

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021033

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER.OBJECT_ID

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021035

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER.OBJECT_TYPE

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021036

MIGRATION_WORKBENCH.MIGRATION_RESERVED_WORDS.KEYWORD

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0021109

MIGRATION_WORKBENCH.MIGRLOG.CONNECTION_ID_FK

General Info

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

MIGRATION_WORKBENCH.MIGRLOG.ID

General Info

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

Attribute Properties

Constraint NotNull Name

SYS_C0020943

MIGRATION_WORKBENCH.MIGRLOG.LOG_DATE

General Info

Caption	LOG_DATE
Entity Name	MIGRATION_WORKBENCH.MIGRLOG
Primary Key	NO
Foreign Key	NO
Data Type	Timestamp(6)
Not Null	YES
Unique	NO

Attribute Properties

Constraint NotNull Name

SYS_C0020944

MIGRATION_WORKBENCH.MIGRLOG.LOGTEXT

General Info

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

MIGRATION_WORKBENCH.MIGRLOG.PARENT_LOG_ID

General Info

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

MIGRATION_WORKBENCH.MIGRLOG.PHASE

General Info

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

MIGRATION_WORKBENCH.MIGRLOG.REF_OBJECT_ID

General Info

Caption	REF_OBJECT_ID
Entity Name	MIGRATION_WORKBENCH.MIGRLOG
Primary Key	NO
Foreign Key	NO
Data Type	Number
Not Null	NO
Unique	NO

MIGRATION_WORKBENCH.MIGRLOG.REF_OBJECT_TYPE

General Info

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

MIGRATION_WORKBENCH.MIGRLOG.SEVERITY

General Info

Caption	SEVERITY
Entity Name	MIGRATION_WORKBENCH.MIGRLOG
Primary Key	NO
Foreign Key	NO
Data Type	Number(4,0)
Not Null	YES
Unique	NO

Attribute Properties

Constraint NotNull Name

SYS_C0020945