SecondaryTables annotation and related types

SecondaryTables identifies other database tables to which an entity is related. This annotation is not available in version .7.

EGL package name

eglx.persistence.sql

Example use

Annotation detail
Record SecondaryTables type Annotation {
   targets=[RecordPart, HandlerPart, ExternalTypePart]
   }
   value SecondaryTable[];
end

Record SecondaryTable type Annotation {
   targets=[RecordPart, HandlerPart, ExternalTypePart]
   }
   name string;
   catalog string;
   schema string;
   pkJoinColumns PrimaryKeyJoinColumn[];
end

Record PrimaryKeyJoinColumns type Annotation {
   targets=[RecordPart, HandlerPart, ExternalTypePart, FieldMbr]
   }
   value PrimaryKeyJoinColumn[];
end

Record PrimaryKeyJoinColumn type Annotation {
   targets=[RecordPart, HandlerPart, ExternalTypePart, FieldMbr]
   }
   name string;
   referencedColumnName string;
end
Annotation fields
For the SecondaryTables annotation:
value
For the SecondaryTable annotation:
name
referencedColumnName
unique
insertable
table
For the PrimaryKeyJoinColumns annotation:
value
For the PrimaryKeyJoinColumn annotation:
name
referencedColumnName
Comments
Compatibility

Table 1. Compatibility
Target Issue
Java No issues.
JavaScript Database access is not supported.