Relations
Relationship lines visualize and create FKs in the ERD. NeoSQL provides separate identifying and non-identifying relationship modes.
Create Relationship Lines
Select identifying or non-identifying relationship mode from the left toolbar, then select the parent table and child table in order. In relationship mode, connectable and non-connectable nodes are visually distinguished.
The parent table must have a PK. In an all-Schema ERD, you can create relationships with tables from another Schema in the same Database, but relationships cannot cross different Databases.
Select relationship mode
Select the non-identifying or identifying relationship icon.
Select the parent table
Select the referenced table first.
Select the child table
Select the table that will have FK columns and confirm the required column mapping.
Identifying and Non-Identifying Relationships
Both relationship types create FKs, but their meaning differs. Use identifying relationships when the parent key is part of the child's identifier, and non-identifying relationships when the child has an independent identifier while referencing the parent.
| Type | Identifying | Non-Identifying |
|---|---|---|
| Icon |  Blue relationship |  Green relationship |
| Meaning | The parent is part of the child's identity. | The child has an independent PK and references the parent. |
| Example | Order and order details | Member and order |
| When to use | When the child identity cannot exist without the parent | When the child identity remains stable even if the parent changes |
Creation Result
When you create a relationship line, FK information is added to the child table and can be reviewed in the Foreign Keys and Constraints areas of the detail panel. When a table that already has FKs is imported from the DB, relationship lines are rendered from imported key information.
System Schema tables and tables marked as deleted have restricted structural operations such as relationship creation, column paste, and deletion.