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