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 — 교재 가격