Ongale
Database workspace

Fintech workspace

Starting local SQLite…
Tables4
Columns20
Relationships3
Database accessRead only
query.sql

Tab moves to the next control. Control or Command and Enter runs the query.

4 tables · 3 relationships

Use the table header to select or drag a table. Arrow keys move the focused table; Shift moves it further. Scroll the diagram to pan. Selecting a table highlights its related tables and fields. Press Escape to clear selection.

Select a table to trace its relationships.

5
Columns in customers
ColumnType
idPKinteger
nametext
emailtext
countrytext
created_attext
6
Columns in accounts
ColumnType
idPKinteger
customer_idFKinteger
account_numbertext
currencytext
balancereal
statustext
6
Columns in transactions
ColumnType
idPKinteger
account_idFKinteger
merchant_idFKinteger
amountreal
descriptiontext
created_attext
3
Columns in merchants
ColumnType
idPKinteger
nametext
categorytext
100%

Query results
Result
0 files

No queries run yet.

    Preparing the sample database…

    Local sample · 500-row preview limit