How to structure data... Sequential or Hierarchical?
        Posted  
        
            by Ryan
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Ryan
        
        
        
        Published on 2010-04-14T09:32:39Z
        Indexed on 
            2010/04/14
            19:23 UTC
        
        
        Read the original article
        Hit count: 206
        
I'm going through the exercise of building a CMS that will organize a lot of the common documents that my employer generates each time we get a new sales order. Each new sales order gets a 5 digit number (12222,12223,122224, etc...) but internally we have applied a hierarchy to these numbers:
+ 121XX
|--01
|--02
+ 122XX
|--22
|--23
|--24
In my table for sales orders, is it better to use the 5 digital number as an ID and populate up or would it be better to use the hierarchical structure that we use when referring to jobs in regular conversation? The only benefit to not populating sequentially seems to be formatting the data later on in my view, but that doesn't sound like a good enough reason to go through the extra work.
Thanks
© Stack Overflow or respective owner