COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
SCHEMA_ID_FK NUMBER No null 2 null Schema in which this object belongs //PARENTFIELD
GROUP_NAME VARCHAR2(4000 BYTE) Yes null 3 null Name of the group //OBJECTNAME
GROUP_FLAG CHAR(1 BYTE) Yes null 4 null This is a flag to signify a group or a role. If this is 'R' it means the group is known as a Role. Any other value means it is known as a group.
NATIVE_SQL CLOB Yes null 5 null SQL Used to generate this object at source
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 6 null Unique id for this object at source
COMMENTS VARCHAR2(4000 BYTE) Yes null 7 null null
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