Barcd Asgn Audit.barcd_asgn_audit_pk |
Entity Name | Barcd Asgn Audit |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Barcd Asgn Audit.barcd_asgn_audit_pk Index Columns |
ColumnName | Sort Order |
Dvc IEEE Nm | |
Assgn Dte |
Barcd Asgn Audit.barcd_asgn_audit_pk Bound Attachments |
Name | Current Value |
Barcode Assignment.barcd_asgn_pk |
Entity Name | Barcode Assignment |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Barcode Assignment.barcd_asgn_pk Index Columns |
ColumnName | Sort Order |
Dvc IEEE Nm |
Barcode Assignment.barcd_asgn_pk Bound Attachments |
Name | Current Value |
Barcode Assignment.dvc_type_rf |
Entity Name | Barcode Assignment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Barcode Assignment.dvc_type_rf Index Columns |
ColumnName | Sort Order |
Dvc Type Id |
Barcode Assignment.dvc_type_rf Bound Attachments |
Name | Current Value |
Barcode Assignment.ieee_cmpnt_type_rf |
Entity Name | Barcode Assignment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Barcode Assignment.ieee_cmpnt_type_rf Index Columns |
ColumnName | Sort Order |
Cmpnt ID |
Barcode Assignment.ieee_cmpnt_type_rf Bound Attachments |
Name | Current Value |
Bead Pull.PK375 |
Entity Name | Bead Pull |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Bead Pull.PK375 Index Columns |
ColumnName | Sort Order |
Equip Id |
Bead Pull.PK375 Bound Attachments |
Name | Current Value |
Building.bldg_pk |
Entity Name | Building |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Building.bldg_pk Index Columns |
ColumnName | Sort Order |
Bldg Id |
Building.bldg_pk Bound Attachments |
Name | Current Value |
Building Area.bldg_area_pk |
Entity Name | Building Area |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Building Area.bldg_area_pk Index Columns |
ColumnName | Sort Order |
Bldg Id | |
Area Id |
Building Area.bldg_area_pk Bound Attachments |
Name | Current Value |
Building Area.bldg_code_rf |
Entity Name | Building Area |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Building Area.bldg_code_rf Index Columns |
ColumnName | Sort Order |
Bldg Id |
Building Area.bldg_code_rf Bound Attachments |
Name | Current Value |
Building Subarea.bldg_subarea_pk |
Entity Name | Building Subarea |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Building Subarea.bldg_subarea_pk Index Columns |
ColumnName | Sort Order |
Bldg Id | |
Area Id | |
Subarea Id |
Building Subarea.bldg_subarea_pk Bound Attachments |
Name | Current Value |
Calibration Frequency.calib_freq_pk |
Entity Name | Calibration Frequency |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Calibration Frequency.calib_freq_pk Index Columns |
ColumnName | Sort Order |
Calib Freq Id |
Calibration Frequency.calib_freq_pk Bound Attachments |
Name | Current Value |
Calibration Method.calib_method_pk |
Entity Name | Calibration Method |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Calibration Method.calib_method_pk Index Columns |
ColumnName | Sort Order |
Calib Method Id |
Calibration Method.calib_method_pk Bound Attachments |
Name | Current Value |
Carrier.carrier_pk |
Entity Name | Carrier |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Carrier.carrier_pk Index Columns |
ColumnName | Sort Order |
Carrier Id |
Carrier.carrier_pk Bound Attachments |
Name | Current Value |
Ctrls Mnfctr Mdl.sgnl_mnfctr_mdl_pk |
Entity Name | Ctrls Mnfctr Mdl |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Ctrls Mnfctr Mdl.sgnl_mnfctr_mdl_pk Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr |
Ctrls Mnfctr Mdl.sgnl_mnfctr_mdl_pk Bound Attachments |
Name | Current Value |
Diagnostics Equipment History.PK_DIAG_EQUIP_HIST |
Entity Name | Diagnostics Equipment History |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Diagnostics Equipment History.PK_DIAG_EQUIP_HIST Index Columns |
ColumnName | Sort Order |
Equip Id | |
Modify Date |
Diagnostics Equipment History.PK_DIAG_EQUIP_HIST Bound Attachments |
Name | Current Value |
Employee MV.employee_pk |
Entity Name | Employee MV |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Employee MV.employee_pk Index Columns |
ColumnName | Sort Order |
Badge Number |
Employee MV.employee_pk Bound Attachments |
Name | Current Value |
Equipment.equip_pk |
Entity Name | Equipment |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment.equip_pk Index Columns |
ColumnName | Sort Order |
Equip Id |
Equipment.equip_pk Bound Attachments |
Name | Current Value |
Equipment.equip_type_rf |
Entity Name | Equipment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment.equip_type_rf Index Columns |
ColumnName | Sort Order |
Operation Group Identifier |
Equipment.equip_type_rf Bound Attachments |
Name | Current Value |
Equipment.parent_equip_rf |
Entity Name | Equipment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment.parent_equip_rf Index Columns |
ColumnName | Sort Order |
Parent Equipment ID |
Equipment.parent_equip_rf Bound Attachments |
Name | Current Value |
Equipment.mnfctr_mdl_rf |
Entity Name | Equipment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment.mnfctr_mdl_rf Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr |
Equipment.mnfctr_mdl_rf Bound Attachments |
Name | Current Value |
Equipment Category.equip_cat_pk |
Entity Name | Equipment Category |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Category.equip_cat_pk Index Columns |
ColumnName | Sort Order |
Operation Group Identifier |
Equipment Category.equip_cat_pk Bound Attachments |
Name | Current Value |
Equipment Device Assignment.equip_dvc_asgn_pk |
Entity Name | Equipment Device Assignment |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Device Assignment.equip_dvc_asgn_pk Index Columns |
ColumnName | Sort Order |
Device Identifer | |
Equip Id | |
Asgn Bdte |
Equipment Device Assignment.equip_dvc_asgn_pk Bound Attachments |
Name | Current Value |
Equipment Device Assignment.equip_dvc_asgn2_rf |
Entity Name | Equipment Device Assignment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Device Assignment.equip_dvc_asgn2_rf Index Columns |
ColumnName | Sort Order |
Equip Id |
Equipment Device Assignment.equip_dvc_asgn2_rf Bound Attachments |
Name | Current Value |
Equipment Device Assignment.equip_dvc_asgn_rf |
Entity Name | Equipment Device Assignment |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Device Assignment.equip_dvc_asgn_rf Index Columns |
ColumnName | Sort Order |
Device Identifer |
Equipment Device Assignment.equip_dvc_asgn_rf Bound Attachments |
Name | Current Value |
Equipment Location.equip_loc_pk |
Entity Name | Equipment Location |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Location.equip_loc_pk Index Columns |
ColumnName | Sort Order |
Equip Id | |
Bdte |
Equipment Location.equip_loc_pk Bound Attachments |
Name | Current Value |
Equipment Location.area_equip_rf |
Entity Name | Equipment Location |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Location.area_equip_rf Index Columns |
ColumnName | Sort Order |
Area Id | |
Bldg Id |
Equipment Location.area_equip_rf Bound Attachments |
Name | Current Value |
Equipment Location.equip_rf |
Entity Name | Equipment Location |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Location.equip_rf Index Columns |
ColumnName | Sort Order |
Equip Id |
Equipment Location.equip_rf Bound Attachments |
Name | Current Value |
Equipment Receipt.equp_rcpt_pk |
Entity Name | Equipment Receipt |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Receipt.equp_rcpt_pk Index Columns |
ColumnName | Sort Order |
Equip Rcpt Id | |
Equip Rcpt Ver |
Equipment Receipt.equp_rcpt_pk Bound Attachments |
Name | Current Value |
Equipment Receipt.carrier_rcpt_rf |
Entity Name | Equipment Receipt |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Receipt.carrier_rcpt_rf Index Columns |
ColumnName | Sort Order |
Carrier Id |
Equipment Receipt.carrier_rcpt_rf Bound Attachments |
Name | Current Value |
Equipment Status.equip_stat_pk |
Entity Name | Equipment Status |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Status.equip_stat_pk Index Columns |
ColumnName | Sort Order |
Equip Id | |
Stat Dte |
Equipment Status.equip_stat_pk Bound Attachments |
Name | Current Value |
Equipment Status.equip_stat_rf |
Entity Name | Equipment Status |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Status.equip_stat_rf Index Columns |
ColumnName | Sort Order |
Equip Id |
Equipment Status.equip_stat_rf Bound Attachments |
Name | Current Value |
Equipment Status.equip_stat_cd_rf |
Entity Name | Equipment Status |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Equipment Status.equip_stat_cd_rf Index Columns |
ColumnName | Sort Order |
Equip Stat Id |
Equipment Status.equip_stat_cd_rf Bound Attachments |
Name | Current Value |
Equipment Status Code.equip_stat_code_pk |
Entity Name | Equipment Status Code |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Status Code.equip_stat_code_pk Index Columns |
ColumnName | Sort Order |
Equip Stat Id |
Equipment Status Code.equip_stat_code_pk Bound Attachments |
Name | Current Value |
Equipment Sub Subcategory.equip_sub_subcat_pk |
Entity Name | Equipment Sub Subcategory |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Sub Subcategory.equip_sub_subcat_pk Index Columns |
ColumnName | Sort Order |
Operation Group Identifier | |
Equip Subcat Id | |
Equip Sub Subcat ID |
Equipment Sub Subcategory.equip_sub_subcat_pk Bound Attachments |
Name | Current Value |
Equipment Subcategory.equip_subcat_pk |
Entity Name | Equipment Subcategory |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Subcategory.equip_subcat_pk Index Columns |
ColumnName | Sort Order |
Operation Group Identifier | |
Equip Subcat Id |
Equipment Subcategory.equip_subcat_pk Bound Attachments |
Name | Current Value |
Equipment Usage.equip_usage_pk |
Entity Name | Equipment Usage |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Equipment Usage.equip_usage_pk Index Columns |
ColumnName | Sort Order |
Equip Id | |
Usage Strt Dte |
Equipment Usage.equip_usage_pk Bound Attachments |
Name | Current Value |
Inst.instr_pk |
Entity Name | Inst |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Inst.instr_pk Index Columns |
ColumnName | Sort Order |
Equip Id |
Inst.instr_pk Bound Attachments |
Name | Current Value |
Laboratory.lab_pk |
Entity Name | Laboratory |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Laboratory.lab_pk Index Columns |
ColumnName | Sort Order |
Lab Id |
Laboratory.lab_pk Bound Attachments |
Name | Current Value |
Lead Engineer.lead_eng_pk |
Entity Name | Lead Engineer |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Lead Engineer.lead_eng_pk Index Columns |
ColumnName | Sort Order |
Lead Eng BN |
Lead Engineer.lead_eng_pk Bound Attachments |
Name | Current Value |
Magnet Manufacter Model.mag_mnfctr_mdl_pk |
Entity Name | Magnet Manufacter Model |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Magnet Manufacter Model.mag_mnfctr_mdl_pk Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr |
Magnet Manufacter Model.mag_mnfctr_mdl_pk Bound Attachments |
Name | Current Value |
Manufacturer.mnfctr_pk |
Entity Name | Manufacturer |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Manufacturer.mnfctr_pk Index Columns |
ColumnName | Sort Order |
Mnfctr Id |
Manufacturer.mnfctr_pk Bound Attachments |
Name | Current Value |
Manufacturer Model.mnfctr_mdl_pk |
Entity Name | Manufacturer Model |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Manufacturer Model.mnfctr_mdl_pk Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr |
Manufacturer Model.mnfctr_mdl_pk Bound Attachments |
Name | Current Value |
Manufacturer Model.equip_mdl_type_rf |
Entity Name | Manufacturer Model |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Manufacturer Model.equip_mdl_type_rf Index Columns |
ColumnName | Sort Order |
Operation Group Identifier |
Manufacturer Model.equip_mdl_type_rf Bound Attachments |
Name | Current Value |
Manufacturer Model.mnfctr_rf |
Entity Name | Manufacturer Model |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Manufacturer Model.mnfctr_rf Index Columns |
ColumnName | Sort Order |
Mnfctr Id |
Manufacturer Model.mnfctr_rf Bound Attachments |
Name | Current Value |
Power Supply.pwr_sply_pk |
Entity Name | Power Supply |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Power Supply.pwr_sply_pk Index Columns |
ColumnName | Sort Order |
Equip Id | |
Mod Dte |
Power Supply.pwr_sply_pk Bound Attachments |
Name | Current Value |
Power Supply Cycle On.cycle_on_pk_1 |
Entity Name | Power Supply Cycle On |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Power Supply Cycle On.cycle_on_pk_1 Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr | |
Cycle On Time |
Power Supply Cycle On.cycle_on_pk_1 Bound Attachments |
Name | Current Value |
Power Supply Manufacter Model.pwr_sply_mnfctr_mdl_pk |
Entity Name | Power Supply Manufacter Model |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Power Supply Manufacter Model.pwr_sply_mnfctr_mdl_pk Index Columns |
ColumnName | Sort Order |
Mnfctr Id | |
Mdl Nbr |
Power Supply Manufacter Model.pwr_sply_mnfctr_mdl_pk Bound Attachments |
Name | Current Value |
Radio Frequency Cavity.PK373 |
Entity Name | Radio Frequency Cavity |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Radio Frequency Cavity.PK373 Index Columns |
ColumnName | Sort Order |
Equip Id |
Radio Frequency Cavity.PK373 Bound Attachments |
Name | Current Value |
Receipt Item.recpt_item_pk |
Entity Name | Receipt Item |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Receipt Item.recpt_item_pk Index Columns |
ColumnName | Sort Order |
Equip Rcpt Id | |
Equip Rcpt Ver | |
Rcpt Item Id |
Receipt Item.recpt_item_pk Bound Attachments |
Name | Current Value |
Received By.recvd_by_pk |
Entity Name | Received By |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Received By.recvd_by_pk Index Columns |
ColumnName | Sort Order |
Rcvd By BN |
Received By.recvd_by_pk Bound Attachments |
Name | Current Value |
RF Cavity Gap Parameter.PK374 |
Entity Name | RF Cavity Gap Parameter |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
RF Cavity Gap Parameter.PK374 Index Columns |
ColumnName | Sort Order |
Equip Id | |
Cell Nbr | |
Scenario Id |
RF Cavity Gap Parameter.PK374 Bound Attachments |
Name | Current Value |
SC Cavity Parameter.PK376 |
Entity Name | SC Cavity Parameter |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SC Cavity Parameter.PK376 Index Columns |
ColumnName | Sort Order |
Equip Id |
SC Cavity Parameter.PK376 Bound Attachments |
Name | Current Value |
Unit of Measure.uom_pk |
Entity Name | Unit of Measure |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Unit of Measure.uom_pk Index Columns |
ColumnName | Sort Order |
Unit Of Measure |
Unit of Measure.uom_pk Bound Attachments |
Name | Current Value |
User Inst.user_instr_pk |
Entity Name | User Inst |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
User Inst.user_instr_pk Index Columns |
ColumnName | Sort Order |
Equip Id |
User Inst.user_instr_pk Bound Attachments |
Name | Current Value |
User Inst Calib.user_instr_calib_pk |
Entity Name | User Inst Calib |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
User Inst Calib.user_instr_calib_pk Index Columns |
ColumnName | Sort Order |
Strt Dte | |
Equip Id |
User Inst Calib.user_instr_calib_pk Bound Attachments |
Name | Current Value |
User Instr Type.user_instr_type_pk |
Entity Name | User Instr Type |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
User Instr Type.user_instr_type_pk Index Columns |
ColumnName | Sort Order |
User Instr Type Id |
User Instr Type.user_instr_type_pk Bound Attachments |
Name | Current Value |