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