Database Schema

Auto-generated from DBML schema.

Tables

Hosts

Hosts that can execute operations

Columns:

Name	Type	Constraints
id	varchar	PK
created_at	datetime	NOT NULL
hostname	varchar	UNIQUE

Tasks

Tasks represent units of work

Columns:

Name	Type	Constraints
id	varchar	PK
created_at	datetime	NOT NULL
name	varchar
status	varchar

Operations

Operation tracking simulation workflow

Columns:

Name	Type	Constraints
id	varchar	PK
state	varchar	NOT NULL
state_counter	integer	NOT NULL
created_at	datetime	NOT NULL
created_by_id	varchar	NOT NULL
assigned_to_id	varchar

Indexes:

• None: state, state_counter (UNIQUE)

Relationships

• operations.assigned_to_id → hosts.id
• operations.created_by_id → tasks.id

---

Generated by dbml_jinja.py