test

Tables (6)

Book (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • buyDate (Field2) — date
  • Field3

Pro (Untitled)

  • id (int) — int — Primary key — NOT NULL
  • name (varchar(30)) — varchar(30)
  • phone (Field) — varchar(30)
  • campus (Field2) — varchar(30)
  • class (Field3) — int
  • Field4

Project (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • projectType (Field) — int
  • name (Field2) — varchar(30)
  • Field3

Student (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • phone (Field2) — varchar(30)
  • campus (Field3) — varchar(30)
  • Field4

Team (Untitled6)

  • studentId (Key3) — int — Foreign key → Student.id — NOT NULL
  • projectId (Key2) — int — Foreign key → Project.id — NOT NULL

borrowList (Untitled5)

  • id (Key2) — int — Primary key — NOT NULL
  • bookId (Key) — int — Foreign key → Book.id — NOT NULL
  • studentId (Key3) — int — Foreign key → Student.id — NOT NULL
  • startDate (Field3) — date
  • endDate (Field4) — date