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 |