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