Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. Task Group 1 contains
  2. |-- Simple Task 1
  3. |-- Simple task 2
  4. |-- Task Group 1a contains
  5. |-- Simple Task 3
  6. |-- Simple Task 4
  7. |-- Task Group 1b contains
  8. |--Simple task 5
  9.  
  10. CREATE TABLE `task_group` (
  11. `id` int(11) NOT NULL AUTO_INCREMENT,
  12. `name` varchar(45) DEFAULT NULL,
  13. `status` varchar(45) DEFAULT NULL,
  14. `processing_type` varchar(45) DEFAULT NULL,
  15. `notes` varchar(255) DEFAULT NULL,
  16. `parent_id` int(11) DEFAULT NULL,
  17. PRIMARY KEY (`id`),
  18. KEY `fk_parent_idx` (`parent_id`),
  19. CONSTRAINT `fk_parent` FOREIGN KEY (`parent_id`) REFERENCES `task_group` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  21.  
  22. TaskTrees
  23. ParentTaskId references Tasks.TaskId
  24. ChildTaskId references Tasks.TaskId
  25.  
  26. Tasks
  27. TaskId
  28. TaskType simple or group
  29.  
  30. GroupTasks
  31. TaskId references Tasks.TaskId
  32. <group specific columns>
  33.  
  34. SimpleTasks
  35. TaskId references Tasks.TaskId
  36. <other specific columns>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement