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