About the SWSystem Database

<< Click to Display Table of Contents >>

Navigation:  Introduction to the Databases >

About the SWSystem Database

Introduction to the Databases

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