UniHub

Tables (10)

Candidate

  • id — INT
  • electionId — INT — NOT NULL
  • studentId — INT — NOT NULL
  • profileImage — VARCHAR(255)
  • description — TEXT
  • file — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

Election

  • id — INT
  • universityId — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • candidateStart — DATETIME — NOT NULL
  • candidateEnd — DATETIME — NOT NULL
  • electionStart — DATETIME — NOT NULL
  • electionEnd — DATETIME — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

Enrollment

  • id — INT
  • lectureId — INT — NOT NULL
  • studentId — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

Lecture

  • id — INT
  • title — VARCHAR(255) — NOT NULL
  • majorId — INT — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • capacity — INT — NOT NULL
  • credit — INT — NOT NULL
  • professorId — INT
  • grade — INT — NOT NULL
  • semester — INT — NOT NULL
  • lecturePlanAttachment — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

LectureSchedule

  • id — INT
  • lectureId — INT — NOT NULL
  • day — ENUM('Mon','Tue','Wed','Thu','Fri','Sat','Sun') — NOT NULL
  • start — TIME — NOT NULL
  • end — TIME — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

Major

  • id — INT
  • universityId — INT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

ProfessorProfile

  • memberId — INT — Primary key — NOT NULL
  • employeeId — VARCHAR(50) — NOT NULL
  • universityId — INT — NOT NULL
  • majorId — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

StudentProfile

  • memberId — INT — Primary key — NOT NULL
  • studentCode — VARCHAR(50) — NOT NULL
  • universityId — INT — NOT NULL
  • majorId — INT — NOT NULL
  • grade — INT — NOT NULL
  • semester — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL

University

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • modifiedAt — DATETIME — NOT NULL
  • Field
  • Field2

Vote

  • id — INT
  • electionId — INT — NOT NULL
  • voterId — INT — NOT NULL
  • candidateId — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL