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