7. Introduction to the Databases > 7.1 Overview of 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.