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