COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 null
CONNECTION_ID_FK NUMBER No null 2 null Foreign key into the connections table - Shows what connection this catalog belongs to //PARENTFIELD
CATALOG_NAME VARCHAR2(4000 BYTE) Yes null 3 null Name of the catalog //OBJECTNAME
DUMMY_FLAG CHAR(1 BYTE) Yes 'N' 4 null Flag to show if this catalog is a "dummy" catalog which is used as a placeholder for those platforms that do not support catalogs. 'N' signifies that this is NOT a dummy catalog, while 'Y' signifies that it is.
NATIVE_SQL CLOB Yes null 5 null THe SQL used to create this catalog
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 6 null A unique identifier used to identify the catalog at source.
COMMENTS VARCHAR2(4000 BYTE) Yes null 7 null null
SECURITY_GROUP_ID NUMBER No 0 8 null null
CREATED_ON DATE No sysdate 9 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 10 null null
LAST_UPDATED_ON DATE Yes null 11 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 12 null null