erd

Tables (7)

Chat database

  • Chat_id — int — Primary key — NOT NULL
  • Project_id (id2) — int — Foreign key → Project.Project_id — NOT NULL
  • User_id — int — NOT NULL
  • Project_id — int — NOT NULL
  • Message — text
  • Timestamp — timestamp — NOT NULL

Gantt

  • Gantt_id (id) — int — Primary key — NOT NULL
  • Project_id (id2) — int — Foreign key → Project.Project_id — NOT NULL
  • Job name — text — NOT NULL
  • Priority — varchar — NOT NULL
  • Date — date
  • Start_date — date
  • Finished_date — date
  • Worker_name — varchar
  • Finish — int — NOT NULL

Mind map

  • Project_id (id) — int — Foreign key → Project.Project_id — NOT NULL
  • Title — text
  • Subtopic — text
  • Branch — text

Project

  • Project_id (id) — int — Primary key — NOT NULL
  • Project_name — varcgar — NOT NULL
  • Create_Date

ProjectMembers

  • ProjectMembers_id — Primary key — NOT NULL
  • User_id (id) — int — Foreign key → Users.User_id — NOT NULL
  • Project_id (id2) — int — Foreign key → Project.Project_id — NOT NULL
  • Role

Task_Workers

  • User_id (id) — int — Foreign key → Users.User_id — NOT NULL
  • Gantt_id (id2) — int — Foreign key → Gantt.Gantt_id — NOT NULL

Users

  • User_id (id) — int — Primary key — NOT NULL
  • User_name — varchar — NOT NULL
  • Password — varchar — NOT NULL
  • Nickname — varchar — NOT NULL
  • Email — varchar — NOT NULL
  • Created_date — varchar — NOT NULL
  • Modified_date — varchar — NOT NULL