ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| class_id | INTEGER | NOT NULL | Primary key |
| replaced_by | INTEGER | Foreign key references SYSJAVACLASSES. class_id | |
| creator | UNSIGNED INT | NOT NULL | Foreign key references SYSUSERPERM.user_id |
| jar_id | INTEGER | ||
| type_id | SMALLINT | Foreign key references SYSUSERTYPE | |
| class_name | LONG VARCHAR | NOT NULL | |
| public | CHAR(1) | NOT NULL | |
| component_id | INTEGER | Foreign key references 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 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 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 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.