> For the complete documentation index, see [llms.txt](https://grouple.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://grouple.gitbook.io/docs/supabase/database-schema.md).

# Database Schema

<figure><img src="/files/gzpp1SOXazUGeHEEf0xK" alt=""><figcaption></figcaption></figure>

### Entity Relationship Overview

```
countries → cities → neighbourhoods
                 ↓
merchants (subscription_plans) → venues → venue_amenities (amenities)
                                       → venue_cuisines (cuisines)
                                       → venue_knowledge
                                       → venue_leads ← enquiries ← customers
                                                    ↓
                                                proposals → beos
                                                         → commission_settlements
```

### [​](https://grouple.mintlify.app/supabase/schema#core-tables)Core Tables <a href="#core-tables" id="core-tables"></a>

#### [​](https://grouple.mintlify.app/supabase/schema#customers)`customers` <a href="#customers" id="customers"></a>

Registered end-customers (event planners).

<table><thead><tr><th width="209.8328857421875">Column</th><th width="192.4658203125">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>supabase_user_id</td><td>uuid</td><td>Links to Supabase Auth</td></tr><tr><td>first_name, last_name</td><td>text</td><td></td></tr><tr><td>email</td><td>text</td><td>NOT NULL</td></tr><tr><td>phone</td><td>text</td><td></td></tr><tr><td>company_name</td><td>text</td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#merchants)`merchants` <a href="#merchants" id="merchants"></a>

Venue owners / managers.

<table><thead><tr><th>Column</th><th width="188.700927734375">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>supabase_user_id</td><td>uuid</td><td>Links to Supabase Auth</td></tr><tr><td>first_name, last_name</td><td>text</td><td></td></tr><tr><td>email</td><td>text</td><td>NOT NULL</td></tr><tr><td>role</td><td>text</td><td></td></tr><tr><td>company_name</td><td>text</td><td></td></tr><tr><td>logo_url</td><td>text</td><td></td></tr><tr><td>onboarding_completed</td><td>boolean</td><td></td></tr><tr><td>plan_id</td><td>text</td><td>FK → subscription_plans</td></tr><tr><td>currency_code</td><td>text</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#venues)`venues` <a href="#venues" id="venues"></a>

Individual venues listed by merchants.

<table><thead><tr><th width="215.20654296875">Column</th><th width="176.7247314453125">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>merchant_id</td><td>uuid</td><td>FK → merchants</td></tr><tr><td>venue_name</td><td>text</td><td>NOT NULL</td></tr><tr><td>address, city_id, neighbourhood_id</td><td></td><td>Location</td></tr><tr><td>seated_capacity, standing_capacity</td><td>integer</td><td></td></tr><tr><td>price_min, price_max</td><td>numeric</td><td></td></tr><tr><td>operating_hours</td><td>jsonb</td><td></td></tr><tr><td>venue_type_id</td><td>uuid</td><td>FK → venue_types</td></tr><tr><td>currency_code</td><td>text</td><td></td></tr><tr><td>is_active</td><td>boolean</td><td></td></tr><tr><td>public_token</td><td>text</td><td>For public-facing links</td></tr><tr><td>is_featured</td><td>boolean</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#enquiries)`enquiries` <a href="#enquiries" id="enquiries"></a>

Customer group booking requests (RFQs).

<table><thead><tr><th width="225.3741455078125">Column</th><th width="139.44244384765625">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>rfq_number</td><td>integer</td><td>Auto-incremented sequence</td></tr><tr><td>event_date</td><td>date</td><td>NOT NULL</td></tr><tr><td>time_slot</td><td>time</td><td>NOT NULL</td></tr><tr><td>group_size</td><td>integer</td><td>NOT NULL</td></tr><tr><td>budget_tier</td><td>enum</td><td>Economy / Standard / Premium / Luxury</td></tr><tr><td>city_id, neighbourhood_id</td><td>uuid</td><td></td></tr><tr><td>event_category_id</td><td>uuid</td><td>FK → event_categories</td></tr><tr><td>cuisine_preference_id</td><td>uuid</td><td>FK → cuisines</td></tr><tr><td>venue_type_id</td><td>uuid</td><td>FK → venue_types</td></tr><tr><td>customer_id</td><td>uuid</td><td>FK → customers</td></tr><tr><td>currency_code</td><td>text</td><td>Auto-synced from city</td></tr><tr><td>status</td><td>text</td><td>open / confirmed</td></tr><tr><td>confirmed_proposal_id</td><td>uuid</td><td>Set on confirmation</td></tr><tr><td>confirmed_venue_id</td><td>uuid</td><td>Set on confirmation</td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#venue_leads)`venue_leads` <a href="#venue_leads" id="venue_leads"></a>

Junction between an enquiry and a specific venue — one lead per venue per enquiry.

<table><thead><tr><th width="237.53558349609375">Column</th><th width="146.21044921875">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>enquiry_id</td><td>uuid</td><td>FK → enquiries</td></tr><tr><td>venue_id</td><td>uuid</td><td>FK → venues</td></tr><tr><td>merchant_id</td><td>uuid</td><td>FK → merchants</td></tr><tr><td>status</td><td>enum</td><td>pending / accepted / declined / connected / closed_won / closed_lost</td></tr><tr><td>merchant_rfq_number</td><td>integer</td><td>Auto-set by trigger</td></tr><tr><td>proposed_event_date</td><td>date</td><td>Merchant can counter-propose</td></tr><tr><td>proposed_group_size</td><td>integer</td><td></td></tr><tr><td>is_counter_offer</td><td>boolean</td><td></td></tr><tr><td>accepted_at, declined_at, closed_won_at, closed_lost_at</td><td>timestamp</td><td></td></tr><tr><td>is_read</td><td>boolean</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#proposals)`proposals` <a href="#proposals" id="proposals"></a>

Proposals sent by merchants in response to leads.

<table><thead><tr><th width="207.91497802734375">Column</th><th width="141.34075927734375">Type</th><th>Notes</th></tr></thead><tbody><tr><td>id</td><td>uuid</td><td>Primary key</td></tr><tr><td>venue_lead_id</td><td>uuid</td><td>FK → venue_leads</td></tr><tr><td>venue_id</td><td>uuid</td><td>FK → venues</td></tr><tr><td>title</td><td>text</td><td></td></tr><tr><td>status</td><td>enum</td><td>draft / sent / viewed / confirmed / declined / expired</td></tr><tr><td>offer_valid_until</td><td>date</td><td></td></tr><tr><td>details</td><td>text</td><td>AI-generated or manual</td></tr><tr><td>package_inclusions</td><td>text[]</td><td></td></tr><tr><td>amount, service_fee, discount, total</td><td>numeric</td><td></td></tr><tr><td>price_type</td><td>enum</td><td>Per Person / Per Bottle / Per Item / Per Event</td></tr><tr><td>payment_terms, venue_policies</td><td>text</td><td></td></tr><tr><td>ai_generated</td><td>boolean</td><td></td></tr><tr><td>public_token</td><td>text</td><td>For public-facing proposal links</td></tr><tr><td>signed_by_name, signed_at, signature_base64</td><td></td><td>Digital signature</td></tr><tr><td>selected_packages</td><td>jsonb</td><td></td></tr><tr><td>currency_code</td><td>text</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#commission_settlements)`commission_settlements` <a href="#commission_settlements" id="commission_settlements"></a>

Auto-created when a proposal is confirmed.

<table><thead><tr><th width="241.84588623046875">Column</th><th width="147.6290283203125">Type</th><th>Notes</th></tr></thead><tbody><tr><td>proposal_id</td><td>uuid</td><td>FK → proposals</td></tr><tr><td>merchant_id</td><td>uuid</td><td>FK → merchants</td></tr><tr><td>applied_commission_rate</td><td>numeric</td><td>From subscription plan</td></tr><tr><td>status</td><td>enum</td><td>unpaid / pending_verification / paid / cancelled</td></tr><tr><td>is_paid</td><td>boolean</td><td></td></tr><tr><td>receipt_url, invoice_url</td><td>text</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#beos)`beos` <a href="#beos" id="beos"></a>

Banquet Event Orders linked to confirmed proposals.

<table><thead><tr><th width="214.880126953125">Column</th><th width="149.40496826171875">Type</th><th>Notes</th></tr></thead><tbody><tr><td>proposal_id</td><td>uuid</td><td>FK → proposals</td></tr><tr><td>setup_time</td><td>text</td><td></td></tr><tr><td>table_setup</td><td>text</td><td></td></tr><tr><td>staffing_requirements</td><td>text</td><td></td></tr><tr><td>av_requirements</td><td>text</td><td></td></tr><tr><td>sales_contact, venue_mobile</td><td>text</td><td></td></tr><tr><td>miscellaneous_notes</td><td>text</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#venue_knowledge)`venue_knowledge` <a href="#venue_knowledge" id="venue_knowledge"></a>

PDF menus and brochures uploaded by merchants for AI extraction.

<table><thead><tr><th width="181.4549560546875">Column</th><th width="142.23443603515625">Type</th><th>Notes</th></tr></thead><tbody><tr><td>venue_id</td><td>uuid</td><td>FK → venues</td></tr><tr><td>merchant_id</td><td>uuid</td><td>FK → merchants</td></tr><tr><td>file_path</td><td>text</td><td>NOT NULL — path in Supabase Storage</td></tr><tr><td>extracted_data</td><td>jsonb</td><td>AI-extracted content</td></tr><tr><td>status</td><td>text</td><td></td></tr></tbody></table>

#### [​](https://grouple.mintlify.app/supabase/schema#support-tables)Support Tables <a href="#support-tables" id="support-tables"></a>

<table><thead><tr><th width="281.8798828125">Table</th><th>Purpose</th></tr></thead><tbody><tr><td><code>cities</code></td><td>City list with default currency</td></tr><tr><td><code>countries</code></td><td>Country reference data</td></tr><tr><td><code>neighbourhoods</code></td><td>Neighbourhood lookup (FK → cities)</td></tr><tr><td><code>amenities</code></td><td>Amenity types (e.g. “Private Room”, “AV Equipment”)</td></tr><tr><td><code>cuisines</code></td><td>Cuisine types</td></tr><tr><td><code>event_categories</code></td><td>Event types</td></tr><tr><td><code>venue_types</code></td><td>Venue type categories</td></tr><tr><td><code>subscription_plans</code></td><td>Merchant plan definitions</td></tr><tr><td><code>exchange_rates</code></td><td>Currency exchange rates (updated by Edge Function)</td></tr><tr><td><code>lead_response_times</code></td><td>Tracks how quickly merchants respond to leads</td></tr><tr><td><code>lead_values</code></td><td>Estimated booking value per lead</td></tr><tr><td><code>merchant_lead_counter</code></td><td>Tracks last RFQ number per merchant</td></tr><tr><td><code>merchant_analytics_v3</code></td><td>Materialised view for analytics dashboard</td></tr><tr><td><code>merchant_commission_ledger</code></td><td>View for commission tracking</td></tr></tbody></table>

### [​](https://grouple.mintlify.app/supabase/schema#enums)Enums <a href="#enums" id="enums"></a>

<table><thead><tr><th width="204.021484375">Enum</th><th>Values</th></tr></thead><tbody><tr><td><code>budget_tier</code></td><td>Economy, Standard, Premium, Luxury</td></tr><tr><td><code>lead_status</code></td><td>pending, accepted, declined, connected, closed_won, closed_lost</td></tr><tr><td><code>proposal_status</code></td><td>draft, sent, viewed, confirmed, declined, expired</td></tr><tr><td><code>commission_status</code></td><td>unpaid, pending_verification, paid, cancelled</td></tr><tr><td><code>price_type</code></td><td>Per Person, Per Bottle, Per Item, Per Event</td></tr><tr><td><code>currency_code_type</code></td><td>USD, AED, GBP, INR, EUR</td></tr><tr><td><code>occasion_type</code></td><td>Corporate, Birthday Party, Conferences/Seminars, Gala Dinners, and 13 more</td></tr></tbody></table>

[<br>](https://grouple.mintlify.app/supabase/overview)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://grouple.gitbook.io/docs/supabase/database-schema.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.