ssafyfree

Tables (4)

Material

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

Pro

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

Project

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

Student

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