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)