하렴
테이블 (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)