Databases
StackOverflow2013
Postsdbo
PO2 Database Design Questions. hierarchy tree
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO2 Database Design Questions. hierarchy tree
    primarykey
    data
    text
    <p>1.) I have a DB where each entry represents a task. And out of several dozens or even a hundred of task, there will be a special task (which is a milestone)<br> So, in this case, I have very few entries that requires an extra field to separate them from the majority.</p> <p>I don't want to create a second table, because this is the only fields that makes these milestone stone special, they share a lot of other fields with regular tasks entries.</p> <p>Should I create another field just to hold a few TRUEs while the rest are FALSE by defaul</p> <p>2.) For each of those tasks, it has a variable number of performers (depending on user input) (To further things, each performer has multiple sub-performers of its own.) So I essentially am using a DB to describe a TREE structure.The way I have it now is, I will have 5 copies of the same task info if there are 5 performers, and occupy 5 entries. Is this the way to go if I'm not going to have more than 10,000 entries (incl. copies) in my DB</p> <p>Thank you</p> <p>This should clarify it</p> <ol> <li><p>Task1 (this is a milestone task)</p> <ul> <li>performer1 <ul> <li>sub-performer ID=21</li> <li>sub-performer ID=542</li> </ul></li> <li>performer2</li> </ul></li> <li><p>Task2 (this is not a milestone task)</p> <ul> <li>performer2 <ul> <li>sub-performer ID=231</li> </ul></li> </ul></li> </ol> <p>Subperformer and performer are completely different group. No overlap at all. Subperformer are the group that provide inputs to performer, so performer can complete the task they're assigned to.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWilliam Sham
    1. USWilliam Sham
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIm not suer what performers are - Are they assignees to the task or are they the "subtasks"?
      singulars
      1. PO2 Database Design Questions. hierarchy tree
      1. USprodigitalson
    2. COis a performer a sub-task ? a person ? whats a sub person ?
      singulars
      1. PO2 Database Design Questions. hierarchy tree
      1. USDavid Chan
    3. COIs performer to task a n-1 relation or a n-m relation? Is performer to sub-performer 1-n or n-m? Can a performer be sub-performer? Can a performer be a sub-performer of himself?
      singulars
      1. PO2 Database Design Questions. hierarchy tree
      1. USHyperboreus
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload