Relationships

The following syntax is used to generate a statement for each exported relationship.

CREATE REL relname 
   [DESC //description//] 
   CHI ctable 
   PAR ptable 
   [BASECREATORID basecreatorid] 
   (par-expr = chi-expr 
   [, par-expr = chi-expr]);

Keywords

The keywords correspond to values that can be specified for a relationship. For more information about an individual parameter, see Relationships.

REL relname
The name of the relationship, specified as a single string (relname), is required following the CREATE REL keyword.
DESC //description//
Description of the relationship, delimited by double slashes.
CHI ctable
The fully qualified name of the child table included in the relationship.
PAR ptable
The fully qualified name of the parent table included in the relationship.
BASECREATORID basecreatorid
Creator ID used to create the relationship, if generic.

The list of corresponding columns or expressions that participate in the relationship is enclosed in parentheses with the parent table expression on the left of the equal sign and the child table expression on the right. The entries must be separated by commas. If an expression exceeds the length of the line, a break is placed before or after the expression or the equal sign, or after a comma or any space within the expression. Continuation characters are not used.

The following parent table to child table mapping information is required for each pair of tables in the relationship.

par-expr
The parent table expression.
chi-expr
The child table expression.