캡스톤디자인
테이블 (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부터 시작