ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| component_id | INTEGER | NOT NULL | Primary key |
| jar_id | INTEGER | Foreign key references SYSJAR | |
| component_name | LONG VARCHAR | ||
| component_type | CHAR(1) | ||
| create_time | TIMESTAMP | NOT NULL | |
| contents | LONG BINARY | ||
| remarks | LONG VARCHAR |
component_id The primary key containing the id of the component.
jar_id A field containing the ID number of the jar. This field also references the SYSJAR system table.
component_name The name of the component.
component_type The type of the component.
create_time A field containing the creation time of the component.
contents The byte code of the jar file.
remarks A comment field.