COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary key
PROJECT_ID_FK NUMBER No null 2 null The project to which this connection belongs //PARENTFIELD
TYPE VARCHAR2(4000 BYTE) Yes null 3 null The type of the connection - For example it could be used to store "ORACLE" or "MYSQL"
HOST VARCHAR2(4000 BYTE) Yes null 4 null The host to which this connection connects.
PORT NUMBER Yes null 5 null The port to which this connection connects
USERNAME VARCHAR2(4000 BYTE) Yes null 6 null The username used to make the connection
PASSWORD VARCHAR2(4000 BYTE) Yes null 7 null The password used to make this connection
DBURL VARCHAR2(4000 BYTE) Yes null 8 null The database url used to make this connection
NAME VARCHAR2(255 BYTE) Yes null 9 null //OBJECTNAME
NATIVE_SQL CLOB Yes null 10 null The native sql used to create this connection
NUM_CATALOGS NUMBER Yes null 11 null null
NUM_COLUMNS NUMBER Yes null 12 null null
NUM_CONSTRAINTS NUMBER Yes null 13 null null
NUM_GROUPS NUMBER Yes null 14 null null
NUM_ROLES NUMBER Yes null 15 null null
NUM_INDEXES NUMBER Yes null 16 null null
NUM_OTHER_OBJECTS NUMBER Yes null 17 null null
NUM_PACKAGES NUMBER Yes null 18 null null
NUM_PRIVILEGES NUMBER Yes null 19 null null
NUM_SCHEMAS NUMBER Yes null 20 null null
NUM_SEQUENCES NUMBER Yes null 21 null null
NUM_STORED_PROGRAMS NUMBER Yes null 22 null null
NUM_SYNONYMS NUMBER Yes null 23 null null
NUM_TABLES NUMBER Yes null 24 null null
NUM_TABLESPACES NUMBER Yes null 25 null null
NUM_TRIGGERS NUMBER Yes null 26 null null
NUM_USER_DEFINED_DATA_TYPES NUMBER Yes null 27 null null
NUM_USERS NUMBER Yes null 28 null null
NUM_VIEWS NUMBER Yes null 29 null null
COMMENTS VARCHAR2(4000 BYTE) Yes null 30 null null
SECURITY_GROUP_ID NUMBER No 0 31 null null
CREATED_ON DATE No sysdate 32 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 33 null null
LAST_UPDATED_ON DATE Yes null 34 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 35 null null