GDG4주차과제

테이블 (3)

Course (Untitled)

  • courseId (course_id) — 기본 키 — NOT NULL
  • courseNumber (course_number)
  • courseName (course_name)
  • courseRoom (course_room)
  • courseTime (course_time)
  • courseProfessor (course_professor)

Student (Untitled2)

  • studentId (student_id) — 기본 키 — NOT NULL
  • studentNumber (student_number)
  • studentFaculty (student_faculty)
  • studentName (student_name)
  • studentBirthday (student_birthday)
  • studentPhonenumber (student_phonenumber)
  • Field

Untitled3

  • courseRegistrationId (course_registration_id) — 기본 키 — NOT NULL
  • courseId (course_id) — 외래 키 → Course.courseId — NOT NULL
  • studentId (student_id) — 외래 키 → Student.studentId — NOT NULL
  • registrationTime (registration_time)