Final
Tables (7)
DATA (Untitled4)
- dataID (Key) — int(10) — Primary key — NOT NULL
- rentalrecordID (Key2) — int(10) — Foreign key → RENTAL RECORD.rentalrecordID — NOT NULL
- book (Field) — char(50)
- dvd (Field2) — char(50)
- researchpaper (Field3) — char(50)
- studentID (Key3) — int(10) — Foreign key → STUDENT.studentID — NOT NULL
- studentPhone (Key22) — int(11) — Foreign key → STUDENT.studentPhone — NOT NULL
- teachingfacultyID (Key4) — int(10) — Foreign key → TEACHING FACULTY.teachingfacultyID — NOT NULL
- teachingfacultyPhone (Key23) — int(11) — Foreign key → TEACHING FACULTY.teachingfacultyPhone — NOT NULL
- belong(Department_name) (Key32) — LONGTEXT — Foreign key → TEACHING FACULTY.belong(Department_name) — NOT NULL
- professorID (Key5) — int(10) — Foreign key → PROFESSOR.professorID — NOT NULL
- professorPhone (Key24) — int(11) — Foreign key → PROFESSOR.professorPhone — NOT NULL
- belong(Department_major) (Key33) — LONGTEXT — Foreign key → PROFESSOR.belong(Department_major) — NOT NULL
PROFESSOR (Untitled3)
- professorID (Key) — int(10) — Primary key — NOT NULL
- professorPhone (Key2) — int(11) — Primary key — NOT NULL
- belong(Department_major) (Key3) — LONGTEXT — Primary key — NOT NULL
- name (Field) — char(20)
- email (Field2) — char(30)
RENTAL RECORD (Untitled6)
- rentalrecordID (Key) — int(10) — Primary key — NOT NULL
STUDENT (Untitled)
- studentID (Key) — int(10) — Primary key — NOT NULL
- studentPhone (Key2) — int(11) — Primary key — NOT NULL
- name (Field) — char(20)
- belong (Field2) — LONGTEXT
- email (Field3) — char(30)
SURVEY URL (Untitled7)
- surveyurlID (Key) — int(10) — Primary key — NOT NULL
- visithistoryID (Key2) — int(10) — Foreign key → VISIT HISTORY.visithistoryID — NOT NULL
- studentID (Key22) — int(10) — Foreign key → VISIT HISTORY.studentID — NOT NULL
- studentPhone (Key222) — int(11) — Foreign key → VISIT HISTORY.studentPhone — NOT NULL
- teachingfacultyID (Key3) — int(10) — Foreign key → VISIT HISTORY.teachingfacultyID — NOT NULL
- teachingfacultyPhone (Key23) — int(11) — Foreign key → VISIT HISTORY.teachingfacultyPhone — NOT NULL
- belong(Department_name) (Key32) — LONGTEXT — Foreign key → VISIT HISTORY.belong(Department_name) — NOT NULL
- professorID (Key4) — int(10) — Foreign key → VISIT HISTORY.professorID — NOT NULL
- professorPhone (Key24) — int(11) — Foreign key → VISIT HISTORY.professorPhone — NOT NULL
- belong(Department_major) (Key33) — LONGTEXT — Foreign key → VISIT HISTORY.belong(Department_major) — NOT NULL
TEACHING FACULTY (Untitled2)
- teachingfacultyID (Key) — int(10) — Primary key — NOT NULL
- teachingfacultyPhone (Key2) — int(11) — Primary key — NOT NULL
- belong(Department_name) (Key3) — LONGTEXT — Primary key — NOT NULL
- name (Field) — char(20)
- email (Field2) — char(30)
VISIT HISTORY (Untitled5)
- visithistoryID (Key) — int(10) — Primary key — NOT NULL
- studentID (Key2) — int(10) — Foreign key → STUDENT.studentID — NOT NULL
- studentPhone (Key22) — int(11) — Foreign key → STUDENT.studentPhone — NOT NULL
- teachingfacultyID (Key3) — int(10) — Foreign key → TEACHING FACULTY.teachingfacultyID — NOT NULL
- teachingfacultyPhone (Key23) — int(11) — Foreign key → TEACHING FACULTY.teachingfacultyPhone — NOT NULL
- belong(Department_name) (Key32) — LONGTEXT — Foreign key → TEACHING FACULTY.belong(Department_name) — NOT NULL
- professorID (Key4) — int(10) — Foreign key → PROFESSOR.professorID — NOT NULL
- professorPhone (Key24) — int(11) — Foreign key → PROFESSOR.professorPhone — NOT NULL
- belong(Department_major) (Key33) — LONGTEXT — Foreign key → PROFESSOR.belong(Department_major) — NOT NULL
- Field