enrolment
Tables (8)
Lecture (강의)
- lecture_id (PK) — Long — Primary key — NOT NULL
- professor_id (FK) — Long — Foreign key → Professor.professor_id — NOT NULL
- term_id (FK2) — Long — Foreign key → LectureEnrollTerm.term_id — NOT NULL
- register_id (FK3) — Long — Foreign key → Member.member_id — NOT NULL
- name (Field3) — String
- description (Field4) — String
- dayOfWeeks (Field5) — enum
- startTime (Field6) — Time
- endTime (Field7) — Time
- maxPeople (Field8) — integer
- minPeople (Field9) — integer
- isProfessorApprove (Field10) — boolean
- isDisabled (Field11) — boolean
- createdDate (Field12) — timestamp
- modifiedDate (Field13) — timestamp
LectureEnroll (수강 신청)
- lectur_enroll_id (PK) — Long — Primary key — NOT NULL
- lecture_id (FK) — Long — Foreign key → Lecture.lecture_id — NOT NULL
- student_id (FK2) — Long — Foreign key → Student.student_id — NOT NULL
- member_id (PK2) — Long — Foreign key → Lecture.register_id — NOT NULL
- createdDate (Field3) — timestamp
- modifiedDate (Field4) — timestamp
LectureEnrollTerm (수강 신청 기간)
- term_id (PK) — Long — Primary key — NOT NULL
- enrollStartDate (Field) — timestamp
- enrollEndDate (Field2) — timestamp
- createdDate (Field3) — timestamp
- modifiedDate (Field4) — timstamp
- isOpen (Field5) — boolean
Member (사용자)
- member_id (PK) — Long — Primary key — NOT NULL
- name (Field2) — varchar(100)
- email (Field3) — varchar(100)
- password (Field4)
- gender (Field5) — enum
- createdDate (Field6) — timestamp
- modifiedDate (Field7) — timestamp
Professor (교수 정보)
- professor_id (PK) — Long — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
- createdDate (Field) — timestamp
- modifiedDate (Field2) — timestamp
Role (권한)
- role_id (PK) — Long — Primary key — NOT NULL
- name (Field) — varchar(30)
- createdDate (Field2) — timestamp
- modifiedDate (Field3) — timestamp
- dec (Field4) — varchar(100)
- roleCode (Field5) — varchar
Student (학생 정보)
- student_id (PK) — Long — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
- createdDate (Field) — timestamp
- modifiedDate (Field2) — timestamp
UserRole (사용자 권한)
- user_role_id (PK) — Long — Primary key — NOT NULL
- role_id (PK2) — Long — Foreign key → Role.role_id — NOT NULL
- member_id (PK3) — Long — Foreign key → Member.member_id — NOT NULL
- createdDate (Field2) — timestamp
- modifiedDate (Field3) — timestamp
- isApprove (Field) — boolean