atoti.tables.Tables.schema#

property Tables.schema: object#

Schema of the tables represented as a Mermaid entity relationship diagram.

Note

If JupyterLab < 4.1 is installed, Graphviz will be used instead of Mermaid so Graphviz >= 6.0 must be installed.

Each table is represented with 3 or 4 columns:

  1. whether the column’s default_value is None (denoted with nullable) or not

  2. the colum data_type

  3. (optional) whether the column is part of the table keys (denoted with PK) or not

  4. the column name

Example

erDiagram "Table a" { _ String "foo" nullable int "bar" } "Table b" { _ int PK "bar" _ LocalDate "baz" } "Table c" { _ String PK "foo" _ double PK "xyz" } "Table d" { _ String PK "foo_d" _ double PK "xyz_d" nullable float "abc_d" } "Table a" }o--o| "Table b" : "`bar` == `bar`" "Table a" }o..o{ "Table c" : "`foo` == `foo`" "Table c" }o--|| "Table d" : "(`foo` == `foo_d`) & (`xyz` == `xyz_d`)"