수강신청

테이블 (5)

Course (Untitled2)

  • Key (course_id) — Long — 기본 키 — NOT NULL
  • Key (major_id) — Long — 외래 키 → Major.Key — NOT NULL
  • Field (course_name) — varchar(255)

Major (Untitled)

  • Key (major_id) — Long — 기본 키 — NOT NULL
  • Field (major_name) — varchar(255)

User (Untitled3)

  • Key (user_id) — Long — 기본 키 — NOT NULL
  • Key (major_id) — Long — 외래 키 → Major.Key — NOT NULL
  • Field (email) — varchar(255)
  • Field (login_id) — varchar(255)
  • Field2 (password) — varchar(255)
  • Field (phone_number) — varchar(255)
  • Field2 (role) — varchar(255)
  • Field3 (username) — varchar(255)
  • Field (created_date) — DateTime
  • Field2 (modified_date) — DateTime

classes (Untitled4)

  • Key (class_id) — Long — 기본 키 — NOT NULL
  • Key (course_id) — Long — 외래 키 → Course.Key — NOT NULL
  • Field (class_number) — Integer
  • Field2 (cur_student_num) — Integer
  • Field3 (max_student_num) — Integer
  • Field4 (professor_name) — varchar(255)

take_class (Untitled5)

  • Key (take_id) — Long — 기본 키 — NOT NULL
  • Key (class_id) — Long — 외래 키 → classes.Key — NOT NULL
  • Key (user_id) — Long — 외래 키 → User.Key — NOT NULL