Component.PK_CMPNT 
Entity Name  Component 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Component.PK_CMPNT Index Columns 
ColumnName  Sort Order 
Part Identifier   

Component.PK_CMPNT Bound Attachments 
Name  Current Value 


Component Material.PK_CMPNT_MATL 
Entity Name  Component Material 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Component Material.PK_CMPNT_MATL Index Columns 
ColumnName  Sort Order 
Material Identifier   

Component Material.PK_CMPNT_MATL Bound Attachments 
Name  Current Value 


Component Status.PK_CMPNT_STAT 
Entity Name  Component Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Component Status.PK_CMPNT_STAT Index Columns 
ColumnName  Sort Order 
Component Status Identifier   

Component Status.PK_CMPNT_STAT Bound Attachments 
Name  Current Value 


Component Type.PK_CMPNT_TYPE 
Entity Name  Component Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Component Type.PK_CMPNT_TYPE Index Columns 
ColumnName  Sort Order 
Component Type Identifier   

Component Type.PK_CMPNT_TYPE Bound Attachments 
Name  Current Value 


Distributor.PK_DISTR 
Entity Name  Distributor 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Distributor.PK_DISTR Index Columns 
ColumnName  Sort Order 
Distributor Identifer   

Distributor.PK_DISTR Bound Attachments 
Name  Current Value 


Distributor Status.PK_DISTR_STAT 
Entity Name  Distributor Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Distributor Status.PK_DISTR_STAT Index Columns 
ColumnName  Sort Order 
Distributor Status Identifier   

Distributor Status.PK_DISTR_STAT Bound Attachments 
Name  Current Value 


Distributor Type.PK_DISTR_TYPE 
Entity Name  Distributor Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Distributor Type.PK_DISTR_TYPE Index Columns 
ColumnName  Sort Order 
Distributor Type Identifier   

Distributor Type.PK_DISTR_TYPE Bound Attachments 
Name  Current Value 


Manufacturer.PK_MNFCTR 
Entity Name  Manufacturer 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Manufacturer.PK_MNFCTR Index Columns 
ColumnName  Sort Order 
Manufacturer Id   

Manufacturer.PK_MNFCTR Bound Attachments 
Name  Current Value 


Manufacturer Distributor Association.PK_MNFCTR_DISTR_ASSC 
Entity Name  Manufacturer Distributor Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Manufacturer Distributor Association.PK_MNFCTR_DISTR_ASSC Index Columns 
ColumnName  Sort Order 
Manufacturer Id   
Distributor Identifer   

Manufacturer Distributor Association.PK_MNFCTR_DISTR_ASSC Bound Attachments 
Name  Current Value 


Manufacturer Status.PK_MNFCTR_STAT 
Entity Name  Manufacturer Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Manufacturer Status.PK_MNFCTR_STAT Index Columns 
ColumnName  Sort Order 
Manufacturer Status Identifier   

Manufacturer Status.PK_MNFCTR_STAT Bound Attachments 
Name  Current Value 


Manufacturer Type.PK_MNFCTR_TYPE 
Entity Name  Manufacturer Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Manufacturer Type.PK_MNFCTR_TYPE Index Columns 
ColumnName  Sort Order 
Manufacturer Type Identifier   

Manufacturer Type.PK_MNFCTR_TYPE Bound Attachments 
Name  Current Value 


Material Status.PK_MATL_STAT 
Entity Name  Material Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Material Status.PK_MATL_STAT Index Columns 
ColumnName  Sort Order 
Material Status Identifier   

Material Status.PK_MATL_STAT Bound Attachments 
Name  Current Value 


Material Type.PK_MATL_TYPE 
Entity Name  Material Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Material Type.PK_MATL_TYPE Index Columns 
ColumnName  Sort Order 
Material Type Identifier   

Material Type.PK_MATL_TYPE Bound Attachments 
Name  Current Value