SQL Integrity Checker Tool
Schema (JSON format):
{ "users": { "id": {"primary": true, "not_null": true}, "email": {"unique": true, "not_null": true} }, "orders": { "id": {"primary": true, "not_null": true}, "user_id": {"foreign": "users.id", "not_null": true} } }
Data (JSON format):
{ "users": [ {"id": 1, "email": "a@example.com"}, {"id": 2, "email": "b@example.com"}, {"id": 2, "email": "c@example.com"} ], "orders": [ {"id": 100, "user_id": 1}, {"id": 101, "user_id": 3}, {"id": 102, "user_id": null} ] }
Check Integrity