System Architect Diagram "PADSIDBS"

&quotPADSIDBS" (Physical Data Model) diagram
Return to diagram index

Symbol Index for &quotPADSIDBS" diagram

Index:

psimain (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotSerial_Number"
@2&quotBatch_Number"
&quotDate_received"
&quotGrade"
&quottype_of_detector"
&quotmeas_comment"
&quotiv_pad_ok"
&quotiv_total_ok"
&quotguard_ring_curr_ok"
&quotcv_ok"
&quotbad_channels_ok"
&quotV_depletion_ok"
&quotR_poly_ok"
&quotR_interpad_ok"
&quotthickness_ok"
&quotcoup_cap_ok"
&quotcoup_cap_bkdn_ok"

Definitions Used:
Serial_Number (Column)
Batch_Number (Column)
Date_received (Column)
Grade (Column)
type_of_detector (Column)
meas_comment (Column)
iv_pad_ok (Column)
iv_total_ok (Column)
guard_ring_curr_ok (Column)
cv_ok (Column)
bad_channels_ok (Column)
V_depletion_ok (Column)
R_poly_ok (Column)
R_interpad_ok (Column)
thickness_ok (Column)
coup_cap_ok (Column)
coup_cap_bkdn_ok (Column)

Return to diagram

pcoup_cap_bkdwn (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotcoup_cap_bkdwn_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotcoup_cap_bkdwn_data"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(coup_cap_bkdwn_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(coup_cap_bkdwn_rel)" /

Definitions Used:
coup_cap_bkdwn_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
coup_cap_bkdwn_data (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pivpad (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotivpad_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotivpad_V1"
&quotivpad_V2"
&quotivpad_V3"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(ivpad_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(ivpad_rel)" /

Definitions Used:
ivpad_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
ivpad_V1 (Column)
ivpad_V2 (Column)
ivpad_V3 (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pthickness (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotthickness_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotthickness_data"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(thickness_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(thickness_rel)" /

Definitions Used:
thickness_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
thickness_data (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pcv (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotcv_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(cv_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(cv_rel)" /

Definitions Used:
cv_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pguard_ring_current (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotg_ring_current_seq"
&quotwho"
&quotmeas_date"
&quotg_ring_V_Bias"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(g_ring_current_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(g_ring_current_rel)" /

Definitions Used:
g_ring_current_seq (Column)
who (Column)
meas_date (Column)
g_ring_V_Bias (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pcoupling_capac (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotcoup_cap_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(coupling_capac_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(coupling_capac_rel)" /

Definitions Used:
coup_cap_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pivpad_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotivpad_data_row"
@2&quotivpad_data_column"
&quotivpad_data_I1"
&quotivpad_data_I2"
&quotivpad_data_I3"
@3&quotivpad_seq" / FKFROM &quotpivpad.ivpad_seq(ivpad_data_rel)" /
@4&quotSerial_Number" / FKFROM &quotpivpad.Serial_Number(ivpad_data_rel)" /
@5&quotBatch_Number" / FKFROM &quotpivpad.Batch_Number(ivpad_data_rel)" /

Definitions Used:
ivpad_data_row (Column)
ivpad_data_column (Column)
ivpad_data_I1 (Column)
ivpad_data_I2 (Column)
ivpad_data_I3 (Column)
ivpad_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pR_poly (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotR_poly_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(r_poly_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(r_poly_rel)" /

Definitions Used:
R_poly_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pivtotal (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotivtotal_seq"
&quotwho"
&quotmeas_date"
&quotivtotal_V_Bias"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(ivtotal_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(ivtotal_rel)" /

Definitions Used:
ivtotal_seq (Column)
who (Column)
meas_date (Column)
ivtotal_V_Bias (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pcv_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotcv_data_seq"
&quotcv_data_voltage"
&quotcv_data_capacitance"
@2&quotcv_seq" / FKFROM &quotpcv.cv_seq(cv_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpcv.Serial_Number(cv_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpcv.Batch_Number(cv_data_rel)" /

Definitions Used:
cv_data_seq (Column)
cv_data_voltage (Column)
cv_data_capacitance (Column)
cv_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pg_ring_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotg_ring_data_seq"
&quotg_ring_data_meas_time"
&quotg_ring_data_current"
&quotg_ring_data_temp"
@2&quotg_ring_current_seq" / FKFROM &quotpguard_ring_current.g_ring_current_seq(g_ring_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpguard_ring_current.Serial_Number(g_ring_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpguard_ring_current.Batch_Number(g_ring_data_rel)" /

Definitions Used:
g_ring_data_seq (Column)
g_ring_data_meas_time (Column)
g_ring_data_current (Column)
g_ring_data_temp (Column)
g_ring_current_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pV_depletion (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotV_dep_seq"
&quotwho"
&quotmeas_date"
&quottemp"
&quothumidity"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(v_dep_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(v_dep_rel)" /

Definitions Used:
V_dep_seq (Column)
who (Column)
meas_date (Column)
temp (Column)
humidity (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pbad_ch (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotbad_ch_seq"
&quotwho"
&quotmeas_date"
&quotmeas_comment"
@2&quotSerial_Number" / FKFROM &quotpsimain.Serial_Number(bad_strips_rel)" /
@3&quotBatch_Number" / FKFROM &quotpsimain.Batch_Number(bad_strips_rel)" /

Definitions Used:
bad_ch_seq (Column)
who (Column)
meas_date (Column)
meas_comment (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pbad_ch_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotbad_ch_data_row"
@2&quotbad_ch_data_column"
&quotbad_ch_data_problem"
@3&quotbad_ch_seq" / FKFROM &quotpbad_ch.bad_ch_seq(bad_ch_data_rel)" /
@4&quotSerial_Number" / FKFROM &quotpbad_ch.Serial_Number(bad_ch_data_rel)" /
@5&quotBatch_Number" / FKFROM &quotpbad_ch.Batch_Number(bad_ch_data_rel)" /

Definitions Used:
bad_ch_data_row (Column)
bad_ch_data_column (Column)
bad_ch_data_problem (Column)
bad_ch_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pR_poly_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotR_poly_data_seq"
&quotR_poly_data"
@2&quotR_poly_seq" / FKFROM &quotpR_poly.R_poly_seq(r_poly_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpR_poly.Serial_Number(r_poly_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpR_poly.Batch_Number(r_poly_data_rel)" /

Definitions Used:
R_poly_data_seq (Column)
R_poly_data (Column)
R_poly_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pivtotal_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotivtotal_data_seq"
&quotivtotal_data_meas_time"
&quotivtotal_data_current"
&quotivtotal_data_temp"
@2&quotivtotal_seq" / FKFROM &quotpivtotal.ivtotal_seq(ivtotal_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpivtotal.Serial_Number(ivtotal_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpivtotal.Batch_Number(ivtotal_data_rel)" /

Definitions Used:
ivtotal_data_seq (Column)
ivtotal_data_meas_time (Column)
ivtotal_data_current (Column)
ivtotal_data_temp (Column)
ivtotal_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pV_depletion_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotV_dep_data_seq"
&quotV_dep_data"
&quotV_dep_method"
@2&quotV_dep_seq" / FKFROM &quotpV_depletion.V_dep_seq(v_dep_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpV_depletion.Serial_Number(v_dep_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpV_depletion.Batch_Number(v_dep_data_rel)" /

Definitions Used:
V_dep_data_seq (Column)
V_dep_data (Column)
V_dep_method (Column)
V_dep_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

pcoupling_capac_data (Table)
Database Name: master
Owner Name: dbo
Database Name: master
Owner Name: dbo
Description:
@1&quotcoup_cap_data_seq"
&quotcoup_cap_data"
@2&quotcoup_cap_seq" / FKFROM &quotpcoupling_capac.coup_cap_seq(coupling_capac_data_rel)" /
@3&quotSerial_Number" / FKFROM &quotpcoupling_capac.Serial_Number(coupling_capac_data_rel)" /
@4&quotBatch_Number" / FKFROM &quotpcoupling_capac.Batch_Number(coupling_capac_data_rel)" /

Definitions Used:
coup_cap_data_seq (Column)
coup_cap_data (Column)
coup_cap_seq (Column)
Serial_Number (Column)
Batch_Number (Column)

Return to diagram

master (Database)

Return to diagram

v_dep_data_rel (Constraint)
To Owner Name: dbo
Database Name: master
From Owner Name: dbo
From Table: pV_depletion

Return to diagram

v_dep_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pV_depletion
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pV_depletion
Identifying: F
Parent Delete: Cascade

Return to diagram

thickness_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pthickness
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pthickness
Identifying: F

Return to diagram

r_poly_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pR_poly
To Owner Name: dbo
To Table: pR_poly_data
Database Name: master
From Owner Name: dbo
From Table: pR_poly
To Owner Name: dbo
To Table: pR_poly_data
Identifying: F

Return to diagram

r_poly_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pR_poly
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pR_poly
Identifying: F

Return to diagram

ivtotal_data_rel (Constraint)
From Owner Name: dbo
Database Name: master
To Owner Name: dbo
To Table: pivtotal_data
Database Name: master
From Owner Name: dbo
From Table: pivtotal
To Owner Name: dbo
To Table: pivtotal_data
Identifying: F

Return to diagram

ivtotal_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pivtotal
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pivtotal
Identifying: F

Return to diagram

ivpad_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pivpad
To Owner Name: dbo
To Table: pivpad_data
Database Name: master
From Owner Name: dbo
From Table: pivpad
To Owner Name: dbo
To Table: pivpad_data
Identifying: F

Return to diagram

ivpad_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pivpad
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pivpad
Identifying: F

Return to diagram

g_ring_current_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pguard_ring_current
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pguard_ring_current
Identifying: F

Return to diagram

g_ring_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pguard_ring_current
To Owner Name: dbo
To Table: pg_ring_data
Database Name: master
From Owner Name: dbo
From Table: pguard_ring_current
To Owner Name: dbo
To Table: pg_ring_data
Identifying: F

Return to diagram

cv_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pcv
To Owner Name: dbo
To Table: pcv_data
Database Name: master
From Owner Name: dbo
From Table: pcv
To Owner Name: dbo
To Table: pcv_data
Identifying: F

Return to diagram

cv_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcv
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcv
Identifying: F

Return to diagram

coupling_capac_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pcoupling_capac
To Owner Name: dbo
To Table: pcoupling_capac_data
Database Name: master
From Owner Name: dbo
From Table: pcoupling_capac
To Owner Name: dbo
To Table: pcoupling_capac_data
Identifying: F

Return to diagram

coupling_capac_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcoupling_capac
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcoupling_capac
Identifying: F

Return to diagram

coup_cap_bkdwn_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcoup_cap_bkdwn
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pcoup_cap_bkdwn
Identifying: F

Return to diagram

bad_ch_data_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: pbad_ch
To Owner Name: dbo
To Table: pbad_ch_data
Database Name: master
From Owner Name: dbo
From Table: pbad_ch
To Owner Name: dbo
To Table: pbad_ch_data
Identifying: F

Return to diagram

bad_strips_rel (Constraint)
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pbad_ch
Database Name: master
From Owner Name: dbo
From Table: psimain
To Owner Name: dbo
To Table: pbad_ch
Identifying: F

Return to diagram


Return to diagram index