COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 null
INDEX_ID_FK NUMBER No null 2 null The index to which this detail belongs. //PARENTFIELD
COLUMN_ID_FK NUMBER No null 3 null null
INDEX_PORTION NUMBER Yes null 4 null To support indexing on part of a field
DETAIL_ORDER NUMBER No null 5 null null
SECURITY_GROUP_ID NUMBER No 0 6 null null
CREATED_ON DATE No sysdate 7 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 8 null null
LAST_UPDATED_ON DATE Yes null 9 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 10 null null