계절과제
테이블 (7)
Class
- class_id — INT
- name — VARCHAR(100)
- manager_id — INT
Manager
- manager_id — INT
- name — VARCHAR(100)
- phone — VARCHAR(20)
- region — VARCHAR(50)
Material
- material_id — INT
- title — VARCHAR(100)
- purchase_date — DATE
- loan_date — DATE
- return_date — DATE
- student_id — INT
Project
- project_id — INT
- title — VARCHAR(100)
Student
- student_id — INT
- name — VARCHAR(100)
- phone — VARCHAR(20)
- campus — VARCHAR(50)
- manager_id — INT
Student_Project
- student_id — INT
- project_id — INT
Team
- team_id — INT
- name — VARCHAR(100)
- class_id — INT