poolim

Tables (6)

blockers

  • blocker_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • standup_id — BIGINT — Foreign key → standups.standup_id
  • title — VARCHAR(200) — NOT NULL
  • cause_log — TEXT — NOT NULL
  • urgency — blocker_urgency — NOT NULL
  • status — blocker_status — NOT NULL
  • is_sos — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ

members

  • member_id — BIGINT — Primary key — NOT NULL
  • team_id — BIGINT — Foreign key → teams.team_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — member_role — NOT NULL

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • recipient_member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • blocker_id — BIGINT — Foreign key → blockers.blocker_id
  • type — notification_type — NOT NULL
  • message — TEXT — NOT NULL
  • read_at — TIMESTAMPTZ
  • acknowledged_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

solutions

  • solution_id — BIGINT — Primary key — NOT NULL
  • blocker_id — BIGINT — Foreign key → blockers.blocker_id — NOT NULL
  • summary — TEXT — NOT NULL
  • reference_link — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

standups

  • standup_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • date — DATE — NOT NULL
  • did_yesterday — TEXT — NOT NULL
  • will_do_today — TEXT — NOT NULL
  • submitted_at — TIMESTAMPTZ — NOT NULL

teams

  • team_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • invite_code — VARCHAR(20) — NOT NULL
  • standup_deadline — TIME — NOT NULL
  • blocker_sla_hours — INT — NOT NULL
  • escalation_nudge_hours — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL