I would build it like this--
WBS--
WBSID - Autonumber - Primary Key
WBS - text
WBS Title - text
1- 1. Requirements
2- 1.1 Management Requirements
3- 1.2 Drafting Requirements
4- 1.2.1 Materials
5- 1.2.2 Tools - Hardware
6- 1.2.3 Tools - Software
6- 1.2.6 Personal
44- 3. Systems
45- 3.1 Active Systems
46- 3.1.1 Electrical
47- 3.1.2 Mechanical
> I need to create a database structure based on an indentured or indexed "Work
> Breakdown Structure" (WBS) numbering scheme (i.e. 2.5.15.2.7). The
[quoted text clipped - 5 lines]
> this primary number I would like to get it started right so I am looking for
> thoughts and ideas.
Cactus Jack - 16 Aug 2005 17:13 GMT
you idea is a good one but I don't think will work for this application -
elements of the structure will be dictated for each effort. In other words
the government will supply some of the basic numbering and definitions and we
will expand on that laydown to break the work structure into much finer
detail and add structure where it needs to be added or expanded. Each effort
will have different primary structure but always based on a maximum 10 place
indenture structure (99.99.99.99.99.99.99...). For example 1.2 may be
"systems engineering" in one effort and have five or six levels of breakdown
detail (1.2.1.1.1.15) whereas in the next effort 1.2 may be something like
"config management" with only a couple layers of detail. Think of it as
trying to index or track the data in 20 different technical manuals all with
different subjects down to the paragraph or sub paragraph level or even
sentence level. I don't know if that makes any sense but hopefully you get
the idea. I guess the basic problem is with a 10 level indenture number
system where each layer can be any number between 1 and 99
(99.99.99.99.99.99.99.99.99.99) and each layer establishes a parent child
relationship as you move to the right, what is the best way of tabling it.
Maybe just a text field where you type in the X.X.X.X.. number is the way to
go but I'm not sure. Thoughts??
> I would build it like this--
> WBS--
[quoted text clipped - 23 lines]
> > this primary number I would like to get it started right so I am looking for
> > thoughts and ideas.
KARL DEWEY - 16 Aug 2005 18:30 GMT
Yes you can build many tables or many fields.
But I think you can build a table to show your hieraracy.
WBS-WBS--
WBSID WBSID
1 2
1 3
3 4
3 5
3 6
> you idea is a good one but I don't think will work for this application -
> elements of the structure will be dictated for each effort. In other words
[quoted text clipped - 43 lines]
> > > this primary number I would like to get it started right so I am looking for
> > > thoughts and ideas.