하렴

테이블 (16)

assignment

  • id — BIGINT — NOT NULL
  • tutoring_id — BIGINT — NOT NULL
  • textbook_id — BIGINT — NOT NULL

drawing

  • id — BIGINT — NOT NULL
  • homework_id — BIGINT — NOT NULL
  • page — INT
  • homework_drawing_url — VARCHAR(2048)
  • review_drawing_url — VARCHAR(2048)
  • teacher_drawing_url — VARCHAR(2048)

homework

  • id — BIGINT — NOT NULL
  • textbook_id — BIGINT — NOT NULL
  • tutoring_id — BIGINT — NOT NULL
  • deadline — DATE
  • start_page — INT
  • end_page — INT
  • status — VARCHAR(20) — UNCONFIRMED, IN_PROGRESS, COMPLETED
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — TINYINT(1)

student

  • id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL — 멤버 테이블 FK
  • grade — VARCHAR(30) — 학생 학년
  • school — VARCHAR(50) — 학생 학교

subject

  • id — BIGINT — NOT NULL
  • name — varchar(20) — 과목명

teacher

  • id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL — 멤버 테이블 FK
  • profile_status — TINYINT(1) — 공개 1, 비공개 0
  • college — VARCHAR(50) — 대학교명
  • major — VARCHAR(50) — 대학 전공명
  • college_email — VARCHAR(100) — 대학 인증 이메일
  • gender — VARCHAR(10) — MALE, FEMALE, NONE
  • salary — INT — NULL OK, (단위 : 만원)
  • career — INT — NULL OK, (단위 : 년)
  • introduce — VARCHAR(1500) — 자기 소개
  • created_at — DATETIME
  • updated_at — DATETIME

teacher_subject

  • id — BIGINT — NOT NULL
  • subject_id — BIGINT — NOT NULL
  • teacher_id — BIGINT — NOT NULL

textbook

  • id — BIGINT — NOT NULL
  • teacher_member_id — BIGINT — NOT NULL
  • subject_id — BIGINT — NOT NULL
  • textbook_name — VARCHAR(20)
  • textbook_url — VARCHAR(2048)
  • first_page_cover — TINYINT(1)
  • total_page — INT
  • cover_img — VARCHAR(2048)
  • is_deleted — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

tutoring

  • id — BIGINT — NOT NULL
  • chat_room_id — BIGINT — NOT NULL
  • subject_id — BIGINT
  • hourly_rate — INT
  • status — VARCHAR(20) — IN_PROGRESS, CLOSED
  • student_member_id — BIGINT — NOT NULL
  • teacher_member_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

tutoring_schedule

  • id — BIGINT — NOT NULL — 과외일정 테이블 PK
  • tutoring_id — BIGINT — NOT NULL — 과외 테이블 FK
  • schedule_date — DATE — 과외 날짜
  • start_time — TIME — 과외 시작 시간
  • duration — INT — 과외 진행 시간(단위: 분)
  • title — VARCHAR(64) — 커리큘럼명
  • updated_at — DATETIME
  • created_at — DATETIME

video

  • id — BIGINT — NOT NULL
  • tutoring_schedule_id — BIGINT — NOT NULL
  • video_url — VARCHAR(2048)
  • start_time — TIME
  • end_time — TIME
  • created_at — DATETIME
  • updated_at — DATETIME

video_room

  • id — BIGINT — NOT NULL
  • tutoring_schedule_id — BIGINT — NOT NULL — 과외일정 테이블 FK
  • room_code — VARCHAR(100) — 화상과외방 입장 코드
  • created_at — DATETIME
  • updated_at — DATETIME

video_timestamp

  • id — BIGINT — NOT NULL
  • video_id — BIGINT — NOT NULL
  • stamp_time — TIME
  • content — VARCHAR(100)

채팅방 (chat_room)

  • id — NOT NULL
  • student_member_id — NOT NULL
  • teacher_member_id — NOT NULL
  • 삭제여부 (is_deleted)
  • 생성일 (created_at)
  • 변경일 (updated_at)

채팅방 상태 (chat_room_state)

  • Key — 기본 키 — NOT NULL
  • is_deleted
  • last_read_message_id
  • chat_room_id — BIGINT
  • member_id — BIGINT

회원 (member)

  • 회원아이디 (id) — 기본 키 — NOT NULL
  • Field (role)
  • Field2 (status)
  • Field3 (oauth_id)
  • Field4 (profile_url)
  • Field5 (name)
  • Field6 (phone)
  • Field7 (created_at)
  • Field8 (updated_at)