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