xzc

Tables (9)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL
  • comment_text — VARCHAR(255) — NOT NULL
  • registrant — varchar(20) — NOT NULL

milestone

  • milestone_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • milestone_name — VARCHAR(255) — NOT NULL
  • start_date — DATE
  • end_date — DATE

project

  • project_id — BIGINT — Primary key — NOT NULL
  • project_name — VARCHAR(255) — NOT NULL
  • detail — VARCHAR(255)
  • status_id — BIGINT — Foreign key → status.status_id — NOT NULL

project_member

  • user_id — VARCHAR(20) — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • role_id — BIGINT — Foreign key → role.role_id — NOT NULL

role

  • role_id — BIGINT — Primary key — NOT NULL
  • role_name — VARCHAR(20) — NOT NULL

status

  • status_id — BIGINT — Primary key — NOT NULL
  • status_name — VARCHAR(20) — NOT NULL

tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • tag_name — VARCHAR(255) — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL

task

  • task_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • task_name — VARCHAR(255) — NOT NULL
  • task_details — VARCHAR(255)
  • registrant — VARCHAR(20) — NOT NULL
  • milestone_id — BIGINT — Foreign key → milestone.milestone_id

use_tag

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