Cardinality
| Toolbar label | Value | In the Code panel |
|---|
| Optional-One | (0,1) | zero..one or optional |
| Mandatory-One | (1,1) | one..one |
| Optional-Many | (0,N) | zero..many or optional, multi |
| Mandatory-Many | (1,N) | one..many or multi |
Generalization type
| Toolbar label | Meaning |
|---|
| Part.Excl. (p,e) | Partial: some parent occurrences belong to no child. Exclusive: at most one child. |
| Part.Over. (p,o) | Partial, overlapping: an occurrence can belong to several children. |
| Tot.Excl. (t,e) | Total, exclusive: every occurrence belongs to exactly one child. |
| Tot.Over. (t,o) | Total, overlapping: every occurrence belongs to at least one child. |
Code panel
entity STUDENT {
StudentId (id),
Phone (optional, multi)
}
relationship EXAM (
STUDENT: zero..many,
COURSE: zero..many
)
PERSON <= {
STUDENT,
TEACHER
} (partial, exclusive)
Column data types
INTEGER, TEXT, VARCHAR(100), REAL, NUMERIC, DATE, DATETIME, BLOB, JSON, BOOLEAN.