Numbering scheme

[Cactus Jack]

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
numbering scheme is based on a max of two digits per level with a max of ten
levels (i.e. 99.99.99.99.99.99.99.99.99.99). I first thought to create my
first initial table with with a 20 digit number colume, and then thought to
build it with ten 2 digit columes, and then thought to use a text colume with
an input mask, and etc. In that most of the data structure will be based on
this primary number I would like to get it started right so I am looking for
thoughts and ideas.

 

[KARL DEWEY]

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

 

[Cactus Jack]

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??

 

[KARL DEWEY]

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