## MD_CONNECTIONS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

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