Apr 22 1998 "quality_control" Virtual DB Description Report quality_control.criteria_subjects_conn Table This table connects a magnet subject or series with a criteria set at a particular point in time. column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criteria_set_sn sntype 0 1 0 pointer to the qc criteria set for this magnet or magnet series 2 subject_or_series_sn sntype 0 1 0 pointer to the subject or series for this qc criteria set 3 responsible_person_sn sntype 0 0 0 pointer to the person who connected this magnet/series with this qc criteria set 4 entry_dt datetime 0 1 0 date/time of this entry Foreign Keys from criteria_subjects_conn PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criteria_set_sn quality_control qc_criteria_sets qc_criteria_set_sn responsible_person_sn admin serials serial Foreign Keys to criteria_subjects_conn FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- Page 1 Apr 22 1998 quality_control.qc_conditions_ascii Table All conditions the ascii condition varible from the data set must meet before the actual test will be performed column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criterion_sn sntype 0 1 0 pointer to criterion for which this condition applies 2 condition_variable descstr 0 1 0 a 3 type_of_condition_test namestr 0 0 0 b 4 condition_value namestr 0 0 0 c Foreign Keys from qc_conditions_ascii PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criterion_sn quality_control qc_criteria qc_criterion_sn Foreign Keys to qc_conditions_ascii FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- Page 2 Apr 22 1998 quality_control.qc_conditions_float Table All conditions the float condition varible from the data set must meet before the actual test will be performed column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criterion_sn sntype 0 1 0 pointer to the criterion for which this condition should be applied 2 condition_variable descstr 0 1 0 a 3 type_of_condition_test namestr 0 0 0 b 4 condition_value_1 float 0 0 0 c 5 condition_value_2 float 1 0 0 d Foreign Keys from qc_conditions_float PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criterion_sn quality_control qc_criteria qc_criterion_sn Foreign Keys to qc_conditions_float FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- Page 3 Apr 22 1998 quality_control.qc_criteria Table Information on a single qc test to be performed, including the limit this set represents, what variables the test is performed on, and documentation on this test. column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criterion_sn sntype 1 1 0 unique sn for this entry 2 criterion_label namestr 0 0 1 a 3 subject_type aliasstr 0 0 1 b 4 severity namestr 0 0 1 c 5 dependent_variable descstr 0 0 0 d 6 independent_variable descstr 0 0 0 e 7 type_of_value_test namestr 0 0 0 f 8 description descstr 0 0 0 g 9 document_sn sntype 1 0 0 pointer to the document ... 10 responsible_person_sn sntype 0 0 0 pointer to the person responsible for ... 11 entry_dt datetimestamp 0 0 1 date/time of this entry Foreign Keys from qc_criteria PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criterion_sn admin serials serial document_sn admin documents document_sn responsible_person_sn admin personnel personnel_sn Foreign Keys to qc_criteria FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criterion_sn quality_control qc_conditions_ascii qc_criterion_sn qc_criterion_sn quality_control qc_conditions_float qc_criterion_sn qc_criterion_sn quality_control qc_criteria_set_parts qc_criterion_sn qc_criterion_sn quality_control qc_test_values qc_criterion_sn Page 4 Apr 22 1998 quality_control.qc_criteria_set_parts Table The detail table that links a single quality criteria into a criteria set column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criteria_set_sn sntype 0 1 0 pointer to the set the below criterion belongs to 2 qc_criterion_sn sntype 0 1 0 pointer to the criterion for the above set Foreign Keys from qc_criteria_set_parts PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criteria_set_sn quality_control qc_criteria_sets qc_criteria_set_sn qc_criterion_sn quality_control qc_criteria qc_criterion_sn Foreign Keys to qc_criteria_set_parts FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- Page 5 Apr 22 1998 quality_control.qc_criteria_sets Table Master table for a collection of criteria that should all be applied to magnets/series data that have been analyzed with the same algorithm column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criteria_set_sn sntype 1 1 0 the unique serial for this entry 2 analysis_algorithm namestr 0 0 1 name of the analysis algorithm for which the data in this criteria set will apply 3 document_sn sntype 1 0 0 pointer to the document that describes how this criteris set was devised 4 responsible_person_sn sntype 0 0 0 pointer to the person responsible for compiling this criteria set 5 entry_dt datetimestamp 0 0 1 date/time this entry was made Foreign Keys from qc_criteria_sets PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criteria_set_sn admin serials serial document_sn admin documents document_sn responsible_person_sn admin personnel personnel_sn Foreign Keys to qc_criteria_sets FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criteria_set_sn quality_control criteria_subjects_conn qc_criteria_set_sn qc_criteria_set_sn quality_control qc_criteria_set_parts qc_criteria_set_sn Page 6 Apr 22 1998 quality_control.qc_test_values Table The values with which to test one criterion's independant variable. column_name units datatype null pri alt description key key ------------------------- --------- --------------- ---- --- --- --------------------------------------------------------- 1 qc_criterion_sn sntype 0 1 0 pointer to the criterion for which these test values will be applied 2 independent_value float 0 1 0 a 3 test_value_1 float 0 0 0 b 4 test_value_2 float 1 0 0 c 5 test_value_3 float 1 0 0 d Foreign Keys from qc_test_values PRIMARY KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name primary_dataowner_name primary_table_name primary_column_name ------------------------- --------------------------- ------------------------- ------------------------- qc_criterion_sn quality_control qc_criteria qc_criterion_sn Foreign Keys to qc_test_values FOREIGN KEY - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - column_name foreign_dataowner_name foreign_table_name foreign_column_name ------------------------- --------------------------- ------------------------- ------------------------- Page 7 Apr 22 1998 Rules for Datatypes in the "quality_control" Database rule name rule text ------------------------------ ---------------------------------------- Defaults for Datatypes in the "quality_control" Database default name default text ------------------------------ ---------------------------------------- datetimestamp_default create default datetimestamp_default as getdate() Tables.Columns with this Datatype Default: qc_criteria.entry_dt qc_criteria_sets.entry_dt End of "quality_control" Report Page 8
Legal Notices