Test

테이블 (36)

account 계정 (account)

  • account_id — varchar(50) — 기본 키 — NOT NULL
  • account_pw — varchar(50) — NOT NULL
  • account_state — enum('대기', '활성화', '탈퇴') — NOT NULL — 계정 활성화 여부
  • account_level — int(11) — NOT NULL — 계정 권한
  • account_createdate — datetime — NOT NULL
  • account_updatedate — datetime — NOT NULL

address 주소 (address)

  • id — int(11) — 기본 키 — NOT NULL
  • zip_code — char(5) — NOT NULL — 우편번호
  • province — varchar(30) — NOT NULL — 시도
  • province_eng — varchar(30) — NOT NULL — 시도영문
  • city — varchar(30) — NOT NULL — 시군구
  • city_eng — varchar(30) — NOT NULL — 시군구영문
  • town — varchar(30) — NOT NULL — 읍면
  • town_eng — varchar(30) — NOT NULL — 읍면영문
  • street_code — varchar(12) — NOT NULL — 도로명코드
  • street — varchar(50) — NOT NULL — 도로명
  • street_eng — varchar(50) — NOT NULL — 도로명영문
  • basement — char(1) — NOT NULL — 지하여부
  • building1 — varchar(5) — NOT NULL — 건물번호본번
  • building2 — varchar(5) — NOT NULL — 건물번호부번
  • building_manage — varchar(25) — NOT NULL — 건물관리번호
  • building_city — varchar(75) — NOT NULL — 시군구용건물명
  • dong_code — varchar(10) — NOT NULL — 법정동코드
  • dong — varchar(30) — NOT NULL — 법정동명
  • ri — varchar(30) — NOT NULL — 리명
  • dong_admin — varchar(30) — NOT NULL — 행정동명
  • mountain — varchar(4) — NOT NULL — 산여부
  • lotnum1 — varchar(4) — NOT NULL — 지번본번
  • serial — varchar(2) — NOT NULL — 읍면동일련번호
  • lotnum2 — varchar(4) — NOT NULL — 지번부번

admin 관리자 (admin)

  • admin_id — varchar(50) — 기본 키 — NOT NULL
  • admin_email — varchar(200) — NOT NULL
  • admin_phone — varchar(200) — NOT NULL
  • admin_name — varchar(200) — NOT NULL

answersheet

  • acount_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL — 학생아이디
  • multiplechoice_no — int(11) — 외래 키 → multiplechoice 다중선택.multiplechoice_no — NOT NULL
  • answer_select — enum('1', '2', '3', '4', '5') — NOT NULL — 선택한 번호
  • answer_score — int(11) — NOT NULL — 점수

attendance 출석 (attendance)

  • attendance_day — date — 기본 키 — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • attendance_createdate — datetime — NOT NULL
  • attendance_updatedate — datetime — NOT NULL
  • attendance_state — enum('출석','결석','외출','조퇴','지각') — NOT NULL
  • attendance_remark — text

career

  • career_no — int(11) — 기본 키 — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • career_content — varchar(200) — NOT NULL
  • career_startdate — date — NOT NULL
  • career_enddate — date — NOT NULL

class_registration 수강신청 (class_registration)

  • class_registration_no — int(11) — 기본 키 — NOT NULL — 학생들 수강신청목록
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • class_registration_state — enum('대기', '수강중', '수료', '과락', '취소') — NOT NULL
  • class_registration_point — enum('0', '1', '2', '3', '4', '5') — NOT NULL
  • class_registration_review — text
  • class_registration_createdate — datetime — NOT NULL — 수강신청일

class_registration_cancel 수강취소 (class_registration_cancel)

  • class_registration_no — int(11) — 외래 키 → class_registration 수강신청.class_registration_no — NOT NULL
  • cancel_createdate — datetime — NOT NULL
  • cancel_content — varchar(200) — NOT NULL

classroom 강의실 (classroom)

  • classroom_no — int(11) — 기본 키 — NOT NULL
  • classroom_number — int(11) — NOT NULL
  • classroom_size — int(11) — NOT NULL
  • classroom_total — int(11) — NOT NULL

education 강의 (education)

  • education_no — int(11) — 기본 키 — NOT NULL — 학력(강사,운영자)
  • account_Id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • education_school — varchar(50) — NOT NULL — 학교
  • education_major — varchar(50) — NOT NULL — 전공
  • education_startdate — date — NOT NULL — 입학일
  • education_enddate — date — NOT NULL — 졸업일

faq 자주하는질문 (faq)

  • faq_no — int(11) — 기본 키 — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • faq_writer — varchar(50) — NOT NULL
  • faq_title — varchar(200) — NOT NULL
  • faq_content — text — NOT NULL
  • faq_createdate — datetime — NOT NULL
  • faq_updatedate — datetime — NOT NULL
  • faq_count — int(11) — NOT NULL
  • faq_category — varchar(50) — 외래 키 → faq_category.faq_category — NOT NULL

faq_category

  • faq_category — varchar(50) — 기본 키 — NOT NULL

lecture 강의 (lecture)

  • lecture_no — int(11) — 기본 키 — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • subject_no — int(11) — 외래 키 → subject 과목.subject_no — NOT NULL
  • teacher_name — varchar(50) — NOT NULL
  • lecture_name — varchar(50) — NOT NULL
  • textbook_isbn — int(11) — 외래 키 → textbook.textbook_isbn — NOT NULL
  • lecture_startdate — date — NOT NULL
  • lecture_enddate — date — NOT NULL
  • lecture_total — int(11) — NOT NULL — 강좌 정원
  • syllabus_no — int(11) — 외래 키 → syllabus 강의 계획서.syllabus_no — NOT NULL
  • classroom_no — int(11) — 외래 키 → classroom 강의실.classroom_no — NOT NULL
  • lecture_createdate — datetime — NOT NULL
  • lecture_updatedate — datetime — NOT NULL

lecture_archive 강의 저장소 (lecture_archive)

  • lecture_archive_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • lecture_archive_writer — varchar(50) — NOT NULL
  • lecture_archive_title — varchar(200) — NOT NULL
  • lecture_archive_content — text — NOT NULL
  • lecture_archive_createdate — datetime — NOT NULL
  • lecture_archive_updatedate — datetime — NOT NULL
  • lecture_archive_count — int(11) — NOT NULL

lecture_archive_file 강의 저장파일 (lecture_archive_file)

  • lecture_archive_file_uuid — varchar(500) — 기본 키 — NOT NULL
  • lecture_archive_file_original — varchar(500) — NOT NULL
  • lecture_archive_no — int(11) — 외래 키 → lecture_archive 강의 저장소.lecture_archive_no — NOT NULL
  • lecture_archive_file_size — int(11) — NOT NULL
  • lecture_archive_file_type — varchar(50) — NOT NULL
  • lecture_archive_file_count — int(11) — NOT NULL
  • lecture_archive_file_createdate — datetime — NOT NULL

lecture_notice 강의 공지사항 (lecture_notice)

  • lecture_notice_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • lecture_notice_title — varchar(200) — NOT NULL
  • lecture_notice_content — text — NOT NULL
  • lecture_notice_createdate — datetime — NOT NULL
  • lecture_notice_updatedate — datetime — NOT NULL
  • lecture_notice_count — int(11) — NOT NULL

license

  • license_no — int(11) — 기본 키 — NOT NULL — auto increment
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • license_number — varchar(200) — NOT NULL — 자격증 번호
  • license_name — varchar(200) — NOT NULL — 자격증 이름
  • license_agency — varchar(200) — NOT NULL — 자격증 발급처
  • license_getdate — date — NOT NULL — 자격증 발급일

lms_notice

  • lms_notice_no — int(11) — 기본 키 — NOT NULL — 게시글 번호
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL — 작성자 아이디
  • lms_notice_writer — varchar(50) — NOT NULL — 작성자 이름
  • lms_notice_title — varchar(200) — NOT NULL
  • lms_notice_content — text — NOT NULL
  • lms_notice_createdate — datetime — NOT NULL
  • lms_notice_updatedate — datetime — NOT NULL
  • lms_notice_count — int(11) — NOT NULL

manager

  • manager_id — varchar(50) — 기본 키 — NOT NULL
  • manager_email — varchar(200) — NOT NULL
  • manager_phone — varchar(50) — NOT NULL
  • manager_name — varchar(50) — NOT NULL
  • manager_gender — enum('남','여') — NOT NULL
  • manager_birth — date — NOT NULL
  • manager_position — enum('대리','사원','팀장')
  • manager_address_main — text — NOT NULL
  • manager_address_sub — text — NOT NULL
  • manager_image — varchar(200)
  • manager_accessdate — datetime — NOT NULL
  • manager_updatedate — datetime — NOT NULL

manager_queue

  • manager_id — varchar(50) — 기본 키 — NOT NULL
  • manager_email — varchar(200) — NOT NULL
  • manager_phone — varchar(50) — NOT NULL
  • manager_name — varchar(50) — NOT NULL
  • manager_gender — enum('남','여') — NOT NULL
  • manager_birth — date — NOT NULL
  • manager_address_main — text — NOT NULL
  • manager_address_sub — text — NOT NULL

multiplechoice 다중선택 (multiplechoice)

  • multiplechoice_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • multiplechoice_id — int(11) — NOT NULL
  • multiplechoice_question — varchar(200) — NOT NULL
  • multiplechoice_answer — enum('1','2','3','4','5') — NOT NULL
  • multiplechoice_createdate — datetime — NOT NULL
  • multiplechoice_updatedate — datetime — NOT NULL

multiplechoice_example

  • multiplechoice_example_no — int(11) — 기본 키 — NOT NULL
  • multiplechoice_example_id — enum('1','2','3','4','5') — 기본 키 — NOT NULL
  • multiplechoice_no — int(11) — 외래 키 → multiplechoice 다중선택.multiplechoice_no — NOT NULL
  • multiplechoice_example_content — text — NOT NULL
  • multiplechoice_example_createdate — datetime — NOT NULL
  • multiplechoice_example_updatedate — datetime — NOT NULL

question

  • question_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • question_writer — varchar(50) — NOT NULL — 작성자 이름
  • question_title — varchar(200) — NOT NULL
  • question_context — text — NOT NULL
  • question_createdate — datetime — NOT NULL
  • question_updatedate — datetime — NOT NULL
  • question_count — int(11) — NOT NULL
  • question_password — varchar(50) — 비밀글

question_comment

  • question_comment_no — int(11) — 기본 키 — NOT NULL
  • question_no — int(11) — 외래 키 → question.question_no — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • question_comment_writer — varchar(50) — NOT NULL
  • question_comment_context — text — NOT NULL
  • question_comment_createdate — datetime — NOT NULL
  • question_comment_updatedate — datetime — NOT NULL

question_file

  • question_file_uuid — varchar(500) — 기본 키 — NOT NULL
  • question_file_original — varchar(500) — NOT NULL
  • question_no — int(11) — 외래 키 → question.question_no — NOT NULL
  • question_file_size — int(11) — NOT NULL
  • question_file_type — varchar(50) — NOT NULL
  • question_file_count — int(11) — NOT NULL
  • question_file_createdate — datetime — NOT NULL

report

  • report_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • report_title — varchar(200) — NOT NULL
  • report_content — text — NOT NULL
  • report_createdate — datetime — NOT NULL
  • report_updatedate — datetime — NOT NULL
  • report_startdate — datetime — NOT NULL
  • report_enddate — datetime — NOT NULL

report_submit 과제제출 (report_submit)

  • report_submit_no — int(11) — 기본 키 — NOT NULL
  • report_no — int(11) — 외래 키 → report.report_no — NOT NULL
  • account_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • report_submit_writer — varchar(50) — NOT NULL
  • report_submit_title — varchar(200) — NOT NULL
  • report_submit_content — text — NOT NULL
  • report_submit_point — int(11) — NOT NULL
  • report_submit_feedback — text
  • report_submit_createdate — datetime — NOT NULL
  • report_submit_updatedate — datetime — NOT NULL

report_submit_file 과제 제출파일 (report_submit_file)

  • report_submit_file_uuid — varchar(500) — 기본 키 — NOT NULL
  • report_submit_file_original — varchar(500) — NOT NULL
  • report_submit_no — int(11) — 외래 키 → report_submit 과제제출.report_submit_no — NOT NULL
  • report_submit_file_size — int(11) — NOT NULL
  • report_submit_file_type — varchar(50) — NOT NULL
  • report_submit_file_count — int(11) — NOT NULL
  • report_submit_file_createdate — datetime — NOT NULL

student 수강생 (student)

  • student_id — varchar(50) — 기본 키 — NOT NULL
  • student_email — varchar(200) — NOT NULL
  • student_name — varchar(50) — NOT NULL
  • student_phone — varchar(50) — NOT NULL
  • student_gender — enum('남','여') — NOT NULL
  • student_birth — date — NOT NULL
  • student_address_main — text — NOT NULL
  • student_address_sub — text — NOT NULL
  • student_image — varchar(200)
  • student_accessdate — datetime — NOT NULL
  • student_updatedate — datetime — NOT NULL
  • manager_id_access — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL

student_queue 수강대기 학생 (student_queue)

  • student_id — varchar(50) — 기본 키 — NOT NULL
  • student_email — varchar(200) — NOT NULL
  • student_name — varchar(50) — NOT NULL
  • student_phone — varchar(50) — NOT NULL
  • student_gender — enum('남','여') — NOT NULL
  • student_birth — date — NOT NULL
  • student_address_main — text — NOT NULL
  • student_address_sub — text — NOT NULL

subject 과목 (subject)

  • subject_no — int(11) — 기본 키 — NOT NULL
  • subject_name — varchar(50) — NOT NULL — 과목 이름
  • subject_createdate — datetime — NOT NULL
  • subject_updatedate — datetime — NOT NULL
  • subject_totalday — int(11) — NOT NULL
  • subject_info — varchar(200) — NOT NULL

syllabus 강의 계획서 (syllabus)

  • syllabus_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • syllabus_content — text — NOT NULL
  • syllabus_teachersign — varchar(50) — NOT NULL
  • syllabus_managersign — varchar(50) — NOT NULL
  • syllabus_createdate — datetime — NOT NULL
  • syllabus_updatedate — datetime — NOT NULL

teacher 교수 (teacher)

  • teacher_id — varchar(50) — 기본 키 — NOT NULL
  • teacher_email — varchar(200) — NOT NULL
  • teacher_phone — varchar(50) — NOT NULL
  • teacher_name — varchar(50) — NOT NULL
  • teacher_gender — enum('남','여') — NOT NULL
  • teacher_birth — date — NOT NULL
  • teacher_address_main — text — NOT NULL
  • teacher_address_sub — text — NOT NULL
  • teacher_image — varchar(200)
  • teacher_accessdate — datetime — NOT NULL
  • teacher_updatedate — datetime — NOT NULL
  • manager_id_access — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • teacher_info — varchar(200)

teacher_queue 교수 대기 (teacher_queue)

  • teacher_id — varchar(50) — 외래 키 → account 계정.account_id — NOT NULL
  • teacher_email — varchar(200) — NOT NULL
  • teacher_phone — varchar(50) — NOT NULL
  • teacher_name — varchar(50) — NOT NULL
  • teacher_gender — enum('남','여') — NOT NULL
  • teacher_birth — date — NOT NULL
  • teacher_address_main — text — NOT NULL
  • teacher_address_sub — text — NOT NULL

test

  • test_no — int(11) — 기본 키 — NOT NULL
  • lecture_no — int(11) — 외래 키 → lecture 강의.lecture_no — NOT NULL
  • test_startdate — datetime — NOT NULL — 시험 시작일
  • test_enddate — datetime — NOT NULL — 시험 종료일
  • test_content — text — NOT NULL — 시험내용
  • test_createdate — datetime — NOT NULL
  • test_updatedate — datetime — NOT NULL

textbook

  • textbook_isbn — int(13) — 기본 키 — NOT NULL
  • textbook_title — varchar(200) — NOT NULL — 교재 이름
  • textbook_writer — varchar(200) — NOT NULL — 교재 저자
  • textbook_publisher — varchar(200) — NOT NULL — 교재 출판사
  • textbook_publishdate — date — NOT NULL — 교재 출판일
  • textbook_info — text — NOT NULL — 교재 정보
  • textbook_price — int(11) — NOT NULL — 교재 가격