git-catch
Tables (8)
alert_rules
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — ON DELETE CASCADE
- repo_id — BIGINT — Foreign key → repos.id — NOT NULL — ON DELETE CASCADE
- event_type (Field) — VARCHAR(30) — NOT NULL
- branch_pattern — VARCHAR(255) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
branch_conflict_files
- id — BIGSERIAL — Primary key — NOT NULL
- branch_status_id — BIGINT — Foreign key → branch_statuses.id — NOT NULL — ON DELETE CASCADE
- conflict_branch_name — VARCHAR(255) — NOT NULL
- file_path — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
branch_statuses (Untitled)
- id — BIGSERIAL — Primary key — NOT NULL
- repo_id — BIGINT — Foreign key → repos.id — NOT NULL — ON DELETE CASCADE UNIQUE (repo_id, branch_name)
- branch_name — VARCHAR(255) — NOT NULL — UNIQUE (repo_id, branch_name)
- base_branch — VARCHAR(100) — NOT NULL
- activity_status — VARCHAR(20) — NOT NULL
- has_conflict_risk — BOOLEAN — NOT NULL
- ready_to_merge — BOOLEAN — NOT NULL
- last_commit_sha — VARCHAR(100)
- last_commit_message — TEXT
- last_commit_author — VARCHAR(100)
- last_commit_avatar_url — TEXT
- last_commit_at — TIMESTAMPTZ
- ahead_count — INTEGER — NOT NULL
- behind_count — INTEGER — NOT NULL
- changed_file_count — INTEGER — NOT NULL
- synced_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
notifications
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — ON DELETE CASCADE
- repo_id — BIGINT — Foreign key → repos.id — NOT NULL — ON DELETE CASCADE
- alert_rule_id — BIGINT — Foreign key → alert_rules.id — ON DELETE SET NULL
- branch_name — VARCHAR(255)
- event_type — VARCHAR(30) — NOT NULL — CHECK (event_type IN ('CONFLICT', 'STALE', 'READY_TO_MERGE'))
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
repos
- id — BIGSERIAL — Primary key — NOT NULL
- repo_owner — VARCHAR(100) — NOT NULL
- repo_name — VARCHAR(100) — NOT NULL
- default_branch — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_repos
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — ON DELETE CASCADE
- repo_id — BIGINT — Foreign key → repos.id — NOT NULL — ON DELETE CASCADE
- selected — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_tokens
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL — UNIQUE ON DELETE CASCADE
- access_token — TEXT — NOT NULL
- token_type — VARCHAR(30)
- scope — TEXT
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- github_id — BIGINT — NOT NULL — UNIQUE
- username (user_name) — VARCHAR(100) — NOT NULL
- avatar_url — TEXT
- email — VARCHAR(255)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL