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