library_program_project

Tables (4)

instructor (Untitled4)

  • instructorID (Key) — char(20) — Primary key — NOT NULL
  • programID (Key2) — char(20) — Foreign key → program.programID — NOT NULL
  • name (Field) — char(30)
  • phoneNumber (Field2) — char(30)

library (Untitled)

  • libraryID (Key) — char(20) — Primary key — NOT NULL
  • programID (Key2) — char(20) — Foreign key → program.programID — NOT NULL
  • libraryName (Field) — char(30)
  • adress (Field2) — char(50)
  • phoneNumber (Field3) — char(30)

program (Untitled2)

  • programID (Key) — char(20) — Primary key — NOT NULL
  • programTitle (Field) — char(50)
  • target (Field2) — char(15)
  • time (Field3) — char(10)
  • instructorID (Field4) — int(20)
  • description (Field5) — text

student (Untitled3)

  • studentID (Key) — char(30) — Primary key — NOT NULL
  • libraryID (Key2) — char(20) — Foreign key → library.libraryID — NOT NULL
  • programID (Key3) — char(20) — Foreign key → program.programID — NOT NULL
  • name (Field) — char(30)
  • age (Field2) — char(5)
  • phoneNumber (Field3) — char(30)