d
Tables (10)
comment
- comment_id — BIGINT
- task_id — BIGINT — Foreign key → task.task_id — NOT NULL
- created_at — DATETIME — NOT NULL
- comment_writer_member_id — VARCHAR(30) — NOT NULL
- comment — VARCHAR(1000) — NOT NULL
comment_mention
- target_member_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
milestone
- milestone_id — BIGINT
- name — VARCHAR(20) — NOT NULL
- start_period — DATE
- end_period — DATE
- status — VARCHAR(20)
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
project
- project_id — BIGINT
- project_status_id — INT — Foreign key → project_status.project_status_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(1000)
project_authority
- project_authority_id — INT
- name — VARCHAR(20) — NOT NULL
project_member
- target_member_id — VARCHAR(30) — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- project_authority_id — INT — Foreign key → project_authority.project_authority_id — NOT NULL
project_status
- project_status_id — INT
- name — VARCHAR(20)
tag
- tag_id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
task
- task_id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- milestone_id — BIGINT — Foreign key → milestone.milestone_id
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(3000)
- task_writer_member_id — VARCHAR(30) — NOT NULL
task_tag
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- task_id — BIGINT — Foreign key → task.task_id — NOT NULL