pjt2

Tables (3)

Materials (materials)

  • Book Name (name) — int(11) — Primary key — NOT NULL
  • Students No (no) — int(20) — Foreign key → Students.Students No — NOT NULL
  • Pro No (no2) — INT(11) — Foreign key → Students.Pro No — NOT NULL
  • Purchase Date (day_of_purchase) — DATE
  • Check-Out Date (check_out_date) — DATE
  • Check-Out Student (check_out_student) — INT(20)
  • Return Date (return_date) — DATE

Pro (pro)

  • Pro No (no) — INT(11) — Primary key — NOT NULL
  • Pro Name (name) — VARCHAR(50)
  • Phone (phone) — VARCHAR(50)

Students (students)

  • Students No (no) — int(20) — Primary key — NOT NULL
  • Pro No (no2) — INT(11) — Foreign key → Pro.Pro No — NOT NULL
  • Students Name (name) — VARCHAR(50)
  • Students Phone (phone) — VARCHAR(50)
  • Students Campus (campus) — VARCHAR(50)
  • Students Class (class) — INT(20)
  • Students Team (team) — VARCHAR(50)