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