Marklet

database schema

MCP Palli Ganesh Memories

PostgreSQL database schema for MCP Palli Ganesh Memories, featuring user profiles, festival years, albums, media management, and community stories with Row Level Security (RLS) policies.

Media Status

pending, approved, rejected

Roles

member, admin

Media Types

photo, video

Extension

pgcrypto

Database Tables

  1. 1profilesUser profiles with reference to auth.users, email, full name, and roles.
  2. 2festival_yearsFestival years tracking celebrations between 2000 and 2100 with titles and descriptions.
  3. 3albumsCollections grouped by festival years and album names.
  4. 4mediaPhotos and videos with storage paths, titles, captions, status, and approval tracking.
  5. 5storiesPublished stories and memories authored by users associated with festival years.

Includes helper functions such as is_admin() and handle_new_user() triggers, as well as Row Level Security (RLS) configurations for tables.