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

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

bad_ch (Entity)

Description:: @1 bad_ch_seq+
who+
meas_date+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(bad_strips_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
bad_ch_seq (Data Element)
meas_comment (Data Element)

Return to Index

bad_channels_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

bad_ch_data (Entity)

Description:: @1 bad_ch_data_channel+
bad_ch_data_problem+
@2 bad_ch_seq / FKFROM &quotbad_ch.bad_ch_seq(bad_ch_data_rel)"/+
@3 Serial_Number / FKFROM &quotbad_ch.Serial_Number(bad_ch_data_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
bad_ch_data_channel (Data Element)
bad_ch_seq (Data Element)
bad_ch_data_problem (Data Element)

Return to Index

bad_ch_data_channel (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

bad_ch_data_problem (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

bad_ch_data_rel (Relationship)

From Entity: bad_ch
To Entity: bad_ch_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

bad_ch_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

bad_strips_rel (Relationship)

From Entity: simain
To Entity: bad_ch
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

batch_number (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

coupling_capac (Entity)

Description:: @1 coup_cap_seq+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(coupling_capac_rel)"/+
who+
meas_date+
temp+
humidity+
meas_comment
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
coup_cap_seq (Data Element)
meas_comment (Data Element)

Return to Index

coupling_capac_data (Entity)

Normalize: T
Description:: @1 coup_cap_data_seq+
coup_cap_data+
@2 coup_cap_seq / FKFROM &quotcoupling_capac.coup_cap_seq(coupling_capac_data_rel)"/+
@3 Serial_Number / FKFROM &quotcoupling_capac.Serial_Number(coupling_capac_data_rel)"/
Definitions Used:: Serial_Number (Data Element)
coup_cap_seq (Data Element)
coup_cap_data_seq (Data Element)
coup_cap_data (Data Element)

Return to Index

coupling_capac_data_rel (Relationship)

From Entity: coupling_capac
To Entity: coupling_capac_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

coupling_capac_rel (Relationship)

From Entity: simain
To Entity: coupling_capac
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

coup_cap_bkdn_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

coup_cap_bkdwn (Entity)

Description:: @1 coup_cap_bkdwn_seq+
coup_cap_bkdwn_data+
who+
meas_date+
temp+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(coup_cap_bkdwn_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
coup_cap_bkdwn_seq (Data Element)
coup_cap_bkdwn_data (Data Element)
meas_comment (Data Element)

Return to Index

coup_cap_bkdwn_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

coup_cap_bkdwn_rel (Relationship)

From Entity: simain
To Entity: coup_cap_bkdwn
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

coup_cap_bkdwn_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

coup_cap_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

coup_cap_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

coup_cap_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

coup_cap_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

cv (Entity)

Description:: @1 cv_seq+
who+
meas_date+
temp+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(cv_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
cv_seq (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
meas_comment (Data Element)

Return to Index

cv_data (Entity)

Description:: @1 cv_data_seq+
cv_data_voltage+
cv_data_capacitance+
cv_data_inv_cap2+
@2 cv_seq / FKFROM &quotcv.cv_seq(cv_data_rel)"/+
@3 Serial_Number / FKFROM &quotcv.Serial_Number(cv_data_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
cv_seq (Data Element)
cv_data_seq (Data Element)
cv_data_voltage (Data Element)
cv_data_capacitance (Data Element)
cv_data_inv_cap2 (Data Element)

Return to Index

cv_data_capacitance (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

cv_data_inv_cap2 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

cv_data_rel (Relationship)

From Entity: cv
To Entity: cv_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

cv_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

cv_data_voltage (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

cv_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry of the C/ graph.
Values:
PASS
FAIL

Return to Index

cv_rel (Relationship)

Parent Insert: No_Action
Child Delete: No_Action
Identifying: T
From Entity: simain
To Entity: cv
Parent Update: Cascade
Parent Delete: Restrict
Child Insert: Restrict
Child Update: Restrict

Return to Index

cv_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F
Description:: Part of the compound primary key to uniquely identify a row in the
table. This number is generated by ORACLE.

Return to Index

Date_received (Data Element)

SQL Data Type: DATE
ORACLE Unique: F
Description:: The date the Si Strip detector was received from Micron.

Return to Index

Grade (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 5
ORACLE Unique: F
Description:: A letter grade given to the detector.

Return to Index

guard_ring_current (Entity)

Description:: @1 g_ring_current_seq+
g_ring_V_Bias+
who+
meas_date+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(g_ring_current_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
g_ring_current_seq (Data Element)
g_ring_V_Bias (Data Element)
meas_comment (Data Element)

Return to Index

guard_ring_curr_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

g_ring_current_rel (Relationship)

From Entity: simain
To Entity: guard_ring_current
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

g_ring_current_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

g_ring_data (Entity)

Description:: @1 g_ring_data_seq+
g_ring_data_meas_time+
g_ring_data_current+
g_ring_data_temp+
@2 g_ring_current_seq / FKFROM &quotguard_ring_current.g_ring_current_seq(g_ring_data_rel)"/+
@3 Serial_Number / FKFROM &quotguard_ring_current.Serial_Number(g_ring_data_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
g_ring_current_seq (Data Element)
g_ring_data_seq (Data Element)
g_ring_data_meas_time (Data Element)
g_ring_data_current (Data Element)
g_ring_data_temp (Data Element)

Return to Index

g_ring_data_current (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

g_ring_data_meas_time (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

g_ring_data_rel (Relationship)

From Entity: guard_ring_current
To Entity: g_ring_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

g_ring_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

g_ring_data_temp (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

g_ring_V_Bias (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

humidity (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip (Entity)

Description:: @1 ivstrip_seq+
ivstrip_V1
ivstrip_V2
ivstrip_V3
who
meas_date
temp
humidity
meas_comment
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(ivstrip_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
ivstrip_seq (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
meas_comment (Data Element)
ivstrip_V1 (Data Element)
ivstrip_V2 (Data Element)
ivstrip_V3 (Data Element)

Return to Index

ivstrip_data (Entity)

Description:: @1 ivstrip_data_channel+
ivstrip_data_I1+
ivstrip_data_I2+
ivstrip_data_I3+
@2 ivstrip_seq / FKFROM &quotivstrip.ivstrip_seq(ivstrip_data_rel)"/+
@3 Serial_Number / FKFROM &quotivstrip.Serial_Number(ivstrip_data_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
ivstrip_seq (Data Element)
ivstrip_data_channel (Data Element)
ivstrip_data_I1 (Data Element)
ivstrip_data_I2 (Data Element)
ivstrip_data_I3 (Data Element)

Return to Index

ivstrip_data_channel (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

ivstrip_data_I1 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip_data_I2 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip_data_I3 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip_data_rel (Relationship)

From Entity: ivstrip
To Entity: ivstrip_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

ivstrip_rel (Relationship)

From Entity: simain
To Entity: ivstrip
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

ivstrip_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F
Description:: As number used as part of the compound primary key. This number
is generated automatically by ORACLE for this table.

Return to Index

ivstrip_V1 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip_V2 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivstrip_V3 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivtotal (Entity)

Description:: @1 ivtotal_seq+
ivtotal_V_Bias
who
meas_date
humidity
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(ivtotal_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
ivtotal_seq (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
ivtotal_V_Bias (Data Element)
meas_comment (Data Element)

Return to Index

ivtotal_data (Entity)

Description:: @1 ivtotal_data_seq+
ivtotal_data_meas_time+
ivtotal_data_current+
ivtotal_data_temp+
@2 ivtotal_seq / FKFROM &quotivtotal.ivtotal_seq(ivtotal_data_rel)"/+
@3 Serial_Number / FKFROM &quotivtotal.Serial_Number(ivtotal_data_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
ivtotal_seq (Data Element)
ivtotal_data_seq (Data Element)
ivtotal_data_meas_time (Data Element)
ivtotal_data_current (Data Element)
ivtotal_data_temp (Data Element)

Return to Index

ivtotal_data_current (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivtotal_data_meas_time (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivtotal_data_rel (Relationship)

From Entity: ivtotal
To Entity: ivtotal_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

ivtotal_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

ivtotal_data_temp (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

ivtotal_rel (Relationship)

From Entity: simain
To Entity: ivtotal
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

ivtotal_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F
Description:: Part of the compound primary key to list the measurements made
for the I/ total graph. This number will be automatically created by ORACLE from a equence of numbers used specifically for this purpose.

Return to Index

ivtotal_V_Bias (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

iv_stip_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail entry of the I/ Strip graph..
Values:
PASS
FAIL

Return to Index

iv_total_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass for fail entry of the I/ total graph.
Values:
PASS
FAIL

Return to Index

meas_comment (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 1800
ORACLE Unique: F

Return to Index

meas_date (Data Element)

SQL Data Type: DATE
ORACLE Unique: F

Return to Index

rev_bias_bkdn_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

rev_bias_bkdwn (Entity)

Description:: @1 rev_bias_bkdwn_seq+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(rev_bias_rel)"/+
rev_bias_bkdwn_data+
who+
meas_date+
temp+
humidity+
meas_comment
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
rev_bias_bkdwn_seq (Data Element)
rev_bias_bkdwn_data (Data Element)
meas_comment (Data Element)

Return to Index

rev_bias_bkdwn_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

rev_bias_bkdwn_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

rev_bias_rel (Relationship)

From Entity: simain
To Entity: rev_bias_bkdwn
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

R_interstip_ok (Data Element)

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

Return to Index

R_poly (Entity)

Description:: @1 R_poly_seq+
who+
meas_date+
temp+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(r_poly_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
R_poly_seq (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
meas_comment (Data Element)

Return to Index

R_poly_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F
Description:: The resitance of the poly silicon resistors located on the detector itself.
Measured in Ohms.

Return to Index

R_poly_data (Entity)

Normalize: T
Description:: @1 R_poly_data_seq+
R_poly_data+
@2 R_poly_seq / FKFROM &quotR_poly.R_poly_seq(r_poly_data_rel)"/+
@3 Serial_Number / FKFROM &quotR_poly.Serial_Number(r_poly_data_rel)"/
Definitions Used:: Serial_Number (Data Element)
R_poly_seq (Data Element)
R_poly_data (Data Element)
R_poly_data_seq (Data Element)

Return to Index

r_poly_data_rel (Relationship)

From Entity: R_poly
To Entity: R_poly_data
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

R_poly_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

R_poly_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F
Description:: The pass or fail measurement of the poly silicon resistors.
Values:
PASS
FAIL

Return to Index

r_poly_rel (Relationship)

From Entity: simain
To Entity: R_poly
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

R_poly_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F
Description:: Used as part of the compound primary key. This number is generated
automatically by ORACLE from a sequence of numbers associated with
this table.

Return to Index

Serial_Number (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 50
ORACLE Unique: F
Description:: The serial number of Si Strip detector.

Return to Index

simain (Entity)

Description:: @1 Serial_Number+
batch_number+
Date_received+
Grade+
type_of_coating+
type_of_detector+
meas_comment+
iv_stip_ok+
iv_total_ok+
guard_ring_curr_ok+
cv_ok+
bad_channels_ok+
V_depletion_ok+
R_poly_ok+
R_interstip_ok+
thickness_ok+
coup_cap_ok+
coup_cap_bkdn_ok+
rev_bias_bkdn_ok
Normalize: T
Definitions Used:: Serial_Number (Data Element)
Date_received (Data Element)
Grade (Data Element)
iv_stip_ok (Data Element)
iv_total_ok (Data Element)
cv_ok (Data Element)
V_depletion_ok (Data Element)
R_poly_ok (Data Element)
R_interstip_ok (Data Element)
type_of_coating (Data Element)
type_of_detector (Data Element)
guard_ring_curr_ok (Data Element)
bad_channels_ok (Data Element)
thickness_ok (Data Element)
coup_cap_ok (Data Element)
coup_cap_bkdn_ok (Data Element)
rev_bias_bkdn_ok (Data Element)
batch_number (Data Element)
meas_comment (Data Element)

Return to Index

temp (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

thickness (Entity)

Description:: @1 thickness_seq+
thickness_data+
who+
meas_date+
temp+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(thickness_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
thickness_seq (Data Element)
thickness_data (Data Element)
meas_comment (Data Element)

Return to Index

thickness_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

thickness_ok (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

thickness_rel (Relationship)

From Entity: simain
To Entity: thickness

Return to Index

thickness_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

type_of_coating (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

type_of_detector (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

V_depletion (Entity)

Description:: @1 V_dep_seq+
who+
meas_date+
temp+
humidity+
meas_comment+
@2 Serial_Number / FKFROM &quotsimain.Serial_Number(v_dep_rel)"/
Normalize: T
Definitions Used:: Serial_Number (Data Element)
V_dep_seq (Data Element)
who (Data Element)
meas_date (Data Element)
humidity (Data Element)
temp (Data Element)
meas_comment (Data Element)

Return to Index

V_depletion_data (Entity)

Normalize: T
Description:: @1 V_dep_data_seq+
V_dep_data+
V_dep_method+
@2 V_dep_seq / FKFROM &quotV_depletion.V_dep_seq(v_dep_data_rel)"/+
@3 Serial_Number / FKFROM &quotV_depletion.Serial_Number(v_dep_data_rel)"/
Definitions Used:: Serial_Number (Data Element)
V_dep_seq (Data Element)
V_dep_data (Data Element)
V_dep_method (Data Element)
V_dep_data_seq (Data Element)

Return to Index

V_depletion_ok (Data Element)

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

Return to Index

V_dep_data (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F
Description:: The voltage of depletion measured in Volts.

Return to Index

v_dep_data_rel (Relationship)

From Entity: V_depletion
To Entity: V_depletion_data

Return to Index

V_dep_data_seq (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 20
ORACLE Unique: F

Return to Index

V_dep_method (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 25
ORACLE Unique: F

Return to Index

v_dep_rel (Relationship)

Identifying: T
From Entity: simain
To Entity: V_depletion
Parent Update: Cascade
Parent Delete: Cascade
Child Insert: Restrict
Child Update: Restrict

Return to Index

V_dep_seq (Data Element)

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

Return to Index

who (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 50
ORACLE Unique: F

Return to Index

Return to diagram index