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)