Database schema

Physical tables with SQL types, constraints and column-level foreign keys.

1 database schema examples

Orders database schema

Three physical tables with SQL types, constraint chips and column-level foreign keys.

Unlike an ER diagram, the foreign-key lines anchor column to column and carry the referential action. The one cascading delete is drawn in the accent, and the table it cascades into gets a tinted header.

Open in the editor