Appendix D — Database definition
Version 4.0 database definition
The AWA database is an Access 97 database (.mdb) it can also be converted to an Access
2000 database and be used by the AWA. The Access database is divided into several tables.
The motor information and test results data is contained in the following tables: MotorID,
TestResults, TestResultsParameters, TestResultsPI, TestResultsPrgHiPot, and
SurgeWaveform. The testing criteria used to run the tests are contained in the following
tables: TestId, TestIdPrgHiPot, and RefSrgWaveform. Two addition tables are used, one is the
DatabaseInfo table and the other is the Route table.
Nameplate table—(MotorID)
The MotorID table contains the nameplate information for each motor added to the database.
There is only one motor record per motor. The motor_key is the primary keyed field. It is
automatically generated when a new motor is added. The Motor ID field is a unique identifier
that the user gives each motor.
Table 28.
Field name descriptions.
Field name
Type
Description
motor_key
Long integer
Automatically generated
number used as the primary
key.
tree_level_1
Text (25)
First level used in the tree
view. Motor location 1 user
defined field label, defaults to
Location.
tree_level_2
Text (25)
Second level used in the tree
view. Motor location 2 user
defined field label, defaults to
Building.
motor_id
Text (30)
User entered Motor
Identification value. It must
be unique.
manuf
Text (25)
Manufacturer of the motor.
manuf_type
Text (25)
NEMA MG 1 requires
manufacturer’s type but may
vary depending on
manufacturer.
manuf_date_code
Text (16)
Manufacturer’s nameplate
date.
model
Text (25)
Manufacture’s Identification
of model type.
sn
Text (25)
Manufacture’s serial number.
hpkw
Single
Nameplate horse power or
kilowatts.
rpm
Single
Revolutions per minute
(RPM).
Содержание AWAIV-12
Страница 1: ...SKF Static Motor Analyzer Baker AWA IV User manual ...
Страница 2: ......
Страница 14: ...xii SKF Static Motor Analyzer Baker AWA IV User Manual Table of Contents ...
Страница 16: ...2 SKF Static Motor Analyzer Baker AWA IV User Manual About this manual ...
Страница 28: ...14 SKF Static Motor Analyzer Baker AWA IV User Manual Baker AWA IV Instrument Overview ...
Страница 88: ...74 SKF Static Motor Analyzer Baker AWA IV User Manual Database management and maintenance ...
Страница 90: ...76 SKF Static Motor Analyzer Baker AWA IV User Manual Set up of the Baker AWA IV analyzer ...
Страница 91: ...SKF Static Motor Analyzer Baker AWA IV User Manual 77 Set up of the Baker AWA IV analyzer ...
Страница 92: ...78 SKF Static Motor Analyzer Baker AWA IV User Manual Set up of the Baker AWA IV analyzer ...
Страница 124: ...110 SKF Static Motor Analyzer Baker AWA IV User Manual Special features of the Baker AWA IV ...
Страница 166: ...152 SKF Static Motor Analyzer Baker AWA IV User Manual Typical winding faults ...
Страница 180: ...166 SKF Static Motor Analyzer Baker AWA IV User Manual ...
Страница 181: ...SKF Static Motor Analyzer Baker AWA IV User Manual 167 ...
Страница 182: ...168 SKF Static Motor Analyzer Baker AWA IV User Manual ...
Страница 194: ...180 SKF Static Motor Analyzer Baker AWA IV User Manual Using the Baker ZTX with Baker AWA IV analyzers ...
Страница 210: ...196 SKF Static Motor Analyzer Baker AWA IV User Manual ...
Страница 234: ...220 SKF Static Motor Analyzer Baker AWA IV User Manual ...
Страница 240: ...226 SKF Static Motor Analyzer Baker AWA IV User Manual Glossary ...
Страница 248: ...234 SKF Static Motor Analyzer Baker AWA IV User Manual Index ...
Страница 249: ......