Classroom clone ERD

Tables (4)

classroom (클래스룸)

  • id (아이디) — varchar(60) — Primary key — NOT NULL
  • teacherId (교수자아이디) — varchar(60) — Foreign key → member.id — NOT NULL
  • name (수업명) — varchar(255)
  • description (Field) — text
  • joinCode (참여코드) — varchar(255)
  • theme (테마) — varchar(90)

classroomMember (수업 참가자 정보)

  • id (아이디) — int — Primary key — NOT NULL
  • classroomId (수업아이디) — varchar(90) — Foreign key → classroom.id — NOT NULL
  • studentId (학생아이디) — varchar(60) — Foreign key → member.id — NOT NULL
  • blocked (상태값) — boolean

member (회원정보)

  • id (아이디) — varchar(60) — Primary key — NOT NULL
  • pw (비밀번호) — varchar(60)
  • email (이메일) — varchar(60)
  • name (이름) — varchar(60)
  • image (프로필이미지) — varchar(255)
  • birthday (생년월일) — date
  • gender (성별) — varchar(30)
  • active (활성화여부) — boolean

verification (인가코드)

  • id (아이디) — int — Primary key — NOT NULL
  • memberId (사용자아이디) — varchar(60) — Foreign key → member.id — NOT NULL
  • code (인가코드) — varchar(30)
  • expiredAt (유효기간) — timestamp