fasd

Tables (13)

ActivityLog

  • log_id — SERIAL
  • user_id — INTEGER
  • task_id — INTEGER
  • event — TEXT
  • timestamp — TIMESTAMP

App_Comment

  • comment_id — SERIAL
  • user_id — INTEGER
  • task_id — INTEGER
  • project_id — INTEGER
  • content — TEXT

App_File

  • file_id — SERIAL
  • task_id — INTEGER
  • comment_id — INTEGER
  • user_id — INTEGER
  • file_path — TEXT

Notification

  • notification_id — SERIAL
  • user_id — INTEGER
  • type — TEXT
  • message — TEXT
  • channel — TEXT

Organization

  • org_id — SERIAL
  • name — TEXT
  • description — TEXT

OrganizationMember

  • org_id — INTEGER
  • user_id — INTEGER
  • role — TEXT

Project

  • project_id — SERIAL
  • org_id — INTEGER
  • title — TEXT
  • description — TEXT
  • status — TEXT

ProjectMember

  • project_id — INTEGER
  • user_id — INTEGER
  • view_permission — BOOLEAN

SubTask

  • task_id — INTEGER
  • parent_task_id — INTEGER

Tag

  • tag_id — SERIAL
  • name — TEXT

Task

  • task_id — SERIAL
  • project_id — INTEGER
  • title — TEXT
  • description — TEXT
  • assignee_id — INTEGER
  • priority — TEXT
  • due_date — DATE
  • status — TEXT

TaskTag

  • task_id — INTEGER
  • tag_id — INTEGER

Users

  • user_id — SERIAL
  • email — TEXT
  • password — TEXT
  • name — TEXT
  • role — TEXT