This repository contains a PostgreSQL database dump (planit_dump.sql) for the PlanIt project — a personal planning and recommendation app.

The dump includes the full schema and minimal seed data for development, testing, or educational purposes.

PlanIt is a full-stack web application built with:

• 🔹 Frontend: React
• 🔹 Backend: Node.js + Express
• 🔹 Database: PostgreSQL

This SQL dump was generated from a live Render database using PostgreSQL 16.

• ✅ Full table structure (CREATE TABLE, SEQUENCES, constraints)
• ✅ Foreign key relationships and validation checks
• ✅ Initial seed data (admin user + login)
• ❌ No owner/privileges
• ❌ No CREATE DATABASE or DROP DATABASE statements
• 📎 Format: Plain SQL with INSERT statements (not COPY), UTF-8 encoded

Make sure you have PostgreSQL 16 or later installed.

createdb planit

psql -d planit -f planit_dump.sql

This dump includes a sample admin account:

Email:    [email protected]
Password: (stored as bcrypt hash)
Role:     admin

⚠️ These credentials are for demonstration only. Do not use in production.

This diagram shows the structure of the database and relationships between tables:

This repository is intended for educational and demonstration purposes. You are welcome to use it as a reference or foundation for your own projects.

Suggestions and pull requests are welcome!

If you're building something similar and want to collaborate — feel free to reach out.