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