self_study
Tables (8)
Class (classes)
- class_id — int — Primary key — NOT NULL
- region_id — int — Foreign key → Region.region_id — NOT NULL
- pro_id — int — Foreign key → Pro.pro_id — NOT NULL
Material (materials)
- material_id — int — Primary key — NOT NULL
- name — var(255)
- purchase_at — date
- status — bool
Pro (pros)
- pro_id — int — Primary key — NOT NULL
- region_id — int — Foreign key → Region.region_id — NOT NULL
- name — var(10)
- phone_number — int
Project (projects)
- project_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → Student.student_id — NOT NULL
- name — var(100)
- type — var(5)
Region (regions)
- region_id — int — Primary key — NOT NULL
- name — var(10)
RentalLog (rental_logs)
- rental_log_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → Student.student_id — NOT NULL
- material_id — int — Foreign key → Material.material_id — NOT NULL
- due — date
Student (students)
- student_id — int — Primary key — NOT NULL
- class_id — int — Foreign key → Class.class_id — NOT NULL
- team_id — int — Foreign key → Team.team_id — NOT NULL
- name — var(10)
- phone_number — int
Team (teams)
- team_id — int — Primary key — NOT NULL
- pro_id — int — Foreign key → Pro.pro_id — NOT NULL
- name — var(20)