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