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