todo_list_project

Tables (13)

Comment Table (t_comment)

  • Unique ID (id) — int — Primary key — NOT NULL
  • Parent comment ID (parent_id) — int
  • Comment (comment) — int
  • Created Datetime (created_at) — timestamp
  • Comment Type (comment_type) — varchar
  • Task ID (task_id) — int
  • Comment creator (user_id) — int — Foreign key → User table.User ID — NOT NULL
  • Comment replied user (reply_user_id) — int — Foreign key → User table.User ID — NOT NULL

Feedback table (t_feedback)

  • Task ID (id) — int — Primary key — NOT NULL
  • Feedback description (description) — text
  • Created Datetime (created_at) — timestamp
  • Updated Datetime (updated_at) — timestamp
  • Started Datetime (started_at) — timestamp
  • End Datetime (end_at) — timestamp
  • Expires Datetime (expires_at) — timestamp
  • Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
  • STATUS (status) — varchar
  • Review (review) — int
  • Field

Files table (t_files)

  • File ID (id) — int — Primary key — NOT NULL
  • Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
  • Task Type (task_type) — varchar
  • File Name (file_name) — varchar
  • File Type (file_type) — varchar
  • Created Date (created_at) — timestamp
  • Field

Menu Roles Table (t_menu_roles)

  • Unique ID (id) — int — Primary key — NOT NULL
  • Role ID (role_id) — int — Foreign key → Role table.Role ID — NOT NULL
  • Menu ID (menu_id) — int — Foreign key → Menu table.Menu ID — NOT NULL

Menu table (t_menu)

  • Menu ID (id) — int — Primary key — NOT NULL
  • Menu Name (menu_name) — varchar
  • URL (url) — varchar

Notification Type table (t_notification_types)

  • Unique ID (id) — int — Primary key — NOT NULL
  • Notification type name (type_name) — varchar
  • Field

Notification table (t_notifications)

  • Unique Notification ID (id) — int — Primary key — NOT NULL
  • Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
  • Notification Type ID (type_id) — int — Foreign key → Notification Type table.Unique ID — NOT NULL
  • Receiver User ID (receiver_id) — int — Foreign key → User table.User ID — NOT NULL
  • Actor User ID (actor_id) — int — Foreign key → User table.User ID — NOT NULL
  • Notification Title (title) — varchar
  • Notification Message (message) — varchar
  • Shows whether the notification has already been viewed/read (read_yn) — varchar
  • Created Datetime (created_at) — timestamp

Project table (t_project)

  • Project ID (id) — int — Primary key — NOT NULL
  • Project Name, Title (name) — varchar
  • Project Description (description) — varchar
  • Created datetime (created_at) — timestamp
  • Updated Datetime (updated_at) — timestamp

Project users table (t_project_users)

  • Project users ID (id) — int — Primary key — NOT NULL
  • Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
  • A number used to identify each employee in the project. (user_id) — int — Foreign key → User table.User ID — NOT NULL
  • Created datetime (created_at) — timestamp
  • Field

Role table (t_roles)

  • Role ID (id) — int — Primary key — NOT NULL
  • Role name (role) — varchar
  • Created datetime (created_at) — timestamp
  • Field

Task table (t_task)

  • Task ID (id) — int — Primary key — NOT NULL
  • Task description (description) — text
  • Created Datetime (created_at) — timestamp
  • Updated Datetime (updated_at) — timestamp
  • Started Datetime (started_at) — timestamp
  • End Datetime (end_at) — timestamp
  • Expires Datetime (expires_at) — timestamp
  • Project ID (project_id) — int — Foreign key → Project table.Project ID — NOT NULL
  • Feedback ID (feedback_id) — int — Foreign key → Feedback table.Task ID — NOT NULL

User table (t_users)

  • User ID (id) — int — Primary key — NOT NULL
  • User Name (name) — varchar
  • User Email (email) — varchar
  • User Phone (phone) — varchar
  • Is the user being used? (use_yn) — varchar
  • User Profile File ID (profile) — varchar
  • User Password (password) — varchar
  • User created datetime (created_at) — timestamp
  • User profile updated datetime (updated_at) — timestamp
  • User Role ID (role_id) — int — Foreign key → Role table.Role ID — NOT NULL

Users task table (t_task_users)

  • Unique ID (id) — int — Primary key — NOT NULL
  • Task ID (task_id) — int — Foreign key → Task table.Task ID — NOT NULL
  • User ID (user_id) — int — Foreign key → User table.User ID — NOT NULL