Diagrams


Table

Fault/Resol. Cod. Relationship

Fields

# Name Type
1 Fault Code Code10
2 Symptom Code Code10
3 Fault Area Code Code10
4 Resolution Code Code10
5 Occurrences Integer Editable: No
6 Description Text80
7 Service Item Group Code Code10
8 Created Manually Boolean Editable: No

Keys

# Fields
0 Fault Code,Fault Area Code,Symptom Code,Resolution Code,Service Item Group Code Clustered: Yes
1 Fault Code,Occurrences
2 Fault Area Code,Occurrences
3 Symptom Code,Occurrences
4 Service Item Group Code,Fault Code,Occurrences

Table Relations To Other Tables

Field Related Table Related Field
Fault Area Code Fault Area Code 1..n
Fault Code Fault Code Code 1..n
Resolution Code Resolution Code Code 1..n
Service Item Group Code Service Item Group Code 1..n
Symptom Code Symptom Code Code 1..n

Table Relations From Other Tables

From Table From Field