Appendix B, Vitals Database Reference
E.H. Wachs Part No. 79-MAN-04, Rev. I 215
Appendix B
Vitals Database
Reference
The Vitals database is stored in MS Access format. Vitals
has its own file type, with a
.vcd file extension.
There are 6 tables in the database. Four of them store the
valve and activity data:
•
Valves, which contains information about the valves and
has a unique ValveID for each valve.
•
Activities, which contains activity data and is linked to
the Valve table by ValveID. Each activity has its own
ActivityID.
•
TorqueCharts, which contains torque information for
each activity and is linked to the Activity table by
ActivityID.
•
Remarks, which contains pre-defined remarks that the
user can select while doing an activity.
The other 2 tables store customer and database information:
•
Vitals contains version and administrator information.
•
Fields contains settings and field lookup information.
TABLE STRUCTURE
The following charts illustrate the field structure of each
Vitals database table.