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