taskapi

Tables (10)

Untitled (status_code)

  • Key (code_id) — int — Primary key — NOT NULL
  • Field (status_name) — varchar(10) — NOT NULL — project 상태 이름

Untitled (task)

  • Key (task_id) — int — Primary key — NOT NULL
  • Key (task_project_id) — int — Foreign key → project.Key — NOT NULL
  • Field (task_name) — varchar(100)
  • Field (content) — varchar(1000)
  • Field (write_time) — datetime
  • Key (member_writer_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (tag)

  • Key (tag_id) — int — Primary key — NOT NULL
  • Key (project_id) — int — Foreign key → project.Key — NOT NULL
  • Field (tag_name) — varchar(50)
  • Field (tag_color) — varchar(15)

Untitled (comment)

  • Key (comment_id) — int — Primary key — NOT NULL
  • Key (comment_task_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (member_writer_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar(1000)
  • Field (write_time) — datetime — NOT NULL

Untitled (task_tag_bundle)

  • Key (tag_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (task_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (member)

  • Key (member_id) — int — Primary key — NOT NULL
  • Field

Untitled (milestone)

  • Key (milestone_id) — int — Primary key — NOT NULL
  • Key (project_id) — int — Foreign key → project.Key — NOT NULL
  • Field (milestone_name) — varchar(100)
  • Field (start_datetime) — datetime
  • Field (end_datetime) — datetime

Untitled (project_member_bundle)

  • Key (project_id) — int — Foreign key → project.Key — NOT NULL
  • Key (member_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (register_time) — datetime

Untitled (task_milestone_bundle)

  • Key (milestone_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (task_id) — int — Foreign key → Untitled.Key — NOT NULL

project

  • Key (project_id) — int — Primary key — NOT NULL
  • Field (project_title) — varchar(100)
  • Key (project_status_code_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (admin_id) — int — Foreign key → Untitled.Key — NOT NULL