Chapter 15 System Tables
1021
SYSJAVACLASS system table
Column name Column type
Column
constraint
Table
constraints
class_id INTEGER NOT NULL Primary key
replaced_by INTEGER Foreign key
references
SYSJAVACLAS
SES. class_id
creator UNSIGNED INT NOT NULL Foreign key
references
SYSUSERPER
M.user_id
jar_id INTEGER
type_id UNSIGNED INT Foreign key
references
SYSUSERTYPE
class_name LONG
VARCHAR
NOT NULL
public CHAR(1) NOT NULL
component_id INTEGER Foreign key
references
SYSJARCOMP
ONENT
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 SYSUSERPERM system table to
obtain the name of the user.