LMS_per
테이블 (9)
공지사항 (notice)
- notice_no — int(20)
- notice_writer — varchar(50)
- notice_title — varchar(50)
- notice_content — varchar(200)
- notice_date — datetime
- notice_count — int(20)
과목 (subject)
- subject_no — int(20)_
- subject_name — varchar(50)
- subject_pf — varchar(50)
- subject_total — int(50)
- subject_info — varchar(200)
교수 (professor)
- pf_id — varchar(50)
- pf_pw — varchar(50)
- pf_email — varchar(50)
- pf_no — int(20)
- pf_name — varchar(50)
- pf_major — varchar(50)
수강신청목록 (class_registaration)
- class_registration_no — int(20)
- class_registration_state — enum('대기','수강중','수료','과락','취소')
- class_registration_point — enum('A','B','C','D','F')
- class_registration_date — datetime
자료실 (archive)
- archivev_file_id — varchar(500)
- archivev_file_no — int(20)
- archivev_file_size — bigint(20)
- archivev_file_type — varchar(50)
- archivev_file_count — int(20)
- archivev_file_date — datetime
질문 (Q&A)
- qna_no — int(20)
- qna_writer — varchar(50)
- qna_title — varchar(50)
- qna_content — text
- qna_date — datetime
- qna_count — int(20)
퀴즈 (quiz)
- quiz_no — int(20)
- quiz_title — varchar(200)
- quiz_content — text
- quiz_date — datetime
- quiz_start_date — datetime
- quiz_end_date — datetime
학과 (major)
- major_id — int(20)
- major_name — varchar(50)
학생 (student)
- st_id — varchar(50)
- st_pw — varchar(50)
- st_email — varchar(50)
- st_no — int(20)
- st_name — varchar(50)
- st_major — varchar(50)