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)