Contents Index SYSIXCOL system table SYSJARCOMPONENT system table

ASA SQL Reference
  System Tables

SYSJAR system table


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.


Contents Index SYSIXCOL system table SYSJARCOMPONENT system table