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 |