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 |
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 |
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 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 |
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 |
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 |