issue-tracker

Tables (8)

comment (Untitled4)

  • comment_id (Key) — Primary key — NOT NULL
  • issue_id (Key2) — Foreign key → issue.issue_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL
  • 내용 (description)
  • 작성한 시간 (created date time)

image (Untitled5)

  • image_id (Key) — Primary key — NOT NULL
  • comment_id (Key2) — Foreign key → comment.comment_id — NOT NULL
  • 리소스 URL (resource_url)
  • 이름 (name)

issue (Untitled)

  • issue_id (Key) — Primary key — NOT NULL
  • milestone_id (Key2) — Foreign key → milestone.milestone_id — NOT NULL
  • 제목 (title)
  • 상태 (status)
  • 작성한 시간 (created date time)

issue_label (Untitled7)

  • issue_label_id (Key) — Primary key — NOT NULL
  • issue_id (Key2) — Foreign key → issue.issue_id — NOT NULL
  • label_id (Key3) — Foreign key → label.label_id — NOT NULL

issue_writer (Untitled8)

  • issue_writer_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • issue_id (Key3) — Foreign key → issue.issue_id — NOT NULL

label (Untitled2)

  • label_id (Key) — Primary key — NOT NULL
  • 제목 (title)
  • 내용 (description)
  • 배경색 (bg_color)
  • 폰트색 (font_color)

member (Untitled6)

  • member_id (Key) — Primary key — NOT NULL
  • 이름 (name)
  • 이메일 (email)

milestone (Untitled3)

  • milestone_id (Key) — Primary key — NOT NULL
  • 제목 (title)
  • 내용 (description)
  • 완료일 일정 (completion date time)