Tutorbook
Tables (6)
Bus (Untitled4)
- Key — Primary key — NOT NULL
- Field — VARCHAR(100)
Class (Untitled3)
- Key (Student_ID) — INT — Foreign key → Student.Key — NOT NULL
- Key (Tutor_ID) — INT — Foreign key → Tutor.Key — NOT NULL
- Key (Classroom_ID) — INT — Foreign key → Classroom.Key — NOT NULL
- Field (SUBJECT) — VARCHAR(10)
- Field (TIME_START) — TIME
- Field (TIME_FINISH) — TIME
Classroom (Untitled5)
- Key (ID) — INT — Primary key — NOT NULL
- Field (LOCATION) — VARCHAR(100)
- Field (Rooms) — INT
Schedule (Untitled6)
- Key (TIME) — TIME — Primary key — NOT NULL
- Key (Classroom_ID) — INT — Foreign key → Classroom.Key — NOT NULL
- Field (Tutor_ID) — INT
Student (Untitled2)
- Key (ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(10)
- Field (SUBJECT) — VARCHAR(10)
- Field (PAY) — INT
Tutor (Untitled)
- Key (ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(10)
- Field2 (SUBJECT) — VARCHAR(10)
- Field3 (LOCATION) — VARCHAR(100)