Classroom clone ERD
Tables (8)
classroom (수업)
- id (아이디) — varchar(90) — Primary key — NOT NULL
- teacher_id (교수자아이디) — varchar(60) — Foreign key → member.id — NOT NULL
- name (수업명) — varchar(255)
- description (수업설명) — text
- join_code (참여코드) — varchar(30)
- theme (테마) — varchar(90)
classroom_member (수업 참가자 정보)
- id (아이디) — int — Primary key — NOT NULL
- classroom_id (수업아이디) — varchar(90) — Foreign key → classroom.id — NOT NULL
- student_id (학생아이디) — varchar(60) — Foreign key → member.id — NOT NULL
- blocked (상태값) — boolean
daily_check (수업 참여자 출석 기록)
- id (식별키) — int — Primary key — NOT NULL
- classroom_member_id (클래스룸 멤버아이디) — int — Foreign key → classroom_member.id — NOT NULL
- cheked_at (출석일) — date
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)
- actvie (활성화여부) — boolean
notice (공지사항)
- id (식별키) — int — Primary key — NOT NULL
- classroom_id (클래스룸 식별키) — varchar(90) — Foreign key → classroom.id — NOT NULL
- content (내용) — text
- created_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
- fiile_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