ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| jar_id | INTEGER | NOT NULL | Primary key |
| creator | UNSIGNED INT | NOT NULL | |
| jar_name | LONG VARCHAR | NOT NULL | Unique index |
| jar_file | LONG VARCHAR | ||
| create_time | TIMESTAMP | NOT NULL | |
| update_time | TIMESTAMP | NOT NULL | |
| remarks | LONG VARCHAR |
jar_id A field containing the id of the jar file. This field also references the SYSJAR system table.
creator The is of the creator of the jar file.
jar_name The name of the jar file.
jar_file The file name of the jar file.
create_time The time the jar file was created.
update_time The time the jar file was last updated.
remarks A comment field.