COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
CATALOG_ID_FK NUMBER No null 2 null Catalog to which this schema blongs //PARENTFIELD
NAME VARCHAR2(4000 BYTE) Yes null 3 null Name of the schema //OBJECTNAME
TYPE CHAR(1 BYTE) Yes null 4 null Type of this schema. Eaxamples are 'CAPTURED' OR 'CONVERTED'
CHARACTER_SET VARCHAR2(4000 BYTE) Yes null 5 null The characterset of this schema
VERSION_TAG VARCHAR2(40 BYTE) Yes null 6 null A version string that can be used for tagging/baseling a schema
NATIVE_SQL CLOB Yes null 7 null The native SQL used to create this schema
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 8 null A unique identifier that this schema is known as in its source state.
COMMENTS VARCHAR2(4000 BYTE) Yes null 9 null null
SECURITY_GROUP_ID NUMBER No 0 10 null null
CREATED_ON DATE No sysdate 11 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 12 null null
LAST_UPDATED_ON DATE Yes null 13 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 14 null null