final
Tables (7)
Untitled (users)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (email) — varchar(100) — NOT NULL
- Field2 (password) — varchar(255) — NOT NULL
- Field3 (name) — varchar(50)
- Field5 (role) — enum — ('PARENT', 'TEACHER', 'ADMIN')
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp
- Field3 (deleted_at) — timestamp
- Field (status) — enum — NOT NULL — ('ACTIVE', 'BLOCKED', 'DELETE')
Untitled (childen)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (name) — varchar(50) — NOT NULL
- Field2 (age) — smallint — NOT NULL
- Field (sex) — enum — NOT NULL — ('MALE', 'FEMALE')
- Field2 (birth_date) — timestamp — NOT NULL
- Field (created_at) — timestamp — NOT NULL
Untitled (user_child)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (child_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (ai_report)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (type) — enum — NOT NULL
- Field2 (summary) — text
- Field2 (content) — text
- Field (content_json) — json
- Field2 (updated_at) — timestamp
- Field (created_at) — timestamp — NOT NULL
- Key (children_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (scenatios_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (scenarios)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (name) — varchar(255) — NOT NULL
- Field2 (description) — text
- Field3 (icon_type) — varchar(50)
- Field4 (difficulty) — varchar(50)
- Field5 (estimated_time) — varchar(50)
- Field6 (steps) — json
- Field (created_at) — timestamp
- Field (updated_at) — timestamp
Untitled (scenario_results)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (score) — int — NOT NULL
- Field2 (duration) — int — NOT NULL
- Field (steps_completed) — json
- Field (mistakes) — json
- Field (ai_analysis) — json
- Field (completed_at) — timestamp — NOT NULL
- Field (created_at) — timestamp
- Key (children_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (scenarios_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (vr_codes)
- Key (id) — bigint — Primary key — NOT NULL — autoincrement
- Field (code) — varchar(5) — NOT NULL
- Field2 (expired_at) — timestamp
- Field3 (is_used) — boolean
- Field (created_at) — timestamp
- Key (children_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (scenarios_id) — bigint — Foreign key → Untitled.Key — NOT NULL