|
<< Click to Display Table of Contents >> Navigation: Introduction to the Databases > About the SWSystem Database |
Work breakdown structure
The MassTrack work breakdown structure is defined in the POST-table. The post table contains three fields:
SystemID |
ID of the WBS |
|||
sPostID |
ID of the weight-group, e.g. H1.1 |
|||
sPostName |
Name of the weight group, e.g. Afterbody |
|||
sPostOver |
ID of the parent weight-group, e.g. H1 |
|||
Parameters
The parameters available in MassTrack are found in the tables FATT (float), IATT (integer) and TATT (text). The FATT-table contains the following fields:
sFattId |
ID of parameter |
|||
sFAttName |
Name of parameter |
|||
sUnit |
Unit |
|||
sFAttSymb |
||||
fFASIFak |
Factor |
|||
fMax |
Maximum allowed value |
|||
iDecimals |
Number of decimals |
|||
The parameter-ID consists of two to four characters and is subject to strict naming rules. The syntax of the ID is:
{unit}{area}{object}
The first character in the id, the “unit”, is always small letter. It tells what type of parameter this is. The most important are:
a |
Area |
[m2] |
|||||
b |
Breadth |
[m] / [mm] |
|||||
d |
Distance |
[m] / [mm] |
|||||
e |
Power |
[kW] / [kVA] / [t] |
|||||
f |
Percentage |
[%] |
|||||
h |
Height |
[m] / [mm] |
|||||
n |
Number of |
||||||
l |
Length |
[m] / [mm] |
|||||
q |
Capacity |
[t/h] / [m3/h] |
|||||
s |
Specific weight |
[t/m3] |
|||||
t |
Thickness |
[mm] |
|||||
v |
Volume |
[m3] |
|||||
w |
Weight |
[t] |
|||||
A complete list of the unit-codes is found in the UNIT-table in WeightDB
The “area” code of the id is optional. If present, it is also a second small letter. It tells which area of the project the parameter belongs to. The most commonly used are:
a |
Afterbody |
c |
Cargo-area |
d |
Deckhouse |
e |
Engine-area |
f |
Forebody |
g |
Galley |
i |
Small deckhouse |
k |
Keel |
m |
Main hull |
n |
Accommodation |
o |
Forecastle |
p |
Poop |
s |
Superstructure |
u |
Upper area |
w |
Wheelhouse |
The full list of area-codes can be found in the table AREA in the WeightDB database.
The “object” code consists of two capitalized letters and is also optional. If present, it tells which object the parameter belongs to. The most common abbreviations are:
BP |
Bottom plating |
|
BW |
Bulwark |
|
DK |
Deck |
|
DS |
Double sides |
|
ER |
Engine room |
|
FO |
Foundations |
|
HC |
Hatch coamings |
|
HT |
Hatches |
|
IB |
Inner bottom |
|
LB |
Longitudinal bulkheads |
|
LT |
Longitudinal and transverse |
|
SH |
Shell |
|
SP |
Side plates |
|
TB |
Transverse bulkheads |
|
A complete list of available object-codes can be found in the OBJECT-table in WeightDB.
Examples of parameters:
lk |
Length keel |
|
aBW |
Area BulWark |
|
acLB |
Area cargo-area Longitudinal Bulkheads |
|
teSH |
Plate thickness engine area Shell |
|
In addition to the float-, integer- and text parameters, MassTrack includes a set of calculated parameters. The definition of these can be found in the CATT-table. The CATT-table contains four fields:
sCAttID |
ID of calculated parameter |
|||
sCAttName |
Name of parameter |
|||
sUnit |
Unit |
|||
sCAttExp |
Formula for calculating the parameter |
|||