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