BaB

Tables (3)

match_participants

  • match_id — BIGINT — Primary key — NOT NULL
  • user_id — UUID — Primary key — NOT NULL
  • role — TEXT — NOT NULL
  • state — TEXT — NOT NULL
  • joined_at — TIMESTAMPTZ

matches

  • id — BIGSERIAL
  • host_id — UUID — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT
  • scheduled_at — TIMESTAMPTZ — NOT NULL
  • max_participants — INT — NOT NULL
  • status — TEXT — NOT NULL
  • lon — DOUBLE
  • lat — DOUBLE
  • created_at — TIMESTAMPTZ

profiles

  • id — UUID
  • nickname — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ