3-project
Tables (10)
attachments
- id — INT
- task_id — INT — Foreign key → tasks.id
- file_url — TEXT — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- uploaded_at — TIMESTAMP
comments
- id — INT
- task_id — INT — Foreign key → tasks.id
- author_id — INT — Foreign key → users.id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
project_members
- project_id — INT — Foreign key → projects.id
- user_id — INT — Foreign key → users.id
- status — project_member_status
- joined_at — TIMESTAMP
projects
- id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- creator_id — INT — Foreign key → users.id
refresh_tokens
- id — INT
- user_id — INT — Foreign key → users.id
- token — TEXT — NOT NULL
- expires_at — TIMESTAMP
- created_at — TIMESTAMP
- ip_address — VARCHAR(255)
subtasks
- id — INT
- task_id — INT — Foreign key → tasks.id
- title — VARCHAR(255) — NOT NULL
- is_completed — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
tags
- id — INT
- name — VARCHAR(255) — NOT NULL
task_tags
- task_id — INT — Foreign key → tasks.id
- tag_id — INT — Foreign key → tags.id
tasks
- id — INT
- project_id — INT — Foreign key → projects.id
- assignee_id — INT — Foreign key → users.id
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- start_year — INT
- start_month — INT
- start_day — INT
- end_year — INT
- end_month — INT
- end_day — INT
- status — task_status_enum
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP