TeamDO

Tables (5)

Task

  • TaskID — LONG — Primary key — NOT NULL
  • Title — VARCHAR(255)
  • Description — TEXT
  • DueDate — DATE
  • Priority — ENUM('Low', 'Medium', 'High')
  • UserID — LONG — Foreign key → User.UserID — NOT NULL

Team

  • TeamID — LONG — Primary key — NOT NULL
  • TeanName (TeamName) — VARCHAR(255)
  • UserID — LONG — NOT NULL
  • UserID (UserID2) — LONG — Foreign key → User.UserID — NOT NULL

TeamMember

  • TeamMemberID — LONG — Primary key — NOT NULL
  • TeamID — LONG — Foreign key → Team.TeamID — NOT NULL
  • UserID — LONG — Foreign key → User.UserID — NOT NULL

TeamTask

  • TeamTaskID — LONG — Primary key — NOT NULL
  • Title — VARCHAR(255)
  • Description — TEXT
  • DueDate — DATE
  • Priority — ENUM('Low', 'Medium', 'High')
  • TeamID — LONG — Foreign key → Team.TeamID — NOT NULL

User

  • UserID — LONG — Primary key — NOT NULL
  • Username — VARCHAR(255)
  • Password (password) — VARCHAR(255)
  • Name — VARCHAR(255)
  • Email — VARCHAR(255)