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 The schema to which this object belongs //PARENTFIELD
NAME VARCHAR2(4000 BYTE) No null 3 null Synonym name //OBJECTNAME
SYNONYM_FOR_ID NUMBER No null 4 null What object this is a synonym for
FOR_OBJECT_TYPE VARCHAR2(4000 BYTE) No null 5 null The type this is a synonym for (e.g. INDEX)
PRIVATE_VISIBILITY CHAR(1 BYTE) Yes null 6 null Visibility - Private or Public. If Private_visibility = 'Y' means this is a private synonym. Anything else means it is a public synonym
NATIVE_SQL CLOB Yes null 7 null The SQL used to create this object at source
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 8 null An identifier for this object at source.
COMMENTS VARCHAR2(4000 BYTE) Yes null 9 null null
SECURITY_GROUP_ID NUMBER No 0 10 null null
CREATED_ON DATE No sysdate 11 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 12 null null
LAST_UPDATED_ON DATE Yes null 13 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 14 null null