afterProject
Tables (9)
AFTER_ATTENDANCE
- attendance_id — BIGINT
- enrollment_id — BIGINT — Foreign key → AFTER_ENROLLMENTS.enrollment_id — NOT NULL
- class_date — DATE — NOT NULL
- status — VARCHAR(50) — NOT NULL
AFTER_COURSES
- course_id — BIGINT
- teacher_id — BIGINT — Foreign key → AFTER_USERS.user_id — NOT NULL
- course_name — VARCHAR(255) — NOT NULL
- category — VARCHAR(100)
- description — TEXT
- course_days — VARCHAR(100)
- course_time — VARCHAR(100)
- location — VARCHAR(100)
- capacity — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME
AFTER_ENROLLMENTS
- enrollment_id — BIGINT
- student_id — BIGINT — Foreign key → AFTER_USERS.user_id — NOT NULL
- course_id — BIGINT — Foreign key → AFTER_COURSES.course_id — NOT NULL
- status — VARCHAR(50) — NOT NULL
- enrolled_at — DATETIME
AFTER_NOTICES
- notice_id — BIGINT
- author_id — BIGINT — Foreign key → AFTER_USERS.user_id — NOT NULL
- course_id — BIGINT — Foreign key → AFTER_COURSES.course_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
AFTER_SURVEYS
- survey_id — BIGINT
- author_id — BIGINT — Foreign key → AFTER_USERS.user_id — NOT NULL
- course_id — BIGINT — Foreign key → AFTER_COURSES.course_id
- title — VARCHAR(255) — NOT NULL
- start_date — DATE
- end_date — DATE
- created_at — DATETIME
AFTER_SURVEY_QUESTIONS
- question_id — BIGINT
- survey_id — BIGINT — Foreign key → AFTER_SURVEYS.survey_id — NOT NULL
- question_text — TEXT — NOT NULL
- question_type — VARCHAR(50) — NOT NULL
- options — TEXT
AFTER_SURVEY_RESPONSES
- response_id — BIGINT
- question_id — BIGINT — Foreign key → AFTER_SURVEY_QUESTIONS.question_id — NOT NULL
- respondent_id — BIGINT — Foreign key → AFTER_USERS.user_id — NOT NULL
- response_content — TEXT
- submitted_at — DATETIME
AFTER_USERS
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- student_id_no — VARCHAR(50)