mini-dooray

Tables (6)

Comment (Untitled5)

  • CommentID (Key) — Primary key — NOT NULL
  • MemberId (Field) — Foreign key → Member.MemberId
  • Content (Field2)
  • TaskID (Key2) — Foreign key → Task.TaskID — NOT NULL

Member (Untitled)

  • MemberId (Field) — Primary key
  • Email (Field2)
  • Password (Field3)
  • check_registered (Field4)

Milestone (Untitled8)

  • MilestoneID (Key) — Primary key — NOT NULL
  • TaskID (Key3) — Foreign key → Task.TaskID — NOT NULL
  • Name (Field)
  • StartAt (Field2)
  • EndAt (Field3)
  • ProjectId (Key2) — Foreign key → Project.ProjectId — NOT NULL

Project (Untitled6)

  • ProjectId (Key) — Primary key — NOT NULL
  • PName (Field)
  • Status (Field2)
  • AdminID (Field3)
  • MemberId (Field4) — Foreign key → Member.MemberId

Tag (Untitled7)

  • TagID (Key) — Primary key — NOT NULL
  • TaskID (Key3) — Foreign key → Task.TaskID — NOT NULL
  • name (Field)
  • ProjectId (Key2) — Foreign key → Project.ProjectId — NOT NULL

Task (Untitled4)

  • TaskID (Key) — Primary key — NOT NULL
  • Content (Field)
  • Field2
  • Field3
  • Field4
  • MemberId (Field5) — Foreign key → Member.MemberId
  • ProjectId (Key2) — Foreign key → Project.ProjectId — NOT NULL