Database Management Reference Manual
Introduction to Database Concepts : Project
Project
Project Organisation
In order to create data, you must first create a Project.
A Project consists of:
•
One each of System, Comms, and Misc DBs
•
Multiple Design, Catalogue, Drawing, and Dictionary DBs
•
Various picture files
A project starts with just the System, Comms and Misc DBs.
You will then have to create other DBs for users to work on. The various visible DB types are:
System
Contains details on DBs, MDBs, teams etc in the project
Dictionary
Contains UDA and UDET definitions
Property
Contains units for different properties
Catalogue
Contains catalogue and specification information
MODEL
Contains Plant design information
DRAW
Contains drawing information
SPOOL
Contains spool information
Materials
Contains hull material information
Diagrams
Contains Schematic information
Transaction
Used by Global to record transactions
SCHEMATIC
Contains PI&D (Schematic) information
MANU
Contains detailed manufacturing data
NSEQ
Stores name sequences
Typically there will be many DBs of each type within a project.
An example of a simple project is as follows:
DBs may be included from other projects.
Each DB has a unique DB number. User DBs have numbers in the range 1-7000. The range 7000-8000 is reserved for AVEVA supplied databases. The range 8000-8192 is reserved for system databases.
The DB number is assigned to the DB on creation. You may specify the DB number. If not specified by you then the next available DB number is used.
There may never be two DBs with the same DB number in a single project. Thus to include a DB from another project, that DB number must be unused in the target project.
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo