Skip to content

DB schema for hackathons #675

Open
Open

Description

@ShantKhatri

Summary

Set up the hackathon table that the map, archive, and streaks all depend on.

Contexts

This table is a hard dependency for some other issues(better to confirm first), so get the schema right before building on top of it.

Tasks

  • Create hackathon table per spec (name, dates, lat/lng, city, country, type, platform, url, verified, submitted_by, auto_expires)
  • Allow lat/lng to be null for online hackathons
  • Add indexes for date range and location queries

Acceptance Criteria

  • Migration runs cleanly
  • Online and offline hackathons both store correctly
  • Tests added
  • docs updated

Area

backend

Activity

  1. github-actions commented on Jul 12, 2026

    @github-actions
    Contributor

    Hi @ShantKhatri,

    Thanks for opening this issue.
    
    Please reply with one of the following areas so the issue can be routed to the appropriate team member:
    
    - /backend
    - /web
    - /mobile
    - /devops
    
    Once an area is selected, the corresponding label will be added automatically.
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    • Status
      Todo

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions