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