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.