acacia-erd

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;