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 A field containing the ID of the java class.
replaced_by A field that references the primary key field class_id.
creator A field containing 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 A field containing the ID of the jar file from which the class came.
type_id The field containing the id of the user type. The field references the 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 references the SYSJARCOMPONENT system table and contains the ID of the component.
create_time The field containing the creation time of the component.
update_time The field containing the last update time of the component.