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 |