Relational Data Architecture • Personal Finance • AI-Assisted Engineering
EternalPlan — Event Budget & Cashflow Due-Date Planner
A web application built to solve a key data modeling problem in event budgeting: expenses are rarely paid in single sums, but rather across dozens of specific milestone deadlines (deposits, installment dates, and final vendor balances). EternalPlan models expenses chronologically against scheduled income dates so users know whether their cash reserves will be solvent on the exact dates payments come due.
Relational Data Architecture (PostgreSQL Schema)
1 : N Relational Model
budget_categories
Table
PK id
uuid
FK user_id
uuid
category_name
varchar(50)
target_allocation
numeric(10,2)
payment_milestones
Table
PK id
uuid
FK category_id
uuid
due_date
date
amount_due
numeric(10,2)
payment_status
varchar(20)
scheduled_incomes
Table
PK id
uuid
FK user_id
uuid
paycheck_date
date
expected_amount
numeric(10,2)
- ▸ Relational Data Architecture: Designed relational schema in PostgreSQL (Supabase) to model one-to-many relationships across budget categories, payment milestones, and scheduled income dates.
- ▸ Chronological Cashflow Engine: Solves the event cashflow dilemma by projecting cumulative obligations against scheduled bi-weekly income, identifying deficit dates before contracts are signed.
- ▸ AI Budget Scanner (Gemini API): Evaluates categorized line items to recommend commonly overlooked contingency expenses like service charges, alterations, and setup fees.
- ▸ AI-Assisted Workflow: Leveraged modern generative AI tools to accelerate schema validation, component architecture, and rapid feature iteration.
PostgreSQL (Supabase)
SQL & Relational Modeling
JavaScript (ES6+)
Gemini API
HTML5 / CSS3