CREATE TABLE SYS.SYSJAVACLASS( class_id INT NOT NULL, replaced_by INT, creator UNSIGNED INT NOT NULL, jar_id INT, type_id UNSIGNED INT, class_name LONG VARCHAR NOT NULL, public CHAR(1) NOT NULL, component_id INT, create_time TIMESTAMP NOT NULL, update_time TIMESTAMP NOT NULL, class_descriptor LONG BINARY, remarks LONG VARCHAR, PRIMARY KEY ( class_id ), FOREIGN KEY ( replaced_by ) REFERENCES o.SYSJAVACLASS ( class_id ), FOREIGN KEY ( creator ) REFERENCES SYS.SYSUSERPERM ( user_id ), FOREIGN KEY REFERENCES SYS.SYSUSERTYPE FOREIGN KEY REFERENCES SYS.SYSJARCOMPONENT )
The SYSJAVACLASS system table contains all information related to Java classes.
class_id ID of the Java class.
replaced_by References the primary key field class_id.
creator user_id of the creator of the class. This field references the user_id field in the SYSUSERPERM system table to obtain the name of the user.
jar_id ID of the JAR file from which the class came.
type_id ID of the user type. The field references the SYSUSERTYPE system table to obtain the ID of the user.
class_name Name of the Java class.
public Whether the class is public or private.
component_id References the SYSJARCOMPONENT system table and contains the ID of the component.
create_time Creation time of the component.
update_time Last update time of the component.