Advertisement
Guest User

org workflows er diagram v2

a guest
Sep 29th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. #padding:6
  2. #leading: 1.5
  3. #direction:right
  4. [User|id: INT; username: STR; password: STR; first_name: STR; middle_name: STR; last_name: STR|ckeys: (id), (username)]
  5. [Org|id: INT;name: STR;description: STR|ckeys: (id), (name)]
  6. [Membership|org_id: INT; user_id: INT|ckeys: (org_id, user_id)]
  7. [Workflow|id: INT;org_id: INT;name: STR|ckeys: (id), (name, org_id)]
  8. [Task|id: INT;workflow_id: INT;name: STR;status: STR|ckeys: (id)]
  9. [TaskAssignment|task_id: INT;user_id: INT|ckeys: (task_id, user_id)]
  10. [Prereq|task_id: INT;prereq_id: INT|ckeys: (task_id, prereq_id)]
  11. [Tag|id: INT; workflow_id: INT; name: STR|ckeys: (id)]
  12. [TaskTag|task_id: INT; tag_id: INT|ckeys: (task_id, tag_id)]
  13.  
  14. [User]<-[TaskAssignment]
  15. [Task]<-[TaskAssignment]
  16. [Org]<-[Membership]
  17. [User]<-[Membership]
  18. [Org]<-[Workflow]
  19. [Workflow]<-[Task]
  20. [Task]<-[Prereq]
  21. [Task]<-[Prereq]
  22. [Workflow]<-[Tag]
  23. [Task]<-[TaskTag]
  24. [Tag]<-[TaskTag]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement