Collection Contents Index SYSJARCOMPONENT system table SYSLOGIN system table pdf/chap15.pdf

Reference Manual
   CHAPTER 15. System Tables     

SYSJAVACLASS system table


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.


Collection Contents Index SYSJARCOMPONENT system table SYSLOGIN system table pdf/chap15.pdf