referential-integrity

AI-powered synthetic data generation — structured tables, unstructured documents, multi-provider LLM support, referential integrity, and code-gen mode for millions of rows

🤝 Enforce referential and data integrity in Cloud Firestore using triggers

Bank Database made in SQL

A Convex component for cascading deletes — delete a record and all its dependents automatically, in the correct order.

MySQL archiver for related tables: archive, copy, or purge a parent row with every child row, across foreign keys and application-managed relations. Dependency-ordered, verified before delete, crash-recoverable

University Database made in SQL

eZ Publish Legacy extension allowing to check integrity of data in the database and filesystem storage

Command-line program that scans NMDC database for referential integrity violations

Implementation of referential integrity constraint when it is not a primary key-foreign key relationship

SocialBook Database made in SQL, with comprehensive documentation.

Herramienta de línea de comandos para analizar y medir la calidad de la integridad referencial en bases de datos relacionales.

The Car Rental System is an automated platform that allows customers to browse available vehicles, make online reservations, and manage bookings with ease. It provides real-time vehicle availability and secure payment options, streamlining the rental process for both users and administrators.

PHP backend for dbrel-viz that turns your MySQL schema into an interactive relationship graph.

Foreign keys for Spacetime: restrict/cascade/set-null deletes with previews, multi-column unique, orphan check & repair, cursor and live pagination. Rust & C# drop-ins + a TypeScript submodule.

Online retail management system

BCNF-normalized PostgreSQL database for a multi-vendor e-commerce marketplace: migrations, seed data, query portfolio, logic layer (views, functions, audit trigger, transactional procedure), indexes, roles and row-level security, with a data dictionary and ERD. Rebuilds from scratch with one command. CIT 406 term project.

Comprehensive SQL script performing updates, inserts, queries, and managing referential integrity for a restaurant database.

Structured data-cleaning pipeline built on the Olist e-commerce dataset, focusing on reproducible ingestion, schema profiling, and light standardization using Python and pandas. Emphasizes clear pipeline stages, auditability, and portfolio-ready documentation.

Directus hook that blocks deletes which would orphan referenced records

PostgreSQL sales-analytics warehouse consolidating CRM and ERP CSV extracts into a star-schema reporting layer. Medallion architecture (Bronze → Silver → Gold) with data-quality rules, deduplication, and gold views (dim_customers, dim_products, fact_sales).