0401

Tables (13)

lecture (Untitled3)

  • lecture_index (강의식별키) — int(11) — Primary key — NOT NULL
  • first_schedule (Key) — char(10) — Foreign key → lecture_schedule.first_schedule — NOT NULL
  • second_schedule (Key2) — char(10) — Foreign key → lecture_schedule.second_schedule — NOT NULL
  • professor_id (교수id) — varchar(14) — Foreign key → professor.professor_id — NOT NULL
  • lecture_grade (학년) — int(2)
  • lecture_id (강의코드) — varchar(10) — NOT NULL
  • lecture_name (강의명) — varchar(50)
  • lecture_limit (수강인원) — int(11)
  • lecture_credit (학점) — int(11)
  • lecture_major (학과) — varchar(20)
  • lecture_class (분반) — varchar(2)
  • lecture_room (강의실) — varchar(10)
  • lecture_semester (학기) — char(6)
  • lecture_professor (담당교수) — varchar(30)
  • lecture_time (강의시작시간) — char(34)
  • lecture_classfy (전공/교양) — varchar(10)

lecture_schedule (Untitled13)

  • first_schedule (Key) — char(10) — Primary key — NOT NULL
  • second_schedule (Key2) — char(10) — Primary key — NOT NULL

manager (Untitled5)

  • manager_id (관리자id) — varchar(14) — Primary key — NOT NULL
  • university_name (학교명) — varchar(50) — Foreign key → university.university_name — NOT NULL
  • manager_email (이메일) — varchar(50)
  • manager_pw (비밀번호) — varchar(20)

prefer_info (Untitled10)

  • prefer_id (선호식별키) — int(11) — Primary key — NOT NULL
  • student_id (학번) — varchar(14) — Foreign key → student.student_id — NOT NULL
  • schedule_index (스케줄id) — int(11) — Foreign key → student.schedule_index — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → student.univ_name — NOT NULL
  • major_credit (전공학점) — int(11)
  • etc_credit (교양학점) — int(11)
  • experiment_credit (실험학점) — int(11)

professor (Untitled6)

  • professor_id (교수id) — varchar(14) — Primary key — NOT NULL
  • professor_name (교수명) — varchar(30)
  • professor_major (전공) — varchar(50)
  • professor_email (이메일) — varchar(50)

register_basket (Untitled9)

  • register_basket_id (장바구니 식별키) — int(11) — Primary key — NOT NULL
  • student_id (학번) — varchar(14) — Foreign key → student.student_id — NOT NULL
  • lecture_index (강의식별키) — int(11) — Foreign key → lecture.lecture_index — NOT NULL
  • schedule_index (스케줄id) — int(11) — Foreign key → student.schedule_index — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → student.univ_name — NOT NULL

register_lecture (Untitled8)

  • register_lecture_id (수강신청식별키) — int(11) — Primary key — NOT NULL
  • student_id (학번) — varchar(14) — Foreign key → student.student_id — NOT NULL
  • lecture_index (강의식별키) — int(11) — Foreign key → lecture.lecture_index — NOT NULL
  • schedule_index (스케줄학기) — char(6) — Foreign key → student.schedule_index — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → student.univ_name — NOT NULL
  • first_schedule (Key) — char(10) — Foreign key → lecture.first_schedule — NOT NULL
  • second_schedule (Key2) — char(10) — Foreign key → lecture.second_schedule — NOT NULL

requesting (Untitled11)

  • requesting_id (증원신청id) — int(11) — Primary key — NOT NULL
  • lecture_index (강의식별키) — int(11) — Foreign key → lecture.lecture_index — NOT NULL
  • professor_id (교수id) — varchar(14) — Foreign key → professor.professor_id — NOT NULL

schedule (Untitled4)

  • schedule_index (스케줄id) — int(11) — Primary key — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → university.university_name — NOT NULL
  • manager_id (관리자id) — varchar(14) — Foreign key → manager.manager_id — NOT NULL
  • basket_start (장바구니 시작일) — DATETIME
  • register_start (수강신청 시작일) — DATETIME
  • modify_start (수강정정 시작일) — DATETIME
  • cancle_start (수강철회 시작일) — DATETIME
  • basket_end (장마구니 마감일) — DATETIME
  • register_end (수강신청 마감일) — DATETIME
  • modify_end (수강정정 마감일) — DATETIME
  • cancle_end (수강철회 마감일) — DATETIME
  • semester (학기) — char(6)

schedule_professor (Untitled12)

  • schedule_index (스케줄id) — int(11) — Foreign key → schedule.schedule_index — NOT NULL
  • university_name (학교명) — varchar(50) — Foreign key → schedule.univ_name — NOT NULL
  • manager_id (관리자id) — varchar(14) — Foreign key → schedule.manager_id — NOT NULL
  • professor_id (교수id) — varchar(14) — Foreign key → professor.professor_id — NOT NULL

student (Untitled)

  • student_id (학번) — varchar(14) — Primary key — NOT NULL
  • schedule_index (스케줄id) — int(11) — Foreign key → schedule.schedule_index — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → schedule.univ_name — NOT NULL
  • student_name (이름) — varchar(30)
  • student_year (학년) — varchar(2)
  • student_birth (생년월일) — DATE
  • student_phone (연락처) — varchar(15)
  • student_major (전공) — varchar(50)
  • student_second_major (복수/부전공) — varchar(50)
  • student_grade (평점) — decimal(3,2)
  • student_enroll (입학정보) — char(4)
  • student_credit (취득학점) — int(11)
  • student_pw (비밀번호) — varchar(20)

student_log (Untitled7)

  • log_id (로그식별키) — int(11) — Primary key — NOT NULL
  • student_id (학번) — varchar(14) — Foreign key → student.student_id — NOT NULL
  • lecture_index (강의식별키) — int(11) — Foreign key → lecture.lecture_index — NOT NULL
  • schedule_index (스케줄id) — int(11) — Foreign key → student.schedule_index — NOT NULL
  • univ_name (학교명) — varchar(50) — Foreign key → student.univ_name — NOT NULL
  • register_log (신청내역) — DATE
  • cancle_log (취소내역) — DATE
  • retake_log (재수강여부) — varchar(2)
  • modify_log (정정내역) — DATE

university (Untitled2)

  • university_name (학교명) — varchar(50) — Primary key — NOT NULL