MyExtraDuty
Tables (5)
Assignments (assignment)
- Task ID (task) — INT — Foreign key → Tasks.Task ID — NOT NULL
- School ID (school) — INT — Foreign key → Schools.School ID — NOT NULL
- User (email) — VARCHAR(100) — NOT NULL
- Assigned At (assigned_at) — TIMESTAMP — NOT NULL
Enrollments (enrollment)
- School ID (school) — INT — Foreign key → Schools.School ID — NOT NULL
- User (email) — VARCHAR(100) — NOT NULL
- Manager (manager) — BOOLEAN — NOT NULL
Profiles (profile)
- Email (email) — VARCHAR(100) — Primary key — NOT NULL
- Name (name) — VARCHAR(100)
- Picture (picture) — VARCHAR(300)
- Admin (admin) — BOOLEAN — NOT NULL
Schools (school)
- School ID (id) — INT — Primary key — NOT NULL
- Owner Email (owner) — VARCHAR(100) — Foreign key → Profiles.Email — NOT NULL
- Name (name) — VARCHAR(30) — NOT NULL
- Address (address) — VARCHAR(200) — NOT NULL
- Logo (logo) — VARCHAR(200) — NOT NULL
- Primary Color (primary_color) — VARCHAR(10) — NOT NULL
- Opening At (opening_at) — STRING
- Quota (quota) — INT — NOT NULL
- Maximum Assigned (max_assigned) — INT — NOT NULL
- Drop Enabled (drop_enabled) — BOOLEAN — NOT NULL
- Timezone (timezone) — TEXT — NOT NULL
Tasks (task)
- Task ID (id) — INT — Primary key — NOT NULL
- School ID (school) — INT — Foreign key → Schools.School ID — NOT NULL
- Category (category) — VARCHAR(100)
- Location (location) — VARCHAR(30) — NOT NULL
- Description (description) — VARCHAR(500)
- Starting Date (starting_date) — DATE — NOT NULL
- Ending Date (ending_date) — DATE — NOT NULL
- Starting Time (starting_time) — TIME — NOT NULL
- Ending Time (ending_time) — TIME — NOT NULL
- Capacity (capacity) — INT — NOT NULL