Table Glossary

Every hub_* table and its purpose.

All application tables are prefixed with hub_. RLS policies enforce project membership on every query.

Core entities

Table	Purpose
`hub_profiles`	User profile (extends auth.users)
`hub_projects`	Project container
`hub_project_members`	Membership & roles
`hub_initiatives`	Campaign / initiative within a project
`hub_assets`	Uploaded creative files
`hub_project_files`	Boards, canvas, text docs metadata
`hub_activity`	Activity feed events

Table	Purpose
`hub_comments`	Threaded asset comments
`hub_votes`	Approve, reject, emoji reactions
`hub_ideas`	Canvas idea nodes
`hub_share_links`	Public view-only tokens

Table	Purpose
`hub_tasks`	Task items
`hub_labels`	Team labels (design, marketing, tech)
`hub_task_labels`	Task ↔ label join
`hub_filters`	Saved filters (overdue, awaiting client)
`hub_sections`	Task list sections
`hub_task_comments`	Task discussion threads

Types are maintained in src/types/database.ts. Regenerate after schema changes:

bash

npx supabase gen types typescript --project-id rnyeonvbnrwephpviyzu > src/types/database.ts