ERD
Tables (5)
Material
- MaterialID — Primary key — NOT NULL
- StudentID (StuendtID) — Foreign key → Student.StudentID — NOT NULL
- 제목 (Title)
- 구입년월일 (PurchaseDate)
- 대여일 (BorrowDate)
- 반납일 (RetirmDate)
Operator
- OperatorID — Primary key — NOT NULL
- 이름 (Name)
- 전화번호 (Phone)
- 담당지역 (Region)
- 반 (Class)
- 팀 (Team)
Project
- ProjectID — Primary key — NOT NULL
- 순번 (Order)
- 제목 (Title)
ProjectParticipation
- ParticipationID (Key) — Primary key — NOT NULL
- StudentID (StuendtID) — Foreign key → Student.StudentID — NOT NULL
- ProjectID — Foreign key → Project.ProjectID — NOT NULL
Student
- StudentID (StuendtID) — Primary key — NOT NULL
- OperatorID — Foreign key → Operator.OperatorID — NOT NULL
- 이름 (Field)
- 전화번호 (Phone)
- 캠퍼스지역 (CampusRegion)