계절과제

테이블 (7)

Class

  • class_id — INT
  • name — VARCHAR(100)
  • manager_id — INT

Manager

  • manager_id — INT
  • name — VARCHAR(100)
  • phone — VARCHAR(20)
  • region — VARCHAR(50)

Material

  • material_id — INT
  • title — VARCHAR(100)
  • purchase_date — DATE
  • loan_date — DATE
  • return_date — DATE
  • student_id — INT

Project

  • project_id — INT
  • title — VARCHAR(100)

Student

  • student_id — INT
  • name — VARCHAR(100)
  • phone — VARCHAR(20)
  • campus — VARCHAR(50)
  • manager_id — INT

Student_Project

  • student_id — INT
  • project_id — INT

Team

  • team_id — INT
  • name — VARCHAR(100)
  • class_id — INT