challenge_id | integer | Unique numeric identifier for the coding challenge |
challenge_slug | string | URL-friendly slug used in challenge links |
challenge_name | string | Human-readable challenge title |
challenge_body | string | Full challenge description (HTML/Markdown) including input/output, examples, etc. |
challenge_kind | string | High-level content type (e.g., code, game) |
challenge_preview | string | One-sentence teaser shown in listings |
challenge_category | string | Top-level category such as ai, algorithms, databases |
challenge_created_at | ISO 8601 string | When the challenge was first created |
challenge_updated_at | ISO 8601 string | Most-recent metadata update time |
python3_template | string (nullable) | Complete Python 3 starter code supplied to users |
python3_template_head | string (nullable) | Header portion of the Python 3 template |
python3_template_tail | string (nullable) | Footer portion of the Python 3 template |
problem_statement | string | Canonical statement (often plain-text version of challenge_body) |
difficulty | float | Continuous difficulty score in \[0, 1] |
allowed_languages | JSON string | Array of language identifiers permitted for submissions |
input_format | string (nullable) | “Input Format” section verbatim |
output_format | string (nullable) | “Output Format” section verbatim |
sample_input | string (nullable) | Example stdin for the challenge |
sample_output | string (nullable) | Expected stdout for the sample input |
difficulty_tag | string | Discrete label (Easy, Medium, Hard) |
editorial_title | string | Title of the official editorial article |
editorial_content | string | Full HTML body of the editorial |
editorial_draft | boolean (0/1) | 1 if editorial is still a draft |
editorial_slug | string | URL-friendly slug for the editorial |
editorial_published_at | ISO 8601 string | Publication timestamp of the editorial |
editorial_statistics | JSON string | Engagement stats (participation, submissions, success rate) |
editorial_created_at | ISO 8601 string | Editorial first-save timestamp |
editorial_updated_at | ISO 8601 string | Last editorial edit time |
editorial_solution_kind | string | Tag for reference solution (e.g., tester, reference) |
editorial_solution_code | string | Full reference solution source code |
editorial_solution_language | string | Language of the reference solution |
editorial_solution_created_at | ISO 8601 string | Creation time of the reference solution |
editorial_solution_updated_at | ISO 8601 string | Last update time of the reference solution |
language | string | Detected programming language for this row |
