프로젝트 db
테이블 (11)
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
Member
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('Student','Professor','Admin') — NOT NULL
- createdAt — DATETIME — NOT NULL
- modifiedAt — DATETIME — NOT NULL
ProfessorProfile
- memberId — INT — 기본 키 — 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 — 기본 키 — 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
Vote
- id — INT
- electionId — INT — NOT NULL
- voterId — INT — NOT NULL
- candidateId — INT — NOT NULL
- createdAt — DATETIME — NOT NULL