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