7. Introduction to the Databases > 7.3 About the SWSystem Database

Introduction to the Databases

Work breakdown structure
The ShipWeight 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 ShipWeight 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, ShipWeight 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