d

Tables (10)

comment

  • comment_id — BIGINT
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • comment_writer_member_id — VARCHAR(30) — NOT NULL
  • comment — VARCHAR(1000) — NOT NULL

comment_mention

  • target_member_id — BIGINT — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL

milestone

  • milestone_id — BIGINT
  • name — VARCHAR(20) — NOT NULL
  • start_period — DATE
  • end_period — DATE
  • status — VARCHAR(20)
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL

project

  • project_id — BIGINT
  • project_status_id — INT — Foreign key → project_status.project_status_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000)

project_authority

  • project_authority_id — INT
  • name — VARCHAR(20) — NOT NULL

project_member

  • target_member_id — VARCHAR(30) — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • project_authority_id — INT — Foreign key → project_authority.project_authority_id — NOT NULL

project_status

  • project_status_id — INT
  • name — VARCHAR(20)

tag

  • tag_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL

task

  • task_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • milestone_id — BIGINT — Foreign key → milestone.milestone_id
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(3000)
  • task_writer_member_id — VARCHAR(30) — NOT NULL

task_tag

  • tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL