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