Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
---|---|---|---|
class_id |
INTEGER |
NOT NULL |
Primary key |
replaced_by |
SMALLINT |
Foreign key references SYS.SYSJAVACLASSES. class_id |
|
creator |
SMALLINT |
NOT NULL |
Foreign key references SYS.SYSUSERPERM. user_id |
jar_id |
INTEGER |
||
type_id |
SMALLINT |
Foreign key references SYS.SYSUSERTYPE |
|
class_name |
LONG VARCHAR |
NOT NULL |
|
public |
CHAR(1) |
NOT NULL |
|
component_id |
INTEGER |
Foreign key references SYS.SYSJARCOMPONENT |
|
create_time |
TIMESTAMP |
NOT NULL |
|
update_time |
TIMESTAMP |
NOT NULL |
|
class_descriptor |
LONG BINARY |
||
remarks |
LONG VARCHAR |
The SYSJAVACLASS system table contains all information related to Java classes.
class_id This field contains the id of the java class. Also the primary key for the table.
replaced_by A field that references the primary key field, class_id.
creator This field contains the user_id of the creator of the class. This field references the user_id field in the SYS.SYSUSERPERM system table to obtain the name of the user.
jar_id This field contains the id of the jar file from which the class came.
type_id This field contains the id of the user type. This field references the SYS.SYSUSERTYPE system table to obtain the id of the user.
class_name This field contains the name of the Java class.
public This field determines whether or not the class is public or private.
component_id This field, which references the SYS.SYSJARCOMPONENT system table contains the id of the component.
create_time Contains the creation time of the component.
update_time Contains the last update time of the component.
class_descriptor The byte code of the jar file.
remarks Contains a comment string.