기말

테이블 (6)

COURSE

  • course_id — INTEGER
  • course_name — TEXT — NOT NULL
  • dept — TEXT
  • grade — INTEGER
  • credit — INTEGER
  • prof_id — INTEGER
  • room_id — TEXT
  • day_of_week — TEXT
  • period — INTEGER
  • capacity — INTEGER

ENROLLMENT

  • enroll_id — INTEGER
  • student_id — INTEGER — NOT NULL
  • course_id — INTEGER — NOT NULL
  • reg_date — TEXT

PROFESSOR

  • prof_id — INTEGER
  • name — TEXT — NOT NULL
  • dept — TEXT

ROOM

  • room_id — TEXT
  • building — TEXT
  • floor — INTEGER
  • room_no — TEXT

STAFF

  • staff_id — INTEGER
  • name — TEXT — NOT NULL
  • dept — TEXT

STUDENT

  • student_id — INTEGER
  • name — TEXT — NOT NULL
  • dept — TEXT
  • grade — INTEGER