ssafyfree

Tables (4)

Material

  • KEY (material_id) — varchar(20) — Primary key — NOT NULL
  • KEY (student_id) — varchar(20) — Foreign key → Student.KEY — NOT NULL
  • Field (material_buydate) — date
  • Field (material_returndate) — date

Pro

  • KEY (pro_id) — varchar(20) — Primary key — NOT NULL
  • Field (pro_tel) — varchar(20)
  • Field (pro_class) — int
  • Field (pro_team) — int

Project

  • KEY (project_id) — varchar(20) — Primary key — NOT NULL
  • KEY (student_id) — varchar(20) — Foreign key → Student.KEY — NOT NULL
  • Field (project_name) — varchar(20)
  • Field (project_order) — int

Student

  • KEY (student_id) — varchar(20) — Primary key — NOT NULL
  • KEY (pro_id) — varchar(20) — Foreign key → Pro.KEY — NOT NULL
  • Field (student_name) — varchar(10)
  • Field (student_tel) — varchar(20)
  • Field (student_region) — varchar(10)
  • Field (student_class) — int