wiffle

Tables (10)

announcement (Untitled3)

  • announcement_id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → project.project_id — NOT NULL
  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • author_id (Field5)
  • views (Field7)

announcement_comments (Untitled10)

  • announcement_comment_id (Key) — Primary key — NOT NULL
  • announcement_id (Key2) — Foreign key → announcement.announcement_id — NOT NULL
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • created_by (Field5)

notifications (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • title (Field2)
  • message (Field3)
  • is_read (Field4)
  • created_at (Field5)

project (Untitled2)

  • project_id (Key) — Primary key — NOT NULL
  • manager_id (Field)
  • project_name (Field2)
  • description (Field3)
  • start_due (Field4)
  • end_date (Field5)
  • created_at (Field6)
  • updated_at (Field7)

project_logs (Untitled5)

  • log_id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → project.project_id — NOT NULL
  • user_id (Field2)
  • content (Field3)
  • created_at (Field4)

project_mapping (Untitled4)

  • project_mapping_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • project_id (Key3) — Foreign key → project.project_id — NOT NULL
  • role (Field3)
  • created_at (Field4)
  • fields (Field5)

task (Untitled7)

  • task_id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → project.project_id — NOT NULL
  • title (Field2)
  • content (Field3)
  • status (Field4)
  • priority (Field5)
  • dueDate (Field6)
  • created_at (Field7)
  • updated_at (Field8)
  • views (Field9)

task_assigness (Untitled8)

  • task_assignees_id (Key) — Primary key — NOT NULL
  • task_id (Key2) — Foreign key → task.task_id — NOT NULL
  • assignee_id (Field2)
  • assigned_at (Field3)
  • assigned_by (Field4)

task_comments (Untitled9)

  • comment_id (Key) — Primary key — NOT NULL
  • task_id (Key22) — Foreign key → task_assigness.task_id — NOT NULL
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • created_by (Field5)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field1)
  • email (Field2)
  • password (Field3)
  • name (Field4)
  • phone (Field5)
  • department (Field6)
  • status (Field7)
  • created_at (Field8)
  • google_id (Field9)
  • github_id (Field10)
  • description (Field11)