캡스톤디자인

테이블 (32)

basket

  • id — int
  • member_id — int — NOT NULL
  • lecture_id — int — NOT NULL

board

  • id — int
  • member_id — int — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(100) — NOT NULL
  • updated_day — datetime
  • created_day — datetime — NOT NULL
  • type — int — NOT NULL — 0 : 자유게시판, 1 : 건의사항, 2 : 공지사항
  • views — int — NOT NULL — 조회수

board_comment

  • id — int
  • board_id — int — NOT NULL
  • member_id — int — NOT NULL
  • content — varchar(1000) — NOT NULL
  • comment_day — datetime — NOT NULL
  • step — int — NOT NULL
  • group_num — int — NOT NULL
  • modified — tinyint(1) — NOT NULL — 0 : 수정 안 됨, 1 : 수정됨

curriculum

  • id — int
  • section_id — int — NOT NULL
  • member_id — int — NOT NULL
  • time_taken — int — NOT NULL — 해당 섹션 소요시간(다 완주하는)

email_token

  • email_token_id — varchar(100) — NOT NULL
  • member_id — int — NOT NULL
  • expired — tinyint — NOT NULL
  • expiration_date — datetime — NOT NULL

interest_board

  • id — int
  • member_id — int — NOT NULL
  • board_id — int — NOT NULL

interest_lecture

  • id — int
  • member_id — int — NOT NULL
  • lecture_id — int — NOT NULL

interest_review

  • id — int
  • member_id — int — NOT NULL
  • review_id — int — NOT NULL

lecture

  • id — int
  • member_id — int — NOT NULL
  • name — varchar(20) — NOT NULL — 강좌이름
  • description — varchar(100) — NOT NULL — 강의에 대한 설명
  • image — varchar(100) — 강좌 설명에 들어가는 이미지
  • price — int — NOT NULL
  • grade — int — NOT NULL — 학년
  • created_day — datetime — NOT NULL — 강좌 생성일
  • thumb — varchar(100) — 강좌 썸네일
  • state — int — NOT NULL — 0 : 등록대기중, 1 : 등록
  • badge — varchar(100) — 뱃지이미지

lecture_progress

  • id — int
  • pay_lecture_id — int — NOT NULL
  • state — int — NOT NULL — 수강상태. 0 : 수강 전, 1 : 수강 시작, 2 : 수강 중, 3 : 수강 종료
  • start_day — datetime — 수강 시작일
  • end_day — datetime — 수강 종료일

main_test

  • id — int
  • section_id — int — NOT NULL — 어떤 섹션에 연결할 지
  • type — int — NOT NULL — 0 : 중간, 1 : 최종
  • description — varchar(1000) — NOT NULL — 테스트 설명

main_test_answer

  • id — int
  • main_test_question_id — int — NOT NULL
  • answer — varchar(1000) — NOT NULL — 답안

main_test_block

  • id — int
  • main_test_question_id — int — NOT NULL
  • block — varchar(1000) — NOT NULL — 제공될 블럭

main_test_log

  • id — int
  • member_id — int — NOT NULL
  • main_test_question_id — int — NOT NULL
  • sub_answer — varchar(100) — NOT NULL — 제출한 답변

main_test_multiple_choice_view

  • id — int
  • main_test_question_id — int — NOT NULL
  • content — varchar(1000) — NOT NULL
  • sequence — int — NOT NULL — 0 : 중간, 1 : 최종

main_test_question

  • id — int
  • main_test_id — int — NOT NULL
  • type — int — NOT NULL — 0 : 객관식, 1 : 블록코딩, 2 : 주관식
  • title — varchar(1000) — NOT NULL — 문제
  • sequence — int — NOT NULL — 문제 순서
  • score — int — NOT NULL — 문제의 점수

member

  • id — int
  • password — varchar(100) — NOT NULL
  • email — varchar(100) — NOT NULL
  • name — varchar(20) — NOT NULL
  • nickname — varchar(25) — NOT NULL
  • tel — char(15) — NOT NULL
  • birth_day — datetime — NOT NULL
  • join_day — datetime — NOT NULL — 가입일
  • gender — int — NOT NULL
  • address — varchar(50) — NOT NULL
  • profile — varchar(100) — 프로필 이미지
  • role — int — NOT NULL — 0 : 학생, 1 : 선생, 2 : 관리자
  • state — int — NOT NULL

pay_lecture

  • id — int
  • lecture_id — int — NOT NULL
  • payment_id — int — NOT NULL
  • price — int — NOT NULL

payment

  • id — int
  • member_id — int — NOT NULL
  • pay_day — datetime — NOT NULL
  • state — int — NOT NULL — 1 : 성공, 0 : 실패

portfolio

  • id — int
  • member_id — int — NOT NULL
  • path — varchar(100) — NOT NULL

question

  • id — int
  • lecture_id — int — NOT NULL
  • member_id — int — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • updated_day — datetime
  • created_day — datetime — NOT NULL
  • image — varchar(100) — NOT NULL

question_comment

  • id — int
  • question_id — int — NOT NULL
  • member_id — int — NOT NULL
  • content — varchar(1000) — NOT NULL
  • updated_day — datetime
  • created_day — datetime — NOT NULL
  • step — int — NOT NULL
  • group_num — int — NOT NULL

review

  • id — int
  • lecture_id — int — NOT NULL
  • member_id — int — NOT NULL
  • rating — int — NOT NULL
  • content — varchar(500) — NOT NULL
  • heart — int — NOT NULL
  • created_day — datetime — NOT NULL

review_comment

  • id — int
  • review_id — int — NOT NULL
  • member_id — int — NOT NULL
  • content — varchar(1000) — NOT NULL
  • comment_day — datetime — NOT NULL
  • modified — tinyint(1) — NOT NULL

section

  • id — int
  • lecture_id — int — NOT NULL
  • time_taken — int — NOT NULL — 해당 섹션 소요시간(다 완주하는)
  • name — varchar(50) — NOT NULL
  • created_day — datetime — NOT NULL
  • sequence — int — NOT NULL — 섹션 순서(1주차,2주차,3주차)

video

  • id — int
  • section_id — int — NOT NULL
  • name — varchar(30) — NOT NULL — 강의 이름
  • play_time — time — 총 재생시간
  • description — varchar(50) — NOT NULL — 영상설명
  • upload_day — datetime — NOT NULL
  • preview — int — NOT NULL — 1 : 미리보기 허용
  • path — varchar(100) — 파일위치
  • thumb — varchar(100) — 영상 썸네일 위치
  • sequence — int — NOT NULL — 순서 0부터, 1주차(강의1, 강의2...)

video_progress

  • id — int
  • lecture_progress_id — int — NOT NULL
  • video_id — int — NOT NULL
  • state — int — NOT NULL — 수강상태/ 0 : 수강 전, 1 : 수강시작, 2 : 수강 중, 3 : 수강 종료
  • start_day — datetime — NOT NULL — 수강 시작일
  • end_day — datetime — 수강 종료일
  • last_view — time — 마지막 영상 위치

video_test

  • id — int
  • video_id — int — NOT NULL
  • test_time — time — NOT NULL — 문제 나올 시간
  • type — int — NOT NULL — 문제타입 0: 객관식, 1 : 코드블럭
  • title — varchar(500) — NOT NULL
  • score — int — NOT NULL

video_test_answer

  • id — int
  • video_test_id — int — NOT NULL — 문제아이디
  • answer — varchar(100) — NOT NULL — 답

video_test_block_list

  • id — int
  • video_test_id — int — NOT NULL
  • block — varchar(50) — NOT NULL — 제공될 블럭

video_test_log

  • id — int
  • video_test_id — int — NOT NULL
  • member_id — int — NOT NULL — 회원아이디
  • sub_answer — varchar(100) — NOT NULL — 제출한 답변

video_test_multiple_list

  • id — int
  • video_test_id — int — NOT NULL
  • content — varchar(100) — NOT NULL — 문제
  • sequence — int — NOT NULL — 순서, 0부터 시작