test1
Tables (12)
admin
- admin_id — INT
- user_id — INT — NOT NULL
- access_level — VARCHAR(50)
- created_at — TIMESTAMP
assignment
- assignment_id — INT
- classroom_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- due_date — DATE — NOT NULL
- instructor_id — INT — NOT NULL
board
- board_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
chat_message
- message_id — INT
- classroom_id — INT — NOT NULL
- user_id — INT — NOT NULL
- message — TEXT — NOT NULL
- sent_at — TIMESTAMP
classroom
- classroom_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
free_board
- post_id — INT
- board_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_date — TIMESTAMP
- author_id — INT — NOT NULL
instructor
- instructor_id — INT
- user_id — INT — NOT NULL
- department — VARCHAR(255)
notice_board
- post_id — INT
- board_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_date — TIMESTAMP
- author_id — INT — NOT NULL
seat
- seat_id — INT
- classroom_id — INT — NOT NULL
- student_id — INT — NOT NULL
- seat_number — VARCHAR(10) — NOT NULL
student
- student_id — INT
- user_id — INT — NOT NULL
- enrollment_date — DATE — NOT NULL
submission
- submission_id — INT
- assignment_id — INT — NOT NULL
- student_id — INT — NOT NULL
- content — TEXT
- submitted_date — TIMESTAMP
- grade — VARCHAR(10)
- feedback — TEXT
user
- user_id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('instructor', 'student', 'admin') — NOT NULL