erd 참고

테이블 (36)

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

  • 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_id — varchar(50) — 기본 키 — NOT NULL
  • admin_email — varchar(200) — NOT NULL
  • admin_phone — varchar(200) — NOT NULL
  • admin_name — varchar(200) — NOT NULL

answer_sheet

  • 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 — 선택한 번호
  • score — int(11) — NOT NULL — 점수

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_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_no — int(11) — 외래 키 → class_registration.class_registration_no — NOT NULL
  • cancel_createdate — datetime — NOT NULL
  • cancel_content — varchar(200) — NOT NULL

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_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_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_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_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_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_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_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_content — mediumtext — 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_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_createdate — datetime — NOT NULL
  • report_submit_updatedate — datetime — 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_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_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_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_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_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_id — varchar(50) — 기본 키 — NOT NULL
  • teacher_email — varchar(200) — NOT NULL
  • teacher_name — varchar(50) — NOT NULL
  • teacher_phone — 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_id — varchar(50) — 외래 키 → account.account_id — NOT NULL
  • teacher_email — varchar(200) — NOT NULL
  • teacher_name — varchar(50) — NOT NULL
  • teacher_phone — 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 — 교재 가격