Chapter 15 System Tables
1019
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.