<< Click to Display Table of Contents >> Navigation: Introduction to the Databases > About the SW0x_Project Database |
Note!
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 |