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

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

connector_1_ok (Data Element)
connector_2_ok (Data Element)
connector_3_ok (Data Element)
connector_4_ok (Data Element)
connector_5_ok (Data Element)
connector_6_ok (Data Element)
daughterboard (Entity)
daughterboard_id (Data Element)
deul_op_amp_ok (Data Element)
dghtrboardid_fk1 (Relationship)
dghtrboard_fk2 (Relationship)
dghtr_electrical_test (Entity)
dghtr_functionality (Entity)
electrial_ok (Data Element)
func_ok (Data Element)
func_seq (Data Element)
LVDS_1_ok (Data Element)
LVDS_2_ok (Data Element)
LVDS_3_ok (Data Element)
LVDS_4_ok (Data Element)
LVDS_5_ok (Data Element)
LVDS_6_ok (Data Element)
mother_connector_ok (Data Element)
open_short_comment (Data Element)
open_short_ok (Data Element)
PECL_ok (Data Element)
power_elect_seq (Data Element)
R1 (Data Element)
R2 (Data Element)
R3 (Data Element)
R4 (Data Element)
R5 (Data Element)
R6 (Data Element)
R7 (Data Element)
R8 (Data Element)
R9 (Data Element)
visual_ok (Data Element)


connector_1_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 1st MCM output connector.
Values:
PASS
FAIL


Return to Index


connector_2_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 2nd MCM output connector.
Values:
PASS
FAIL


Return to Index


connector_3_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 3rd MCM output connector.
Values:
PASS
FAIL


Return to Index


connector_4_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 4th MCM output connector.
Values:
PASS
FAIL


Return to Index


connector_5_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 5th MCM output connector.
Values:
PASS
FAIL


Return to Index


connector_6_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the 6th MCM output connector.
Values:
PASS
FAIL


Return to Index


daughterboard (Entity)

Description:
@1 daughterboard_id+
visual_ok+
electrial_ok+
func_ok

Normalize: T
Definitions Used:
visual_ok (Data Element)
electrial_ok (Data Element)
func_ok (Data Element)
daughterboard_id (Data Element)


Return to Index


daughterboard_id (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The daughter board identification number. There are two types of boards. They will be labelled letter-#, for example A-1, B-23.


Return to Index


deul_op_amp_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the Duel Op-Amp test.
Values:
PASS
FAIL


Return to Index


dghtrboardid_fk1 (Relationship)

Identifying: T
From Entity: daughterboard
To Entity: dghtr_electrical_test
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict


Return to Index


dghtrboard_fk2 (Relationship)

Identifying: T
From Entity: daughterboard
To Entity: dghtr_functionality
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict


Return to Index


dghtr_electrical_test (Entity)

Normalize: T
Description:
@1 power_elect_seq+
open_short_ok+
open_short_comment+
R1+
R2+
R3+
R4+
R5+
R6+
R7+
R8+
R9+
connector_1_ok+
connector_2_ok+
connector_3_ok+
connector_4_ok+
connector_5_ok+
connector_6_ok+
mother_connector_ok+
@2 daughterboard_id / FKFROM &quotdaughterboard.daughterboard_id(dghtrboardid_fk1)"/

Definitions Used:
power_elect_seq (Data Element)
open_short_ok (Data Element)
open_short_comment (Data Element)
R1 (Data Element)
R2 (Data Element)
R3 (Data Element)
R4 (Data Element)
R5 (Data Element)
R6 (Data Element)
R7 (Data Element)
R8 (Data Element)
R9 (Data Element)
connector_1_ok (Data Element)
connector_2_ok (Data Element)
connector_3_ok (Data Element)
connector_4_ok (Data Element)
connector_5_ok (Data Element)
connector_6_ok (Data Element)
mother_connector_ok (Data Element)
daughterboard_id (Data Element)


Return to Index


dghtr_functionality (Entity)

Normalize: T
Description:
@1 func_seq+
LVDS_1_ok+
LVDS_2_ok+
LVDS_3_ok+
LVDS_4_ok+
LVDS_5_ok+
LVDS_6_ok+
PECL_ok+
deul_op_amp_ok+
@2 daughterboard_id / FKFROM &quotdaughterboard.daughterboard_id(dghtrboard_fk2)"/

Definitions Used:
func_seq (Data Element)
LVDS_1_ok (Data Element)
LVDS_2_ok (Data Element)
LVDS_3_ok (Data Element)
LVDS_4_ok (Data Element)
LVDS_5_ok (Data Element)
LVDS_6_ok (Data Element)
PECL_ok (Data Element)
deul_op_amp_ok (Data Element)
daughterboard_id (Data Element)


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 electrical test.
Values:
PASS
FAIL


Return to Index


func_ok (Data Element)

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


Return to Index


func_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
Part of the compound primary key. This number is automatically generated by ORACLE.


Return to Index


LVDS_1_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 1st LVDS translator.
Values:
PASS
FAIL


Return to Index


LVDS_2_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 2nd LVDS translator.
Values:
PASS
FAIL


Return to Index


LVDS_3_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 2nd LVDS translator.
Values:
PASS
FAIL


Return to Index


LVDS_4_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 4th LVDS translator.
Values:
PASS
FAIL


Return to Index


LVDS_5_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 5th LVDS translator.
Values:
PASS
FAIL


Return to Index


LVDS_6_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the 6th LVDS translator.
Values:
PASS
FAIL


Return to Index


mother_connector_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the mapping of the Mother Board connector.
Values:
PASS
FAIL


Return to Index


open_short_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F
Description:
Comments for the open/ test.


Return to Index


open_short_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the open or short check.
Values:
PASS
FAIL


Return to Index


PECL_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
The pass or fail entry for the PECL clock fanout.
Values:
PASS
FAIL


Return to Index


power_elect_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:
Part of the compound primary key used to uniquely identify this table.
This number will automatically be generated by ORACLE.


Return to Index


R1 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 1st high speed bus terminator measured in Ohms.


Return to Index


R2 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 2nd high speed bus terminator measured in Ohms.


Return to Index


R3 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 3rd high speed bus terminator measured in Ohms.


Return to Index


R4 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 4th high speed bus terminator measured in Ohms.


Return to Index


R5 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 5th high speed bus terminator measured in Ohms.


Return to Index


R6 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 6th high speed bus terminator measured in Ohms.


Return to Index


R7 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 7th high speed bus terminator measured in Ohms.


Return to Index


R8 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 8th high speed bus terminator measured in Ohms.


Return to Index


R9 (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F
Description: The resistance of the 9th high speed bus terminator measured in Ohms.


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