web

Tables (4)

Quiz (Untitled2)

  • week — int — Primary key — NOT NULL
  • no — int — Primary key — NOT NULL
  • topic — varchar(255)
  • answer — int

attendance_check

  • attendance_date — DATETIME — Primary key — NOT NULL
  • student_id — INT — Foreign key → student.student_id — NOT NULL
  • attendance_time — TIMESTAMP — NOT NULL
  • attendance — INT — NOT NULL

student

  • student_id — INT — Primary key — NOT NULL
  • pw — VARCHAR(250) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • section — CHAR(1) — NOT NULL
  • major — VARCHAR(30) — NOT NULL
  • question_no — INT — NOT NULL — auto_increment
  • question_answer — VARCHAR(30)

tbl_events (Untitled)

  • id — int — Primary key — NOT NULL
  • student_id — INT — Foreign key → student.student_id — NOT NULL
  • title — varchar(255)
  • start — date