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)