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