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)