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