Sybase Adaptive Server Anywhere - Page 1012

System tables diagram
994
Java system tables
Those system tables that are used for Java in the database are listed below.
Foreign key relations between tables are indicated by arrows: the arrow leads
from the foreign table to the primary table.
JAR_ID = JAR_ID
COMPONENT_ID = COMPONENT_ID
CLASS_ID = REPLACED_BY
SYSJAVACLASS
CLASS_ID <pk> smallint
REPLACED_BY <fk> smallint
JAR_ID smallint
CLASS_NAME long varchar
PUBLIC char(1)
COMPONENT_ID <fk> smallint
CREATE_TIME timestamp
UPDATE_TIME timestamp
CLASS_DESCRIPTOR long binary
REMARKS long varchar
SYSJAR
JAR_ID <pk> smallint
CREATOR smallint
JAR_NAME long varchar
JAR_FILE long varchar
CREATE_TIME timestamp
UPDATE_TIME timestamp
REMARKS long varchar
SYSJARCOMPONENT
COMPONENT_ID <pk> smallint
JAR_ID <fk> smallint
COMPONENT_NAME long varchar
COMPONENT_TYPE char(1)
CREATE_TIME timestamp
CONTENTS long binary
REMARKS long varchar
Other system tables
$ For information about the SQL Remote system tables, see
"SQL Remote system tables" on page 618 of the book Replication and
Synchronization Guide.