testmodel
Tables (18)
all_account
- account_id — INT
- user_id — INT — NOT NULL
- account_type — ENUM('student', 'professor') — NOT NULL
- ip_address — VARCHAR(45)
- login_time — TIMESTAMP
- logout_time — TIMESTAMP
applied_subject
- apply_id — INT
- student_id — INT — NOT NULL
- subject_id — INT — NOT NULL
- apply_date — DATE
- status — ENUM('applied', 'approved', 'rejected')
assignment
- assignment_id — INT
- subject_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- file_path — VARCHAR(500)
- due_date — DATETIME — NOT NULL
- max_score — INT
- created_at — TIMESTAMP
assignment_grade
- submit_id — INT
- assignment_id — INT — NOT NULL
- student_id — INT — NOT NULL
- submitted_file — VARCHAR(500)
- score — DECIMAL(5,2)
- feedback — TEXT
- submitted_at — TIMESTAMP
board
- board_id — INT
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- user_id — INT — NOT NULL
- subject_id — INT
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
building
- building_id — INT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- floor_count — INT
college
- college_id — INT
- name — VARCHAR(100) — NOT NULL
- dean — VARCHAR(50)
- created_at — TIMESTAMP
department
- dept_id — INT
- college_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- head_prof_id — INT
- building_id — INT
login
- login_id — INT
- user_id — INT — NOT NULL
- ip_address — VARCHAR(45)
- user_agent — TEXT
- login_time — TIMESTAMP
- logout_time — TIMESTAMP
- success — BOOLEAN
major
- major_id — INT
- dept_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
notice
- notice_id — INT
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- prof_id — INT — NOT NULL
- subject_id — INT
- is_important — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
professor
- prof_id — INT
- user_id — INT — NOT NULL
- dept_id — INT — NOT NULL
- prof_number — VARCHAR(20) — NOT NULL
- title — VARCHAR(50)
- office_room_id — INT
- hire_date — DATE
- salary — DECIMAL(10,2)
reply
- reply_id — INT
- board_id — INT — NOT NULL
- parent_reply_id — INT
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
room
- room_id — INT
- building_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- capacity — INT
- type — ENUM('lecture', 'lab', 'office')
student
- student_id — INT
- user_id — INT — NOT NULL
- major_id — INT — NOT NULL
- student_number — VARCHAR(20) — NOT NULL
- entrance_year — YEAR
- graduation_year — YEAR
- status — ENUM('active', 'graduated', 'leave')
subject
- subject_id — INT
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(20) — NOT NULL
- major_id — INT — NOT NULL
- prof_id — INT — NOT NULL
- room_id — INT
- credit — INT
- semester — VARCHAR(10)
- max_students — INT
- description — TEXT
user
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- role — ENUM('student', 'professor', 'admin') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_grade
- grade_id — INT
- student_id — INT — NOT NULL
- subject_id — INT — NOT NULL
- grade — DECIMAL(3,2)
- semester — VARCHAR(10)