|
<< Click to Display Table of Contents >> Navigation: Introduction to the Databases > 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.