name: db-schema-migration
version: "1.0.0"
description: >
  A reinforcement learning environment where an AI agent must migrate
  legacy database schemas to clean, normalized, production-grade designs.
  Tasks range from simple column renaming to full 3NF normalization.

tags:
  - openenv
  - database
  - schema-migration
  - sql
  - real-world

author: "openenv-challenge"

tasks:
  - name: easy
    description: "Rename poorly named tables and columns to follow conventions"
    difficulty: easy
    max_steps: 10

  - name: medium
    description: "Fix naming, correct data types, and add missing columns across two tables"
    difficulty: medium
    max_steps: 20

  - name: hard
    description: "Normalize a fully denormalized table into 3NF with foreign keys"
    difficulty: hard
    max_steps: 30

spaces:
  observation:
    type: object
    schema: Observation
    description: >
      Current schema state (list of tables with columns and types),
      target requirements, violation list, and step history.

  action:
    type: object
    schema: Action
    description: >
      A migration operation: rename_table, rename_column, add_column,
      drop_column, change_type, add_foreign_key, normalize_table, or done.

  reward:
    type: float
    range: [-1.0, 1.0]
    description: >
      Dense reward: +0.1 to +0.2 per correct step, -0.05 to -0.2 for
      wrong/destructive steps. Final score on DONE is the grader output (0.0-1.0).

api:
  reset: POST /reset
  step: POST /step
  state: GET /state

docker:
  port: 7860
  health_check: GET /health