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)