pjt2
Tables (3)
Materials (materials)
- Book Name (name) — int(11) — Primary key — NOT NULL
- Students No (no) — int(20) — Foreign key → Students.Students No — NOT NULL
- Pro No (no2) — INT(11) — Foreign key → Students.Pro No — NOT NULL
- Purchase Date (day_of_purchase) — DATE
- Check-Out Date (check_out_date) — DATE
- Check-Out Student (check_out_student) — INT(20)
- Return Date (return_date) — DATE
Pro (pro)
- Pro No (no) — INT(11) — Primary key — NOT NULL
- Pro Name (name) — VARCHAR(50)
- Phone (phone) — VARCHAR(50)
Students (students)
- Students No (no) — int(20) — Primary key — NOT NULL
- Pro No (no2) — INT(11) — Foreign key → Pro.Pro No — NOT NULL
- Students Name (name) — VARCHAR(50)
- Students Phone (phone) — VARCHAR(50)
- Students Campus (campus) — VARCHAR(50)
- Students Class (class) — INT(20)
- Students Team (team) — VARCHAR(50)