ERD Viewer
Load data
Node color
Foreign key count
Row count
Column count
None
Table visibility
Reset Filter
Tables and row count
Copy query
[ { "name": "a", "row_count": 10}, { "name": "b", "row_count": 20}, { "name": "c", "row_count":30}, { "name": "d", "row_count": 40}, { "name": "e", "row_count": 0} ]
Columns information
Copy query
[ { "name": "a", "column_name": "column 1", "data_type": "int" }, { "name": "a", "column_name": "column 2", "data_type": "int" }, { "name": "b", "column_name": "column 1", "data_type": "int" }, { "name": "b", "column_name": "column 2", "data_type": "int" }, { "name": "c", "column_name": "column 1", "data_type": "int" }, { "name": "c", "column_name": "column 2", "data_type": "int" }, { "name": "d", "column_name": "column 1", "data_type": "int" }, { "name": "d", "column_name": "column 2", "data_type": "int" }, { "name": "e", "column_name": "column 1", "data_type": "int" }, { "name": "e", "column_name": "column 2", "data_type": "int" } ]
Foreign keys
Copy query
[ { "target": "a", "source": "b" }, { "target": "b", "source": "c" }, { "target": "c", "source": "d" }, { "target": "d", "source": "a" }, { "target": "a", "source": "e" }, { "target": "b", "source": "e" }, { "target": "c", "source": "e" }, { "target": "d", "source": "e" } ]
Display
Download script