classroom clone

Tables (8)

classroom (클래스룸)

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

classroomMember (수업참가자정보)

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

daliy_check (수업 참여자 출석 기록)

  • id (식별키) — int — Primary key — NOT NULL
  • classroom_member_id (클래스룸멤버아이디) — int — Foreign key → classroomMember.id — NOT NULL
  • checed_at (출석일) — date
  • Field

member (회원정보)

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

notice (공지사항)

  • id (식별키) — int — Primary key — NOT NULL
  • classroom_id (클래스룸 식별키) — varchar(90) — Foreign key → classroom.id — NOT NULL
  • content (내용) — text
  • create_at (작성한날짜) — timestamp

notice_attachment (공지사항 첨부파일)

  • id (식별키) — int — Primary key — NOT NULL
  • notice_id (공지사항 식별키) — int — Foreign key → notice.id — NOT NULL
  • file_name (파일이름) — varchar(255)
  • file_size (파일크기) — long
  • file_url (파일을 다운받는 곳) — varchar(255)

notice_reply (공지사항 댓글)

  • id (식별키) — int — Primary key — NOT NULL
  • notice_id (공지사항 식별키) — int — Foreign key → notice.id — NOT NULL
  • writer_id (댓글러 아이디) — varchar(60) — Foreign key → member.id — NOT NULL
  • content (댓글내용) — text
  • created_at (댓글단 시간) — timestamp

verification (인가코드)

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