festival_signups — WeDance Architecture

Columns

Column	Type	Null	Default	Keys
id	uuid	no	gen_random_uuid()	PK
festival_id	uuid	no	—	→ festivals.id
dancer_id	uuid	yes	—	→ dancers.id
paid_amount	integer	no	0
stripe_session_id	text	yes	—
verified_ticket_holder	boolean	no	false
tickettailor_order_id	text	yes	—	unique
tickettailor_buyer_email	text	yes	—
verified_at	timestamp	yes	—
roster_visibility	text public_fullpublic_minimalhidden	no	"public_minimal"
created_at	timestamp	yes	now()

Value lists come from .$type<'a' | 'b'>() in the schema — enforced in TypeScript only, not by the database.

Keys, constraints & indexes

Unique

(tickettailor_order_id) festival_signups_tickettailor_order_id_unique
(festival_id, dancer_id) festival_dancer_unique

Indexes

No secondary indexes.

Foreign keys

festival_id → festivals.id
on delete no action
dancer_id → dancers.id
on delete no action

Used by

Code that reads or writes this table, found by static analysis of the tRPC routers and API handlers (including helpers they call).

tRPC procedures

REST & webhooks

GET /api/festivals
POST /api/stripe/webhook
POST /api/webhooks/tickettailor
ANY /mcp
ANY /mcp/public

Relations

Rendering diagram…

Diagram source

erDiagram
  dancers {
    uuid id PK
    text email UK
    text neon_auth_id UK
    text username UK
  }
  festival_signups {
    uuid id PK
    uuid festival_id FK
    uuid dancer_id FK
    text tickettailor_order_id UK
  }
  festivals {
    uuid id PK
    text slug UK
  }
  festivals ||--o{ festival_signups : "festival_id"
  dancers |o--o{ festival_signups : "dancer_id"

Columns #

Keys, constraints & indexes #