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)

Untitled