MiniDooray
Tables (8)
account (Untitled)
- id (아이디) — varchar(50) — Primary key
- password (비밀번호) — varchar(50)
- name (이름) — varchar(12)
- email (이메일) — varchar(70)
- status (상태) — 활성,휴면,탈퇴
comment (Untitled6)
- comment_id (댓글아이디) — INT — Primary key — NOT NULL — autu increment
- text (내용) — text
- task_id (업무아이디) — INT — Foreign key → task.task_id — NOT NULL — autu increment
- account_id (작성자아이디) — varchar(50)
milestone (Untitled7)
- milestone_id (마일스톤아이디) — INT — Primary key — NOT NULL — auto increment
- name (마일스톤이름) — varchar(50)
- start_date (시작일) — date
- end_date (종료일) — date
- project_id (프로젝트아이디) — INT — Foreign key → project.project_id — NOT NULL — autu increment
project (Untitled2)
- project_id (프로젝트아이디) — INT — Primary key — NOT NULL — autu increment
- account_id (관리자아이디) — INT — account id
- status (상태) — varchar(10)
project_member (Untitled4)
- account_id (Field) — varchar(50) — Primary key
- project_id (프로젝트아이디) — INT — Foreign key → project.project_id — NOT NULL — autu increment
tag (Untitled8)
- tag_id (태그아이디) — INT — Primary key — NOT NULL — auto increment
- name (속성명) — varchar(12)
- project_id (프로젝트아이디) — INT — Foreign key → project.project_id — NOT NULL — autu increment
task (Untitled5)
- task_id (업무아이디) — INT — Primary key — NOT NULL — autu increment
- text (내용) — text
- project_id (프로젝트아이디) — INT — Foreign key → project.project_id — NOT NULL — autu increment
- milestone_id (마일스톤아이디) — INT — Foreign key → milestone.milestone_id — NOT NULL — auto increment
- account_id (작성자아이디) — varchar(50
task_tag (Untitled3)
- task_id (업무아이디) — INT — Foreign key → task.task_id — NOT NULL — autu increment
- tag_id (태그아이디) — INT — Foreign key → tag.tag_id — NOT NULL — auto increment