Lecture-control

Tables (4)

Account (계정)

  • accountId (아이디) — Long — Primary key — NOT NULL
  • email (계정이메일) — Varchar

Lecture (강의)

  • lectureId (아이디) — Long — Primary key — NOT NULL
  • accountId (아이디2) — Long — Foreign key → Account.accountId — NOT NULL
  • title (강좌이름) — Varchar
  • link (링크) — Varchar
  • teacher (강사) — Varchar
  • type (분류) — Varchar
  • Description (간단 설명) — Text

Member (회원)

  • memberId (회원아이디) — Long — Primary key — NOT NULL
  • name (회원이름) — Varchar
  • email (이메일) — Varchar
  • password (비밀번호) — Varchar
  • createdAt (생성일) — DateTime
  • updatedAt (수정일) — DateTime
  • verifyCode (인증번호) — Varchar
  • isVerify (인증여부) — Boolean
  • role (역할) — Varchar

Reservation (강의예약)

  • reservationId (예약아이디) — Long — Primary key — NOT NULL
  • lectureId (아이디2) — Long — Foreign key → Lecture.lectureId — NOT NULL
  • memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
  • startDateTime (시작일/시간) — DateTime
  • endDateTime (종료일/시간) — DateTime
  • status (예약상태) — Varchar