RELAY
SQL SCHEMA STUDIO
Template: Università & Ricerca (ISA, N-Aria, Composti)
Template: Biblioteca (Chen ER Draw.io)
Template: E-Commerce Store
Template: SaaS Multi-Tenant & RBAC
Template: Content Publishing CMS
OBJECTS POPUP
THEME: DARK
+ TABLE
+ WEAK ENTITY
+ ISA
+ RELATION
+ NOTE
JSON
IMPORT
+
-
100%
AUTO-LAYOUT
NOTATION: CHEN
ROUTING: SMART ORTHO
GRID: ON
SNAP: ON
+ ISA
NORMALIZZA FISICO
+ NOTE
IMPORT SQL / MERMAID
X: 0 Y: 0
|
100%
|
5 Entities
SCHEMA OBJECTS EXPLORER
✕
5 Tables, 24 Columns
Entity Name
Type
Columns
Primary Key
Incoming Foreign Keys
Actions
CLOSE
ADD NEW TABLE
✕
Table Name
Description / Comment (Optional)
Weak Entity (Double border notation)
CANCEL
SAVE TABLE
COLUMN DETAILS
✕
Column Name
Data Type
uuid
serial
bigserial
varchar(255)
varchar(100)
text
integer
bigint
boolean
timestamp
jsonb
Default Value (Optional)
Chen Attribute Representation
Normal Attribute (Regular Oval)
Key Attribute (Underlined Oval)
Multivalued Attribute (Double Oval)
Derived Attribute (Dashed Oval)
Composite Attribute (Branched Tree ⑂)
Sub-Attributes / Branched Fields
+ ADD SUB-FIELD
Primary Key
Unique
Nullable
DELETE
CANCEL
SAVE COLUMN
ADD RELATIONSHIP
✕
Source Table (Primary Key Owner)
Source Column
Target Table (Foreign Key Owner)
Relationship Name (Chen Diamond, e.g. SCRIVE, PRESTITO)
Target Column
QUICK CARDINALITY PRESETS
COPY
PASTE
⇄ SWAP
1:N (1,1)-(0,N)
1:N (0,1)-(1,N)
1:1 (1,1)-(1,1)
1:1 (0,1)-(1,1)
N:M (0,N)-(0,N)
N:M (1,N)-(1,N)
Source Cardinality
(1,1)
(0,1)
(1,N)
(0,N)
(1,1)
(0,1)
(1,N)
(0,N)
Target Cardinality
(0,N)
(1,N)
(1,1)
(0,1)
(1,1)
(0,1)
(1,N)
(0,N)
Relationship Attributes (Optional, comma-separated e.g. DataPrestito, OraPrestito)
Cardinality
One-to-Many (1:N)
One-to-One (1:1)
Many-to-Many (N:M)
On Delete
CASCADE
SET NULL
RESTRICT
NO ACTION
Identifying Relationship (Weak Entity Owner)
N-Ary Branches (3+ Participating Entities)
+ ADD BRANCH
CANCEL
CREATE RELATION
GENERALIZATION / SPECIALIZATION (ISA)
✕
Superclass / Parent Entity (Genitore)
Subclasses / Child Entities (Sottoclassi)
Coverage Constraint
Total (Totale — doppia linea)
Partial (Parziale — singola linea)
Exclusivity / Disjointness
Disjoint / Exclusive (d — Disgiunta)
Overlapping (o — Sovrapposta)
ℹ️
Visual PK Inheritance:
All subclass entities visually inherit the Primary Key of the superclass on the canvas and in physical DDL schemas.
DELETE
CANCEL
SAVE ISA HIERARCHY
IMPORT SCHEMA & REVERSE ENGINEERING
SQL DDL / MERMAID / JSON
✕
SQL DDL (CREATE / ALTER TABLE)
MERMAID ER (.mmd)
RELAY JSON (.json)
LOAD SQL SAMPLE
LOAD MERMAID
CHOOSE FILE...
Paste SQL DDL (Postgres / MySQL / SQLite) script or choose a file:
Ready
CANCEL
IMPORT TO CANVAS