Entity Relationship Diagram (ERD) with grid layout
WordPress ERD
Discourse ERD
Redmine ERD
Oracle Select
SELECT JSON_ARRAYAGG(
JSON_OBJECT(
'id' VALUE LOWER(table_name),
'name' VALUE LOWER(table_name),
'columns' VALUE (
SELECT JSON_ARRAYAGG(LOWER(column_name) ORDER BY column_id)
FROM all_tab_columns t1
WHERE t1.owner = t.owner AND t1.table_name = t.table_name)
)
) AS entities
FROM
all_tables t
WHERE
owner = 'YOUR_SCHEMA_NAME'
ORDER BY
table_name;