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