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