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