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

Instrument.PK_INSTR Index Columns 
ColumnName  Sort Order 
Instrument Identifier   

Instrument.PK_INSTR Bound Attachments 
Name  Current Value 


Instrument Downtime Accounting.PK_INSTR_DOWNTIME_ACCT 
Entity Name  Instrument Downtime Accounting 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Downtime Accounting.PK_INSTR_DOWNTIME_ACCT Index Columns 
ColumnName  Sort Order 
Shift Identifier   
Facility Identifier   
Instrument Identifier   
Operation Group Identifier   
Operation Subgroup1 Identifier   
Calendar Date   

Instrument Downtime Accounting.PK_INSTR_DOWNTIME_ACCT Bound Attachments 
Name  Current Value 


Instrument Logbook Category Association.PK_INSTR_LOG_CAT_ASSC 
Entity Name  Instrument Logbook Category Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Logbook Category Association.PK_INSTR_LOG_CAT_ASSC Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Cat Id   

Instrument Logbook Category Association.PK_INSTR_LOG_CAT_ASSC Bound Attachments 
Name  Current Value 


Instrument Shift Summary.PK_INSTR_SHIFT_SUMM 
Entity Name  Instrument Shift Summary 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Shift Summary.PK_INSTR_SHIFT_SUMM Index Columns 
ColumnName  Sort Order 
Shift Identifier   
Facility Identifier   
Calendar Date   

Instrument Shift Summary.PK_INSTR_SHIFT_SUMM Bound Attachments 
Name  Current Value 


Instrument Support Activity.PK_INSTR_SUP_ACT 
Entity Name  Instrument Support Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Support Activity.PK_INSTR_SUP_ACT Index Columns 
ColumnName  Sort Order 
Instrument Support Activity Identifier   

Instrument Support Activity.PK_INSTR_SUP_ACT Bound Attachments 
Name  Current Value 


Instrument Support Activity Status.PK_INSTR_SUP_ACT_STAT 
Entity Name  Instrument Support Activity Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Support Activity Status.PK_INSTR_SUP_ACT_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Instrument Support Activity Status.PK_INSTR_SUP_ACT_STAT Bound Attachments 
Name  Current Value 


Log Category.LOG_CATEGORIES_PK 
Entity Name  Log Category 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Log Category.LOG_CATEGORIES_PK Index Columns 
ColumnName  Sort Order 
Cat Id   

Log Category.LOG_CATEGORIES_PK Bound Attachments 
Name  Current Value 


Operation Group.PK_OPER_GRP 
Entity Name  Operation Group 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Operation Group.PK_OPER_GRP Index Columns 
ColumnName  Sort Order 
Operation Group Identifier   

Operation Group.PK_OPER_GRP Bound Attachments 
Name  Current Value 


Operation Subgroup.pk_oper_subgrp 
Entity Name  Operation Subgroup 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Operation Subgroup.pk_oper_subgrp Index Columns 
ColumnName  Sort Order 
Operation Group Identifier   
Operation Subgroup1 Identifier   

Operation Subgroup.pk_oper_subgrp Bound Attachments 
Name  Current Value 


Personnel Role.pk_pers_role 
Entity Name  Personnel Role 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Personnel Role.pk_pers_role Index Columns 
ColumnName  Sort Order 
Badge Number   

Personnel Role.pk_pers_role Bound Attachments 
Name  Current Value 


Personnel Role Operation Group Assignment.PK_PERS_ROLE_OPER_GRP_ASGN 
Entity Name  Personnel Role Operation Group Assignment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Personnel Role Operation Group Assignment.PK_PERS_ROLE_OPER_GRP_ASGN Index Columns 
ColumnName  Sort Order 
Badge Number   
Operation Group Identifier   

Personnel Role Operation Group Assignment.PK_PERS_ROLE_OPER_GRP_ASGN Bound Attachments 
Name  Current Value 


Personnel Role Operation SubGroup Assignment.PK_PERS_ROLE_OPER_SUBGRP_ASGN 
Entity Name  Personnel Role Operation SubGroup Assignment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Personnel Role Operation SubGroup Assignment.PK_PERS_ROLE_OPER_SUBGRP_ASGN Index Columns 
ColumnName  Sort Order 
Badge Number   
Operation Group Identifier   
Operation Subgroup1 Identifier   

Personnel Role Operation SubGroup Assignment.PK_PERS_ROLE_OPER_SUBGRP_ASGN Bound Attachments 
Name  Current Value 


Report Distribution.PK_RPT_DIST 
Entity Name  Report Distribution 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Report Distribution.PK_RPT_DIST Index Columns 
ColumnName  Sort Order 
Email Addr   

Report Distribution.PK_RPT_DIST Bound Attachments 
Name  Current Value 


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

Shift.PK_SHIFT Index Columns 
ColumnName  Sort Order 
Shift Identifier   

Shift.PK_SHIFT Bound Attachments 
Name  Current Value 


Shift Instrument Note.PK_SHIFT_INSTR_NOTE 
Entity Name  Shift Instrument Note 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Shift Instrument Note.PK_SHIFT_INSTR_NOTE Index Columns 
ColumnName  Sort Order 
Shift Identifier   
Facility Identifier   
Calendar Date   
Instrument Identifier   

Shift Instrument Note.PK_SHIFT_INSTR_NOTE Bound Attachments 
Name  Current Value 


Shift Instrument Note Group Assignment.PK_SHIFT_INSTR_NOTE_GRP_ASGN 
Entity Name  Shift Instrument Note Group Assignment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Shift Instrument Note Group Assignment.PK_SHIFT_INSTR_NOTE_GRP_ASGN Index Columns 
ColumnName  Sort Order 
Shift Identifier   
Facility Identifier   
Calendar Date   
Instrument Identifier   

Shift Instrument Note Group Assignment.PK_SHIFT_INSTR_NOTE_GRP_ASGN Bound Attachments 
Name  Current Value