kaid2
Tables (13)
ChatMessage
- MessageID — INT — Primary key — NOT NULL
- TeamID — INT — Foreign key → TeamMember.TeamID — NOT NULL
- ProjectID — INT — Foreign key → TeamMember.ProjectID — NOT NULL
- UID — INT — Foreign key → TeamMember.UID — NOT NULL
- CreatedAt — DATE
- Detail — VARCHAR2
Comment
- CommentID — INT — Primary key — NOT NULL
- TaskID — INT — Foreign key → Task.TaskID — NOT NULL
- RoleID — INT — Foreign key → Task.RoleID — NOT NULL
- UID — INT — Foreign key → User.UID — NOT NULL
- Detail — VARCHAR2
- ParentCommentID2 — INT — NOT NULL
Log
- ProjectID — INT — Foreign key → Project.ProjectID — NOT NULL
- CreatedAt — DATE
- Detail — VARCHAR2
Project
- ProjectID — INT — Primary key — NOT NULL
- ProjectOwnerID — INT — Foreign key → User.UID — NOT NULL
- CreatedAt — DATE — NOT NULL
- Deadline — DATE
ProjectMember
- ProjectID — INT — Foreign key → Project.ProjectID — NOT NULL
- UID — INT — Foreign key → User.UID — NOT NULL
- RoleID — INT — Foreign key → ProjectRole.RoleID — NOT NULL
ProjectRole
- RoleID — INT — Primary key — NOT NULL
- RoleName — VARCHAR2
Task
- TaskID — INT — Primary key — NOT NULL
- ProjectID — INT — Foreign key → Project.ProjectID — NOT NULL
- SubCategoryID — TinyInt — Foreign key → TaskSubCategory.SubCategoryID — NOT NULL
- TaskOwnerID — INT — Foreign key → ProjectMember.UID — NOT NULL
- RoleID — INT — Foreign key → ProjectMember.RoleID — NOT NULL
- CreatedAt — DATE — NOT NULL
- Deadline — DATE
- Status — Tinyint — NOT NULL
TaskCategory
- CategoryID — TinyInt — Primary key — NOT NULL
- CategoryName — VARCHAR2 — NOT NULL
TaskMember
- TaskID — INT — Foreign key → Task.TaskID — NOT NULL
- UID — INT — Foreign key → ProjectMember.UID — NOT NULL
- RoleID — INT — Foreign key → ProjectMember.RoleID — NOT NULL
TaskSubCategory
- SubCategoryID — TinyInt — Primary key — NOT NULL
- CategoryID — TinyInt — Foreign key → TaskCategory.CategoryID — NOT NULL
- SubCategoryName — VARCHAR2 — NOT NULL
Team
- TeamID — INT — Primary key — NOT NULL
- TeamLeaderID — INT — Primary key — NOT NULL
- ProjectID — INT — Foreign key → Project.ProjectID — NOT NULL
TeamMember
- TeamID — INT — Foreign key → Team.TeamID — NOT NULL
- ProjectID — INT — Foreign key → Team.ProjectID — NOT NULL
- UID — INT — Foreign key → ProjectMember.UID — NOT NULL
User
- UID — INT — Primary key — NOT NULL
- Username — VARCHAR2 — NOT NULL
- Email — VARCHAR2 — NOT NULL
- Password — VARCHAR2 — NOT NULL
- IsAdmin — TinyInt — NOT NULL
- ProfileImage — VARCHAR2