ㅁㄴㅇ
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