7.1 Overview of the Databases

<< Click to Display Table of Contents >>

Navigation:  7. Introduction to the Databases >

7.1 Overview of the Databases

Introduction to the Databases

Basically, ShipWeight needs three SQL-databases to run:

SW00_ProjectName: For storage of project specific information, e.g. weight, CoG and defined parameters.

The name of the database is made up of a prefix and the Project name.

The prefix is used to determine which Work Breakdown Structure the project belongs to and to isolate projects in this WBS from projects from other WBS.  Sample of WBS and prefix setup:

Prefix

Work Breakdown Structure

SW00_

ShipWeight

SW01_

RigWeight

SW02_

PBSWeight

SW03_

MaradWeight

SW04_

SWBSWeight

SW05_

IMPWeight

 

SWSystem: Contains general information used by all projects, e.g. information of the work breakdown structures, estimation methods, definition of parameters.

sdb_ShipDB: This is the historical database containing information exported from completed projects. The historical database is used for estimation. This database will not be explained.

SWLogin: This is the database that holds the information on users, user groups and permissions.