atoti.tables.Tables.schema#

property Tables.schema: object#

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

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 column 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" { non-null String "foo" nullable int "bar" } "Table b" { non-null int PK "bar" non-null LocalDate "baz" } "Table c" { non-null String PK "foo" non-null double PK "xyz" } "Table d" { non-null String PK "foo d" non-null 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”)"