daily pastebin goal
66%
SHARE
TWEET

Untitled

a guest Feb 22nd, 2019 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top