About the SW0x_Project Database

<< Click to Display Table of Contents >>

Navigation:  Introduction to the Databases >

About the SW0x_Project Database

Introduction to the databases

clip0012Note!
A project database can hold any number of projects. Each project is uniquely identified by a ProjectID. The ProjectID is found in every table of the Project database.

Project Info
The information found in the Project Info window of MassTrack can be found in the SHIP-table. This includes Name, Owner, Main type, Sub type, Build year, Frame spacing etc.

Weight, Center of Gravity and Extension
Information of Weight, Center of Gravity and Extension for each weight item can be found in the ITEMS-table.

The ITEMS-table contains 123 columns/fields. These are:

 

WgtGrp

The name of the weight-group the weight-item belongs to.

ItemNo

An id-number for the weight-item (unique within the weight group).

Description

Name of the weight-item.

RegUser

Name of the user who created the weight-item.

RegDate

Date of registration.

NoOff

Quantity #1

Factor

Quantity #2

Length

Quantity #3

Width

Quantity #4

UnitWeight

Quantity #5

VCG

Vertical center of gravity

LCG

Longitudinal center of gravity

TCG

Transversal center of gravity

VCG_min

Minimum vertical extension

VCG_max

Maximum vertical extension

LCG_min

Minimum longitudinal extension

LCG_max

Maximum longitudinal extension

TCG_min

Minimum transversal extension

TCG_max

Maximum transversal extension

C01-C99

Code-field number 01-99

EditUser

Used for Row-lock in the Items window

EditDate

Used for Row-lock in the Items window

UniqueNo

An integer to uniquely identify each weight item. The UniqueNo field is automatically assigned.

The total weight and CoG for each weight-group is available in the SHIP_POST-table. The SHIP_POST-table contains five fields. The three most important are:

ProjectID

ID to uniquely identify each project in the database.

sPostID

The name of the weight-group, e.g. LW

sType

Type of information. A = Aft, F = Fore, L = LCG, V = VCG, T = TCG, W = Weight, P=port side (TCG_min), S=starboard (TCG_max), B=bottom (VCG_min), U=up (VCG_max)

fValue

Value. Records of type V, L, T, P, S, A, F, B and U are given in meters, while records of type W is given in tons.

 

 

Parameters

Various parameters, such as lengths, areas, volumes etc. can be found in three tables: SHIP_FATT (float parameters), SHIP_IATT (integer parameters) and SHIP_TATT (text parameters).

The SHIP_FATT-table includes two columns/fields:

ProjectID

ID to uniquely identify each project in the database.

sFAttID

ID of the parameter

fFAttValue


Value of the parameter.

Likewise the SHIP_IATT and SHIP_TATT include a field for ID and a field for value.

The full name of the parameter can be found in the WeightDB database (see next page).

The parameters found in the Main Project Parameters window are:

lm

Ship length over all

lPE

Length betw. perp.

bm

Ship breadth

hDU

Depth upperm. cont. deck

hDM

Depth to maindeck

dCW

Draught, CWL

dm

Scantling draught

wDP

Displacement

nPA

Numb. passengers

nCR

Numb. crew

nCS

Numb. cars

nCO

Numb. containers

vGO

Gross tonnage

vNT

Net tonnage

wDW

Deadweight

eME

Main-engine power

nME

Numb. main engines

iME

Rot. speed main-engine

om

Service-speed

dPR

Propeller diameter

zmMA

Main-hull material

zlC

Ice-class

kmCB

Block-coefficient

ParameterWnd_MainParameters