st

Tables (5)

Report (Records)

  • id — INT
  • student_id — INT — NOT NULL
  • teacher_id — INT — NOT NULL
  • subject_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Students

  • id — INT
  • user_id — INT — NOT NULL
  • grade — INT — NOT NULL
  • class — INT — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP

Subjects

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

Teacher_Subjects

  • id — INT
  • teacher_id — INT — NOT NULL
  • subject_id — INT — NOT NULL
  • can_read — BOOLEAN
  • can_write — BOOLEAN
  • created_at — TIMESTAMP

Users

  • id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — ENUM('admin', 'teacher') — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP