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)