Data Model

erDiagram
  VegasEvent ||--o{ TablePricing : has
  VegasEvent ||--o{ ImageMetadata : has
  VegasEvent ||--o{ EnrichmentStatus : has
  VegasEvent ||--o{ ArtistStats : enriches
  TablePricing ||--|{ TablePricingTier : contains
  ImageMetadata ||--o{ ImageSize : has
  ArtistStats ||--o{ StreamingLinks : includes
  ArtistStats ||--o{ SocialLinks : includes

  VegasEvent {
    string event_id PK
    date event_date
    string performer
    string venue
    string url
    datetime scraped_at
    string artist_bio
    string venue_url
  }

  TablePricing {
    string event_id FK
    string tier_id PK
    datetime fetched_at
    boolean is_available
  }

  TablePricingTier {
    string tier_id PK
    string tier_name
    integer min_spend
    integer pay_now
    integer guests
    integer available_count
  }

  ImageMetadata {
    string image_id PK
    string event_id FK
    string artist_slug
    string image_type
    string r2_bucket
  }

  ImageSize {
    string image_id FK
    string preset
    string r2_url
    integer width
    integer height
  }

  ArtistStats {
    string artist_slug PK
    string spotify_id
    string genres
    integer popularity
    integer follower_count
  }

  StreamingLinks {
    string artist_slug FK
    string spotify
    string apple_music
    string youtube
    string soundcloud
  }

  SocialLinks {
    string artist_slug FK
    string instagram
    string tiktok
    string beatport
    string resident_advisor
  }

  EnrichmentStatus {
    string event_id FK
    boolean spotify
    boolean tracklists
    boolean resident_advisor
    string errors
  }