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