ex8_define.def
$
$ This DEFINE.TES file creates the custom template
$ database for
the M/VISION system (TEST subsystem).
$
$ 1) Define the Schema attributes required:
$
$ --- Material Level ---
$
ATTRIBUTE ADD DESIG CHAR 80 1 -0- “Manufacturer Designation”
ATTRIBUTE ADD CNAME CHAR 80 1 -0- “Common Name”
$
$ --- Specimen Level ---
$
ATTRIBUTE ADD SPECNO CHAR 80 1 -0- “Test Specimen ID”
$
$ --- Test Level ---
$
ATTRIBUTE ADD TEMP REAL 1 1 “deg F” “Test Temperature”
ATTRIBUTE ADD TDATE CHAR 80 1 -0- “Test Date”
ATTRIBUTE,ADD,STRAIN_RANGE,REAL,1,1,”%”,”Strain Range”,”E_RNG”,.01
$
$ --- Source Level ---
$
ATTRIBUTE ADD REF CHAR 80 1 -0- “Source Reference”
ATTRIBUTE ADD FIGURE CHAR 80 1 -0- “Figure Descriptor”
$
$ --- Property Level ---
$
ATTRIBUTE ADD LIFE INT 1 1 “cycles” “Life Time”
$
$ 2) Define the Main Schema Relations:
$
$ Define Hierarchy for Database
$
HIERARCHY ADD MATERIAL SPECIMEN TEST SOURCE
$
RELATION ADD MATERIAL DESIG CNAME
$
RELATION ADD SPECIMEN SPECNO
$
RELATION ADD TEST TEMP STRAIN_RANGE TDATE
$
RELATION ADD SOURCE REF FIGURE
$
RELATION ADD PROPERTY LIFE
$
$ Define Figures
$
ATTRIBUTE ADD EPSRANGVSLIFE REAL 3 0 “cycles; %”,
“Life Time; Strain Range”
RELATION ADD EPSRANGVSLIFE EPSRANGVSLIFE
$
$ Define Scan Image Attribute For future use.
$
ATTRIBUTE ADD SCAN INTEGER 3 0
RELATION ADD SCAN SCAN
$