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