PILO

Tables (7)

file_review_decisions

  • id — UUID — Primary key — NOT NULL
  • review_file_id — UUID — Foreign key → review_files.id — NOT NULL
  • reviewed_by_user_id — UUID
  • status — VARCHAR(30) — NOT NULL
  • reviewed_at — TIMESTAMPTZ — NOT NULL

github_repositories

  • id — UUID — Primary key — NOT NULL
  • owner — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • url — TEXT — NOT NULL
  • connected_by_user_id — UUID
  • connected_at — TIMESTAMPTZ — NOT NULL

pr_review_sessions

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • created_by_user_id — UUID
  • status — VARCHAR(30) — NOT NULL
  • pr_purpose — TEXT
  • change_summary — TEXT
  • recommended_review_order — TEXT
  • caution_points — TEXT
  • reviewed_count — INTEGER — NOT NULL
  • total_file_count — INTEGER — NOT NULL
  • has_conflict — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

pull_requests

  • id — UUID — Primary key — NOT NULL
  • repository_id — UUID — Foreign key → github_repositories.id — NOT NULL
  • github_number — INTEGER — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • author_name — VARCHAR(255)
  • created_at_github — TIMESTAMPTZ
  • head_branch — VARCHAR(255)
  • base_branch — VARCHAR(255)
  • changed_files_count — INTEGER — NOT NULL
  • additions — INTEGER — NOT NULL
  • deletions — INTEGER — NOT NULL
  • commits_count — INTEGER — NOT NULL
  • description — TEXT
  • github_url — TEXT — NOT NULL
  • synced_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_files

  • id — UUID — Primary key — NOT NULL
  • flow_id — UUID — Foreign key → review_flows.id — NOT NULL
  • file_path — TEXT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • workflow_order — INTEGER — NOT NULL
  • additions — INTEGER — NOT NULL
  • deletions — INTEGER — NOT NULL
  • file_role — TEXT
  • change_reason — TEXT
  • change_summary — TEXT
  • review_points — TEXT
  • current_status — VARCHAR(30) — NOT NULL
  • position — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_flows

  • id — UUID — Primary key — NOT NULL
  • session_id — UUID — Foreign key → pr_review_sessions.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_submissions

  • id — UUID — Primary key — NOT NULL
  • session_id — UUID — Foreign key → pr_review_sessions.id — NOT NULL
  • submitted_by_user_id — UUID
  • submitted_by_github_login — VARCHAR(255)
  • submit_type — VARCHAR(30) — NOT NULL
  • review_body — TEXT — NOT NULL
  • review_result_summary — TEXT
  • file_review_results — JSONB — NOT NULL
  • github_submit_status — VARCHAR(30) — NOT NULL
  • github_review_id — VARCHAR(255)
  • error_message — TEXT
  • submitted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL