asd

Tables (7)

comments

  • comment_id — BIGINT — NOT NULL
  • comment_content — TEXT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • account_id — VARCHAR(50) — NOT NULL

milestones

  • milestone_id — BIGINT — NOT NULL
  • milestone_name — VARCHAR(50) — NOT NULL
  • project_id — BIGINT — NOT NULL

project_member

  • account_id — VARCHAR(50) — Primary key — NOT NULL
  • project_id — BIGINT — Primary key — NOT NULL

projects

  • project_id — BIGINT — NOT NULL
  • account_id — VARCHAR(50) — NOT NULL
  • project_status — VARCHAR(10) — NOT NULL
  • project_name — VARCHAR(100) — NOT NULL
  • project_explain — VARCHAR(300)

tags

  • task_id — BIGINT — Foreign key → task_tag.task_id — NOT NULL
  • tag_id — BIGINT — NOT NULL
  • tag_name — VARCHAR(12) — NOT NULL
  • project_id — BIGINT — NOT NULL

task_tag

  • task_id — BIGINT — Foreign key → tasks.task_id — NOT NULL

tasks

  • task_id — BIGINT — Primary key — NOT NULL
  • task_title — VARCHAR(100) — NOT NULL
  • task_content — TEXT — NOT NULL
  • project_id — BIGINT — NOT NULL
  • milestone_id — BIGINT — NOT NULL
  • account_id — VARCHAR(50) — NOT NULL