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