## MD_ADDITIONAL_PROPERTIES

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
CONNECTION_ID_FK | NUMBER | No | null | 2 | null | Connection to which this belongs //PARENTFIELD
REF_ID_FK | NUMBER | No | null | 3 | null | The object to which this property blongs
REF_TYPE | VARCHAR2(4000 BYTE) | No | null | 4 | null | Type of object that this property belongs to
PROPERTY_ORDER | NUMBER | Yes | null | 5 | null | This is to handle a situation where multiple properties have a relevant order, or multiple properties have multiple values
PROP_KEY | VARCHAR2(4000 BYTE) | No | null | 6 | null | The keyname for this property
VALUE | VARCHAR2(4000 BYTE) | Yes | null | 7 | null | The value for this property
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