kaid

Tables (9)

Comment

  • CommentID — INT — Primary key — NOT NULL
  • TaskID — INT — Foreign key → Task.TaskID — NOT NULL
  • UID — INT — Foreign key → User.UID — NOT NULL
  • Detail — VARCHAR
  • ParentCommentID (ParentCommentID2) — INT — Foreign key → Comment.CommentID — 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
  • Role — VARCHAR2

Task

  • TaskID — INT — Primary key — NOT NULL
  • ProjectID — INT — Foreign key → Project.ProjectID — NOT NULL
  • TaskOwnerID — INT — Foreign key → ProjectMember.UID — NOT NULL
  • CreatedAt — DATE — NOT NULL
  • Deadline — DATE
  • Status — Tinyint — NOT NULL

TaskCategory

  • CategoryID — TinyInt — Primary key — NOT NULL
  • TaskID — INT — Foreign key → Task.TaskID — NOT NULL
  • CategoryName — VARCHAR2 — NOT NULL

TaskMember

  • TaskID — INT — Foreign key → Task.TaskID — NOT NULL
  • UID — INT — Foreign key → ProjectMember.UID — NOT NULL

TaskSubCategory

  • SubCategoryID — TinyInt — Primary key — NOT NULL
  • CategoryID — TinyInt — Foreign key → TaskCategory.CategoryID — NOT NULL
  • SubCategoryName — VARCHAR2 — 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