Events Plugin

interface Event {
  id: string;                    // Unique identifier
  title: string;                 // Event name
  description: string;           // Event details
  location: {
    name: string;                // Venue name
    address?: string;            // Physical address
    coordinates?: [number, number]; // Lat/lng for map
  };
  startTime: number;             // Unix timestamp
  endTime: number;               // Unix timestamp
  organizer: string;             // Nostr pubkey
  capacity?: number;             // Max attendees
  badge?: BadgeTemplate;         // Badge to issue on check-in
  price?: {
    amount: number;              // In sats
    paymentRequired: boolean;    // Pay before or at check-in
  };
}

POST   /api/plugins/events              # Create event
GET    /api/plugins/events              # List events
GET    /api/plugins/events/:id          # Get event details
PUT    /api/plugins/events/:id          # Update event
DELETE /api/plugins/events/:id          # Delete event
POST   /api/plugins/events/:id/checkin  # Check in attendee
GET    /api/plugins/events/:id/attendees # List attendees

┌─────────────┐     ┌──────────────┐     ┌─────────────┐
│   Attendee  │────▶│  QR/NFC Scan │────▶│  Validate   │
│  (LaWallet) │     │              │     │  Identity   │
└─────────────┘     └──────────────┘     └──────┬──────┘
                                               │
                    ┌──────────────┐     ┌──────▼──────┐
                    │ Badge Issued │◀────│   Check-in  │
                    │  (Nostr)     │     │  Recorded   │
                    └──────────────┘     └─────────────┘

CREATE TABLE events (
  id UUID PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  description TEXT,
  location_name VARCHAR(255),
  location_address VARCHAR(500),
  location_lat DECIMAL(10, 8),
  location_lng DECIMAL(11, 8),
  start_time TIMESTAMP NOT NULL,
  end_time TIMESTAMP NOT NULL,
  organizer_pubkey VARCHAR(64) NOT NULL,
  capacity INTEGER,
  badge_template_id UUID REFERENCES badge_templates(id),
  price_sats INTEGER,
  created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE event_checkins (
  id UUID PRIMARY KEY,
  event_id UUID REFERENCES events(id),
  attendee_pubkey VARCHAR(64) NOT NULL,
  checked_in_at TIMESTAMP DEFAULT NOW(),
  method VARCHAR(20), -- 'qr', 'nfc', 'geo'
  badge_event_id VARCHAR(64), -- Nostr event ID of issued badge
  UNIQUE(event_id, attendee_pubkey)
);