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