PlayOps
Tables (15)
ai_jobs
- id — BIGINT — Primary key — NOT NULL
- changed_files — TEXT
- failed_execution_id — BIGINT — Foreign key → executions.id
- iterations_used — INT
- job_type — VARCHAR(30) — NOT NULL
- post_apply_verification_execution_id — BIGINT — Foreign key → executions.id
- post_apply_verification_status — VARCHAR(20)
- project_id — VARCHAR(100) — Foreign key → projects.project_id — NOT NULL
- requested_by — BIGINT — Foreign key → users.id
- reviewed_by — BIGINT — Foreign key → users.id
- status — VARCHAR(20) — NOT NULL
- target_spec_path — VARCHAR(500)
ai_provider_settings
- id — BIGINT — Primary key — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- claude_workspace_id — VARCHAR(255)
board_post_comments
- id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
- parent_id — BIGINT — Foreign key → board_post_comments.id
- post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
board_post_reactions
- id — BIGINT — Primary key — NOT NULL
- liked — BOOLEAN — NOT NULL
- rating — INT
- username — VARCHAR(100) — NOT NULL
- post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
board_posts
- id — BIGINT — Primary key — NOT NULL
- created_by — VARCHAR(100) — NOT NULL
- parent_id — BIGINT — Foreign key → board_posts.id
- pinned — BOOLEAN — NOT NULL
- title — VARCHAR(200) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- visible — BOOLEAN — NOT NULL
execution_case_results
- id — BIGINT — Primary key — NOT NULL
- case_title — TEXT
- duration_ms — INT
- error_message — TEXT
- execution_id — BIGINT — Foreign key → executions.id — NOT NULL
- spec_path — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
execution_schedules
- id — BIGINT — Primary key — NOT NULL
- days_of_week — VARCHAR(50) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- hour — INT — NOT NULL
- minute — INT — NOT NULL
- name — VARCHAR(200)
- project_id — VARCHAR(100) — Foreign key → projects.project_id — NOT NULL
- spec_path — VARCHAR(500)
executions
- id — BIGINT — Primary key — NOT NULL
- duration_ms — BIGINT
- failed_tests — INT
- passed_tests — INT
- project_id — VARCHAR(100) — Foreign key → projects.project_id — NOT NULL
- source — VARCHAR(30)
- spec_path — VARCHAR(500)
- started_at — TIMESTAMP
- status — VARCHAR(20) — NOT NULL
- total_tests — INT
projects
- project_id — VARCHAR(100) — Primary key — NOT NULL
- base_url — VARCHAR(500)
- project_name — VARCHAR(200) — NOT NULL
- runner_lifecycle — VARCHAR(20)
- server_type — VARCHAR(20)
scenario_case_settings
- id — BIGINT — Primary key — NOT NULL
- enabled — BOOLEAN — NOT NULL
- grep_filter — VARCHAR(500) — NOT NULL
- node_type — VARCHAR(20) — NOT NULL
- project_id — VARCHAR(100) — Foreign key → projects.project_id — NOT NULL
- spec_path — VARCHAR(500) — NOT NULL
slack_settings
- id — BIGINT — Primary key — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- webhook_url_encrypted — TEXT
test_suites
- id — BIGINT — Primary key — NOT NULL
- case_count — INT
- grep — TEXT
- name — VARCHAR(200) — NOT NULL
- project_id — VARCHAR(100) — Foreign key → projects.project_id — NOT NULL
- sequential — BOOLEAN
- spec_paths — TEXT
user_audit_logs
- id — BIGINT — Primary key — NOT NULL
- action — VARCHAR(30) — NOT NULL
- actor_user_id — BIGINT — Foreign key → users.id
- actor_username — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- target_user_id — BIGINT — Foreign key → users.id
- target_username — VARCHAR(100)
user_sessions
- id — BIGINT — Primary key — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- token — VARCHAR(100) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- last_login_at — TIMESTAMP
- role — VARCHAR(20) — NOT NULL
- username — VARCHAR(100) — NOT NULL