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