System Architect Definitions, Encyclopedia:"C:\SYSARCH\PROJECT\MCMCABLE\"

System Architect Definitions "C:\SYSARCH\PROJECT\MCMCABLE\"

cable_id (Data Element)
continuity_comment (Data Element)
continuity_ok (Data Element)
electrial_ok (Data Element)
elec_channel_id (Data Element)
gold_adhesion_ok (Data Element)
mcmcable (Entity)
mcmcableid_fk (Relationship)
mcm_electrical_test (Entity)
R_ok (Data Element)
R_without_shortingbar (Data Element)
R_with_shortingbar (Data Element)
visual_comment (Data Element)
visual_ok (Data Element)


cable_id (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The identification number of the mcm cable.


Return to Index


continuity_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F
Description: A comment field for the continuity test.


Return to Index


continuity_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry from the continuity test.
Values:
PASS
FAIL


Return to Index


electrial_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the gold adhesion test
Values:
PASS
FAIL


Return to Index


elec_channel_id (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 5
ORACLE Unique: F
Description:
This is the idenfication number of the channel. There are 48 channels.


Return to Index


gold_adhesion_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the gold adhesion test
Values
PASS
FAIL


Return to Index


mcmcable (Entity)

Description:
@cable_id
gold_adhesion_ok
visual_ok
electrial_ok
visual_comment

Normalize: T
Definitions Used:
cable_id (Data Element)
gold_adhesion_ok (Data Element)
visual_ok (Data Element)
electrial_ok (Data Element)
visual_comment (Data Element)


Return to Index


mcmcableid_fk (Relationship)

Identifying: T
From Entity: mcmcable
To Entity: mcm_electrical_test
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict


Return to Index


mcm_electrical_test (Entity)

Normalize: T
Description:
@1 elec_channel_id+
continuity_ok+
continuity_comment+
R_with_shortingbar+
R_without_shortingbar+
R_ok+
@2 cable_id / FKFROM &quotmcmcable.cable_id(mcmcableid_fk)"/

Definitions Used:
cable_id (Data Element)
elec_channel_id (Data Element)
continuity_ok (Data Element)
continuity_comment (Data Element)
R_with_shortingbar (Data Element)
R_without_shortingbar (Data Element)
R_ok (Data Element)


Return to Index


R_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 5
ORACLE Unique: F
Description:
The pass or fail entry of the Resistance measurements.
Values
PASS
FAIL


Return to Index


R_without_shortingbar (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resitance measured in Ohms without the shorting bar.


Return to Index


R_with_shortingbar (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resitance measured in Ohms with the shorting bar.


Return to Index


visual_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F
Description: A comment field for the visual testing.


Return to Index


visual_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the visual inspection test
Values
PASS
FAIL


Return to Index


Return to diagram index