Confirmed Supabase details

Now I have a complete picture. This is a substantial institutional system. Let me create a structured plan and set up the database first. I'll search for the Supabase MCP tools to execute the schema.

I have all the reference files. Now let me load the supabase_execute_sql tool to set up the database schema, and create a todo list for this large project.

Loaded SQL tool

Now let me set up the complete database schema. I'll create all the tables with proper RLS policies as specified in the documentation.

Created core tables

Created core tables

Core tables created. Now let me create the remaining tables for events, polls, petitions, reports, and more.

Created events & polls tables

Created remaining tables

Now let me create the triggers for auto-creating profiles and updating timestamps:

Created triggers

Database schema is complete. Now let me move to the next task - setting up the Supabase client infrastructure. Let me first install the required packages and then copy the reference files.

Packages installed. Now let me copy the Supabase reference files and set up the infrastructure:

Now let me create the TypeScript types for the database and read the existing layout.tsx and globals.css:

Now let me create the database types and update the globals.css with UFH SRC Connect branding (maroon/gold university colors), and start building the app. Let me generate design inspiration first:

Now let me create the database types, update the design theme with UFH institutional colors (maroon primary), and start building the student app:

Now let me update the layout.tsx with proper metadata and move to building the Student App:

Now let me create the student app with authentication, home page, and all the main features. I'll start with the login page:

Now let me create the student layout with bottom navigation and the home page:

Now let me create the tickets pages (list and create), events pages, and the more section:

Now let me create the events pages:

Now let me create the societies pages and the "More" menu with polls, petitions, SRC structure, etc.:

Let me create the sign out route and a few more essential pages:

Now let me create the main page redirect and the SRC structure page:

Now let me move to the Admin Dashboard. First, let me update the todo and create the admin section:

Now let me create the Admin Dashboard with the two-step authentication (email + admin code):