WMM

Tables (5)

DetailedSchedule

  • id — UUID
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • dueDate — DATE — NOT NULL
  • projectId — UUID — NOT NULL

Member

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • role — VARCHAR(100) — NOT NULL
  • profileImageURL — VARCHAR(255)
  • score — INT

Project

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • startDate — DATE — NOT NULL
  • endDate — DATE — NOT NULL
  • calendar — ?
  • Field

Submission

  • id — UUID
  • submitterId — UUID — NOT NULL
  • scheduleId — UUID — NOT NULL
  • content — FILE — NOT NULL
  • submissionDate — TIMESTAMP — NOT NULL
  • isApproved — BOOLEAN

calendar