Access Request.PK_ACCESS_REQ 
Entity Name  Access Request 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Access Request.PK_ACCESS_REQ Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Badge Number   
Role Identifer   

Access Request.PK_ACCESS_REQ Bound Attachments 
Name  Current Value 


Additional Color Code.PK_ADDL_COLOR_CODE 
Entity Name  Additional Color Code 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Additional Color Code.PK_ADDL_COLOR_CODE Index Columns 
ColumnName  Sort Order 
Identifier   

Additional Color Code.PK_ADDL_COLOR_CODE Bound Attachments 
Name  Current Value 


Application File.PK_APPL_FILE 
Entity Name  Application File 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Application File.PK_APPL_FILE Index Columns 
ColumnName  Sort Order 
Application File Identifier   

Application File.PK_APPL_FILE Bound Attachments 
Name  Current Value 


Can Substrate Cell.PK_CASC 
Entity Name  Can Substrate Cell 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell.PK_CASC Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   

Can Substrate Cell.PK_CASC Bound Attachments 
Name  Current Value 


Can Substrate Cell Attachment Association.PK_CASC_ATTACH_ASSC 
Entity Name  Can Substrate Cell Attachment Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell Attachment Association.PK_CASC_ATTACH_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   
Attachment Identifier   

Can Substrate Cell Attachment Association.PK_CASC_ATTACH_ASSC Bound Attachments 
Name  Current Value 


Can Substrate Cell Experiment Resource Type Association.PK_CASC_EXPT_RSRC_TYPE_ASSC 
Entity Name  Can Substrate Cell Experiment Resource Type Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell Experiment Resource Type Association.PK_CASC_EXPT_RSRC_TYPE_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Experiment Resource Type2 Identifier   
Facility Identifier   

Can Substrate Cell Experiment Resource Type Association.PK_CASC_EXPT_RSRC_TYPE_ASSC Bound Attachments 
Name  Current Value 


Can Substrate Cell Experiment Schedule Association.PK_CASC_EXPT_SCHED_ASSC 
Entity Name  Can Substrate Cell Experiment Schedule Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell Experiment Schedule Association.PK_CASC_EXPT_SCHED_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   
Proposal Identifier   
Submission Number   
Instrument Identifier   
Run Number   

Can Substrate Cell Experiment Schedule Association.PK_CASC_EXPT_SCHED_ASSC Bound Attachments 
Name  Current Value 


Can Substrate Cell Instrument Association.PK_CASC_INSTR_ASSC 
Entity Name  Can Substrate Cell Instrument Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell Instrument Association.PK_CASC_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   
Instrument Identifier   

Can Substrate Cell Instrument Association.PK_CASC_INSTR_ASSC Bound Attachments 
Name  Current Value 


Can Substrate Cell Usage.PK_CASC_USAGE 
Entity Name  Can Substrate Cell Usage 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Can Substrate Cell Usage.PK_CASC_USAGE Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   
Person Identifier   
Current Date   

Can Substrate Cell Usage.PK_CASC_USAGE Bound Attachments 
Name  Current Value 


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

Classification.PK_CLASS Index Columns 
ColumnName  Sort Order 
Classification Identifier   

Classification.PK_CLASS Bound Attachments 
Name  Current Value 


Electrical Certification.PK_ELEC_CERT 
Entity Name  Electrical Certification 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Electrical Certification.PK_ELEC_CERT Index Columns 
ColumnName  Sort Order 
Electrical Certification Identifier   

Electrical Certification.PK_ELEC_CERT Bound Attachments 
Name  Current Value 


Email Signature.PK_EMAIL_SIGN 
Entity Name  Email Signature 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Email Signature.PK_EMAIL_SIGN Index Columns 
ColumnName  Sort Order 
Badge Number   
Instrument Identifier   

Email Signature.PK_EMAIL_SIGN Bound Attachments 
Name  Current Value 


Email Template.PK_EMAIL_TEMPLATE 
Entity Name  Email Template 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Email Template.PK_EMAIL_TEMPLATE Index Columns 
ColumnName  Sort Order 
Template Identifier   

Email Template.PK_EMAIL_TEMPLATE Bound Attachments 
Name  Current Value 


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

Employee.PK_EMPLOYEE Index Columns 
ColumnName  Sort Order 
Badge Number   

Employee.PK_EMPLOYEE Bound Attachments 
Name  Current Value 


Experiment Laboratory Schedule.PK_EXPT_LAB_SCHED 
Entity Name  Experiment Laboratory Schedule 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Laboratory Schedule.PK_EXPT_LAB_SCHED Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   
Instrument Identifier   
Run Number   
Laboratory Identifier   

Experiment Laboratory Schedule.PK_EXPT_LAB_SCHED Bound Attachments 
Name  Current Value 


Experiment Laboratory Schedule Log.PK_EXPT_LAB_SCHED_LOG 
Entity Name  Experiment Laboratory Schedule Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Laboratory Schedule Log.PK_EXPT_LAB_SCHED_LOG Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   
Instrument Identifier   
Run Number   
Laboratory Identifier   
Activity Identifier   
Current TimeStamp   

Experiment Laboratory Schedule Log.PK_EXPT_LAB_SCHED_LOG Bound Attachments 
Name  Current Value 


Experiment Laboratory Schedule Workflow.PK_EXPT_LAB_WRKFLW 
Entity Name  Experiment Laboratory Schedule Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Laboratory Schedule Workflow.PK_EXPT_LAB_WRKFLW Index Columns 
ColumnName  Sort Order 
Facility Identifier   
WorkFlow Identifier   
Order Number   

Experiment Laboratory Schedule Workflow.PK_EXPT_LAB_WRKFLW Bound Attachments 
Name  Current Value 


Experiment Laboratory Status.PK_EXPT_LAB_STAT 
Entity Name  Experiment Laboratory Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Laboratory Status.PK_EXPT_LAB_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Experiment Laboratory Status.PK_EXPT_LAB_STAT Bound Attachments 
Name  Current Value 


Experiment Resource.PK_EXPT_RSRC 
Entity Name  Experiment Resource 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource.PK_EXPT_RSRC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   

Experiment Resource.PK_EXPT_RSRC Bound Attachments 
Name  Current Value 


Experiment Resource Association.PK_EXPT_RSRC_ASSC 
Entity Name  Experiment Resource Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Association.PK_EXPT_RSRC_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier 1   
Experiment Resource Identifier 2   

Experiment Resource Association.PK_EXPT_RSRC_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Attach Type.PK_EXPT_RSRC_ATTACH_TYPE 
Entity Name  Experiment Resource Attach Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Attach Type.PK_EXPT_RSRC_ATTACH_TYPE Index Columns 
ColumnName  Sort Order 
Attachment Type Identifier   

Experiment Resource Attach Type.PK_EXPT_RSRC_ATTACH_TYPE Bound Attachments 
Name  Current Value 


Experiment Resource Attachment.PK_EXPT_RSRC_ATTACH 
Entity Name  Experiment Resource Attachment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Attachment.PK_EXPT_RSRC_ATTACH Index Columns 
ColumnName  Sort Order 
Attachment Identifier   

Experiment Resource Attachment.PK_EXPT_RSRC_ATTACH Bound Attachments 
Name  Current Value 


Experiment Resource Attachment Association.PK_EXPT_RSRC_ATTACH_ASSC 
Entity Name  Experiment Resource Attachment Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Attachment Association.PK_EXPT_RSRC_ATTACH_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Attachment Identifier   

Experiment Resource Attachment Association.PK_EXPT_RSRC_ATTACH_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Commitment Type.PK_EXPT_RSRC_COMM_TYPE 
Entity Name  Experiment Resource Commitment Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Commitment Type.PK_EXPT_RSRC_COMM_TYPE Index Columns 
ColumnName  Sort Order 
Commitment Request Identifier   

Experiment Resource Commitment Type.PK_EXPT_RSRC_COMM_TYPE Bound Attachments 
Name  Current Value 


Experiment Resource Facility.PK_EXPT_RSRC_FACIL_1 
Entity Name  Experiment Resource Facility 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Facility.PK_EXPT_RSRC_FACIL_1 Index Columns 
ColumnName  Sort Order 
Facility Identifier   

Experiment Resource Facility.PK_EXPT_RSRC_FACIL_1 Bound Attachments 
Name  Current Value 


Experiment Resource Group.PK_EXPT_RSRC_GRP 
Entity Name  Experiment Resource Group 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Group.PK_EXPT_RSRC_GRP Index Columns 
ColumnName  Sort Order 
Experiment Resource Group Name   

Experiment Resource Group.PK_EXPT_RSRC_GRP Bound Attachments 
Name  Current Value 


Experiment Resource Group Association.PK_EXPT_RSRC_GRP_ASSC 
Entity Name  Experiment Resource Group Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Group Association.PK_EXPT_RSRC_GRP_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Group Name   
Experiment Resource Identifier   

Experiment Resource Group Association.PK_EXPT_RSRC_GRP_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Instrument Association.PK_EXPT_RSRC_INSTR_ASSC 
Entity Name  Experiment Resource Instrument Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Instrument Association.PK_EXPT_RSRC_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Instrument Identifier   

Experiment Resource Instrument Association.PK_EXPT_RSRC_INSTR_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Location.PK_EXPT_RSRC_LOC 
Entity Name  Experiment Resource Location 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Location.PK_EXPT_RSRC_LOC Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Location Identifier   

Experiment Resource Location.PK_EXPT_RSRC_LOC Bound Attachments 
Name  Current Value 


Experiment Resource Log.PK_EXPT_RSRC_LOG 
Entity Name  Experiment Resource Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Log.PK_EXPT_RSRC_LOG Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Activity Identifier   
Current TimeStamp   

Experiment Resource Log.PK_EXPT_RSRC_LOG Bound Attachments 
Name  Current Value 


Experiment Resource Maintenance.PK_EXPT_RSRC_MAINT 
Entity Name  Experiment Resource Maintenance 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Maintenance.PK_EXPT_RSRC_MAINT Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Activity Identifier   

Experiment Resource Maintenance.PK_EXPT_RSRC_MAINT Bound Attachments 
Name  Current Value 


Experiment Resource Maintenance Schedule.PK_EXPT_RSRC_MAINT_SCHED 
Entity Name  Experiment Resource Maintenance Schedule 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Maintenance Schedule.PK_EXPT_RSRC_MAINT_SCHED Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   

Experiment Resource Maintenance Schedule.PK_EXPT_RSRC_MAINT_SCHED Bound Attachments 
Name  Current Value 


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

Experiment Resource Manufacturer.PK_EXPT_RSRC_MANUF Index Columns 
ColumnName  Sort Order 
Manufacturer Identifier   

Experiment Resource Manufacturer.PK_EXPT_RSRC_MANUF Bound Attachments 
Name  Current Value 


Experiment Resource Personnel Absence.PK_EXPT_RSRC_PERS_ABS 
Entity Name  Experiment Resource Personnel Absence 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Personnel Absence.PK_EXPT_RSRC_PERS_ABS Index Columns 
ColumnName  Sort Order 
Badge Number   
Absence Type Code   
Absence Start Date   

Experiment Resource Personnel Absence.PK_EXPT_RSRC_PERS_ABS Bound Attachments 
Name  Current Value 


Experiment Resource Personnel Association.PK_EXPT_RSRC_PERS_ASSC 
Entity Name  Experiment Resource Personnel Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Personnel Association.PK_EXPT_RSRC_PERS_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Badge Number   

Experiment Resource Personnel Association.PK_EXPT_RSRC_PERS_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Personnel Resource.PK_EXPT_RSRC_PERS_RSRC 
Entity Name  Experiment Resource Personnel Resource 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Personnel Resource.PK_EXPT_RSRC_PERS_RSRC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Badge Number   

Experiment Resource Personnel Resource.PK_EXPT_RSRC_PERS_RSRC Bound Attachments 
Name  Current Value 


Experiment Resource Personnel Training.PK_EXPT_RSRC_PERS_TRAIN 
Entity Name  Experiment Resource Personnel Training 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Personnel Training.PK_EXPT_RSRC_PERS_TRAIN Index Columns 
ColumnName  Sort Order 
Training Module Identifer   
Badge Number   

Experiment Resource Personnel Training.PK_EXPT_RSRC_PERS_TRAIN Bound Attachments 
Name  Current Value 


Experiment Resource Question.PK_SCHED_QUES 
Entity Name  Experiment Resource Question 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Question.PK_SCHED_QUES Index Columns 
ColumnName  Sort Order 
Question Identifier   

Experiment Resource Question.PK_SCHED_QUES Bound Attachments 
Name  Current Value 


Experiment Resource Question Experiment Resource Schedule Association.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC 
Entity Name  Experiment Resource Question Experiment Resource Schedule Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Question Experiment Resource Schedule Association.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Question Identifier   

Experiment Resource Question Experiment Resource Schedule Association.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC Bound Attachments 
Name  Current Value 


Experiment Resource Request Type.PK_EXPT_RSRC_REQ_TYPE 
Entity Name  Experiment Resource Request Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Request Type.PK_EXPT_RSRC_REQ_TYPE Index Columns 
ColumnName  Sort Order 
Request Type Identifier   

Experiment Resource Request Type.PK_EXPT_RSRC_REQ_TYPE Bound Attachments 
Name  Current Value 


Experiment Resource Schedule.PK_EXPT_RSRC_SCHED 
Entity Name  Experiment Resource Schedule 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Schedule.PK_EXPT_RSRC_SCHED Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   

Experiment Resource Schedule.PK_EXPT_RSRC_SCHED Bound Attachments 
Name  Current Value 


Experiment Resource Schedule Log.PK_EXPT_RSRC_SCHED_LOG 
Entity Name  Experiment Resource Schedule Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Schedule Log.PK_EXPT_RSRC_SCHED_LOG Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Activity Identifier   
Current TimeStamp   

Experiment Resource Schedule Log.PK_EXPT_RSRC_SCHED_LOG Bound Attachments 
Name  Current Value 


Experiment Resource Schedule Status.PK_EXPT_RSRC_SCHED_STAT 
Entity Name  Experiment Resource Schedule Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Schedule Status.PK_EXPT_RSRC_SCHED_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Experiment Resource Schedule Status.PK_EXPT_RSRC_SCHED_STAT Bound Attachments 
Name  Current Value 


Experiment Resource Schedule Workflow.PK_EXPT_RSRC_SCHED_WRKFLW 
Entity Name  Experiment Resource Schedule Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Schedule Workflow.PK_EXPT_RSRC_SCHED_WRKFLW Index Columns 
ColumnName  Sort Order 
Facility Identifier   
WorkFlow Identifier   
Order Number   

Experiment Resource Schedule Workflow.PK_EXPT_RSRC_SCHED_WRKFLW Bound Attachments 
Name  Current Value 


Experiment Resource Status.PK_EXPT_RSRC_STAT 
Entity Name  Experiment Resource Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Status.PK_EXPT_RSRC_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Experiment Resource Status.PK_EXPT_RSRC_STAT Bound Attachments 
Name  Current Value 


Experiment Resource Status History.PK_EXPT_RSRC_STAT_HIST 
Entity Name  Experiment Resource Status History 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Status History.PK_EXPT_RSRC_STAT_HIST Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   

Experiment Resource Status History.PK_EXPT_RSRC_STAT_HIST Bound Attachments 
Name  Current Value 


Experiment Resource Subtype.PK_EXPT_RSRC_SUBTYPE 
Entity Name  Experiment Resource Subtype 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Subtype.PK_EXPT_RSRC_SUBTYPE Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Experiment Resource Subtype Identifer   
Facility Identifier   

Experiment Resource Subtype.PK_EXPT_RSRC_SUBTYPE Bound Attachments 
Name  Current Value 


Experiment Resource Training.PK_EXPT_RSRC_TRAIN 
Entity Name  Experiment Resource Training 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Training.PK_EXPT_RSRC_TRAIN Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Training Module Identifer   

Experiment Resource Training.PK_EXPT_RSRC_TRAIN Bound Attachments 
Name  Current Value 


Experiment Resource Training Modules.PK_EXPT_RSRC_TRAIN_MOD 
Entity Name  Experiment Resource Training Modules 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Training Modules.PK_EXPT_RSRC_TRAIN_MOD Index Columns 
ColumnName  Sort Order 
Training Module Identifer   

Experiment Resource Training Modules.PK_EXPT_RSRC_TRAIN_MOD Bound Attachments 
Name  Current Value 


Experiment Resource Type.PK_EXPT_RSRC_TYPE 
Entity Name  Experiment Resource Type 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Type.PK_EXPT_RSRC_TYPE Index Columns 
ColumnName  Sort Order 
Experiment Resource Type Identifier   
Facility Identifier   

Experiment Resource Type.PK_EXPT_RSRC_TYPE Bound Attachments 
Name  Current Value 


Experiment Resource Unavailable.PK_EXPT_RSRC_UNAVAIL 
Entity Name  Experiment Resource Unavailable 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Resource Unavailable.PK_EXPT_RSRC_UNAVAIL Index Columns 
ColumnName  Sort Order 
Experiment Resource Identifier   
Begin Date   

Experiment Resource Unavailable.PK_EXPT_RSRC_UNAVAIL Bound Attachments 
Name  Current Value 


Experiment Schedule.PK_EXPT_SCHED 
Entity Name  Experiment Schedule 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule.PK_EXPT_SCHED Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   
Instrument Identifier   
Run Number   

Experiment Schedule.PK_EXPT_SCHED Bound Attachments 
Name  Current Value 


Experiment Schedule Email Log.PK_EXPT_SCHED_EMAIL_LOG 
Entity Name  Experiment Schedule Email Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule Email Log.PK_EXPT_SCHED_EMAIL_LOG Index Columns 
ColumnName  Sort Order 
Template Identifier   
Current Date   

Experiment Schedule Email Log.PK_EXPT_SCHED_EMAIL_LOG Bound Attachments 
Name  Current Value 


Experiment Schedule Local Contact Association.PK_EXPT_SCH_LOC_CONT_ASSC 
Entity Name  Experiment Schedule Local Contact Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule Local Contact Association.PK_EXPT_SCH_LOC_CONT_ASSC Index Columns 
ColumnName  Sort Order 
Badge Number   

Experiment Schedule Local Contact Association.PK_EXPT_SCH_LOC_CONT_ASSC Bound Attachments 
Name  Current Value 


Experiment Schedule Log.PK_EXPT_SCHED_LOG 
Entity Name  Experiment Schedule Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule Log.PK_EXPT_SCHED_LOG Index Columns 
ColumnName  Sort Order 
Activity Identifier   
Current TimeStamp   

Experiment Schedule Log.PK_EXPT_SCHED_LOG Bound Attachments 
Name  Current Value 


Experiment Schedule Status.PK_EXPT_SCHED_STAT 
Entity Name  Experiment Schedule Status 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule Status.PK_EXPT_SCHED_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Experiment Schedule Status.PK_EXPT_SCHED_STAT Bound Attachments 
Name  Current Value 


Experiment Schedule Workflow.PK_EXPT_SCHED_WRKFLW 
Entity Name  Experiment Schedule Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Schedule Workflow.PK_EXPT_SCHED_WRKFLW Index Columns 
ColumnName  Sort Order 
Facility Identifier   
WorkFlow Identifier   
Order Number   

Experiment Schedule Workflow.PK_EXPT_SCHED_WRKFLW Bound Attachments 
Name  Current Value 


Experiment Workflow.PK_EXPT_WORKFLOW 
Entity Name  Experiment Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Workflow.PK_EXPT_WORKFLOW Index Columns 
ColumnName  Sort Order 
WorkFlow Identifier   

Experiment Workflow.PK_EXPT_WORKFLOW Bound Attachments 
Name  Current Value 


Express Activity.PK_EXPRESS_ACT 
Entity Name  Express Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Express Activity.PK_EXPRESS_ACT Index Columns 
ColumnName  Sort Order 
Activity Identifier   

Express Activity.PK_EXPRESS_ACT Bound Attachments 
Name  Current Value 


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

Express Log.PK_EXPRESS_LOG Index Columns 
ColumnName  Sort Order 
Activity Identifier   
Current TimeStamp   

Express Log.PK_EXPRESS_LOG Bound Attachments 
Name  Current Value 


Express Role Person Association.PK_EXP_ROLE_PERS_ASSC 
Entity Name  Express Role Person Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Express Role Person Association.PK_EXP_ROLE_PERS_ASSC Index Columns 
ColumnName  Sort Order 
Role Identifer   
Person Identifier   
Facility Identifier   

Express Role Person Association.PK_EXP_ROLE_PERS_ASSC Bound Attachments 
Name  Current Value 


Express User Role.PK_EXP_USER_ROLE 
Entity Name  Express User Role 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Express User Role.PK_EXP_USER_ROLE Index Columns 
ColumnName  Sort Order 
Role Identifer   

Express User Role.PK_EXP_USER_ROLE Bound Attachments 
Name  Current Value 


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 


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

Laboratory.PK_LAB Index Columns 
ColumnName  Sort Order 
Laboratory Identifier   

Laboratory.PK_LAB Bound Attachments 
Name  Current Value 


Laboratory Workflow.PK_LAB_WORKFLOW 
Entity Name  Laboratory Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Laboratory Workflow.PK_LAB_WORKFLOW Index Columns 
ColumnName  Sort Order 
WorkFlow Identifier   

Laboratory Workflow.PK_LAB_WORKFLOW Bound Attachments 
Name  Current Value 


Maintenance Activity.PK_MAINT_ACT 
Entity Name  Maintenance Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Maintenance Activity.PK_MAINT_ACT Index Columns 
ColumnName  Sort Order 
Activity Identifier   

Maintenance Activity.PK_MAINT_ACT Bound Attachments 
Name  Current Value 


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

Person.PK_PERSON Index Columns 
ColumnName  Sort Order 
Person Identifier   

Person.PK_PERSON Bound Attachments 
Name  Current Value 


Person.idx_username 
Entity Name  Person 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  Alternate Key 

Person.idx_username Index Columns 
ColumnName  Sort Order 
Username   

Person.idx_username Bound Attachments 
Name  Current Value 


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

Proposal.PK_PROPOSAL Index Columns 
ColumnName  Sort Order 
Proposal Identifier   

Proposal.PK_PROPOSAL Bound Attachments 
Name  Current Value 


Proposal.PROPOSAL_SOR_INDEX 
Entity Name  Proposal 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal.PROPOSAL_SOR_INDEX Index Columns 
ColumnName  Sort Order 
Statement of Research   

Proposal.PROPOSAL_SOR_INDEX Bound Attachments 
Name  Current Value 


Proposal.IDX_PRPSL_STAT_IND 
Entity Name  Proposal 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal.IDX_PRPSL_STAT_IND Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Status Identifier   

Proposal.IDX_PRPSL_STAT_IND Bound Attachments 
Name  Current Value 


Proposal.FK_PRPSL_PRPSL_STAT 
Entity Name  Proposal 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal.FK_PRPSL_PRPSL_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Proposal.FK_PRPSL_PRPSL_STAT Bound Attachments 
Name  Current Value 


Proposal.FK_PRPSL_USR_CAT 
Entity Name  Proposal 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal.FK_PRPSL_USR_CAT Index Columns 
ColumnName  Sort Order 
Proposal Type Identifer   

Proposal.FK_PRPSL_USR_CAT Bound Attachments 
Name  Current Value 


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

Proposal Group.PK_PRPSL_GRP Index Columns 
ColumnName  Sort Order 
Proposal Group Identifier   

Proposal Group.PK_PRPSL_GRP Bound Attachments 
Name  Current Value 


Proposal Group Proposal Assocation.PK_PRPSL_GRP_PRPSL_ASSC 
Entity Name  Proposal Group Proposal Assocation 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Group Proposal Assocation.PK_PRPSL_GRP_PRPSL_ASSC Index Columns 
ColumnName  Sort Order 
Proposal Group Identifier   
Proposal Identifier   
Submission Number   

Proposal Group Proposal Assocation.PK_PRPSL_GRP_PRPSL_ASSC Bound Attachments 
Name  Current Value 


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

Proposal Instrument.PK_PRPSL_INSTR Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   
Instrument Identifier   

Proposal Instrument.PK_PRPSL_INSTR Bound Attachments 
Name  Current Value 


Proposal Instrument.PRPSL_INSTR_IND1 
Entity Name  Proposal Instrument 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal Instrument.PRPSL_INSTR_IND1 Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Instrument Preference   

Proposal Instrument.PRPSL_INSTR_IND1 Bound Attachments 
Name  Current Value 


Proposal Instrument.FK_INSTR_PRPSL_INSTR 
Entity Name  Proposal Instrument 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Proposal Instrument.FK_INSTR_PRPSL_INSTR Index Columns 
ColumnName  Sort Order 
Instrument Identifier   

Proposal Instrument.FK_INSTR_PRPSL_INSTR Bound Attachments 
Name  Current Value 


Proposal Logbook Entry Association.PK_PRPSL_LOG_ENTRY_ASSC 
Entity Name  Proposal Logbook Entry Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Logbook Entry Association.PK_PRPSL_LOG_ENTRY_ASSC Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   
Log Entry Identifier   

Proposal Logbook Entry Association.PK_PRPSL_LOG_ENTRY_ASSC Bound Attachments 
Name  Current Value 


Proposal Submission.PK_PRPSL_SUBMISS 
Entity Name  Proposal Submission 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Submission.PK_PRPSL_SUBMISS Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Submission Number   

Proposal Submission.PK_PRPSL_SUBMISS Bound Attachments 
Name  Current Value 


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

Proposal Type.PK_PRPSL_TYPE Index Columns 
ColumnName  Sort Order 
Proposal Type Identifer   

Proposal Type.PK_PRPSL_TYPE Bound Attachments 
Name  Current Value 


Proposal Type Schedule.PK_PRPSL_TYPE_SCHED 
Entity Name  Proposal Type Schedule 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Type Schedule.PK_PRPSL_TYPE_SCHED Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Proposal Type Identifer   
Start Date   

Proposal Type Schedule.PK_PRPSL_TYPE_SCHED Bound Attachments 
Name  Current Value 


Recent Activity.PK_RECENT_ACT 
Entity Name  Recent Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Recent Activity.PK_RECENT_ACT Index Columns 
ColumnName  Sort Order 
Activity Identifier   

Recent Activity.PK_RECENT_ACT Bound Attachments 
Name  Current Value 


Region Hide.PK_REGION_HIDE 
Entity Name  Region Hide 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Region Hide.PK_REGION_HIDE Index Columns 
ColumnName  Sort Order 
Badge Number   
Region Name   

Region Hide.PK_REGION_HIDE Bound Attachments 
Name  Current Value 


Resource Set Temporary.PK2448 
Entity Name  Resource Set Temporary 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Resource Set Temporary.PK2448 Index Columns 
ColumnName  Sort Order 
Resource Set Identifier   
Experiment Resource Identifier   

Resource Set Temporary.PK2448 Bound Attachments 
Name  Current Value 


Resource Workflow.PK_RSRC_WORKFLOW 
Entity Name  Resource Workflow 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Resource Workflow.PK_RSRC_WORKFLOW Index Columns 
ColumnName  Sort Order 
WorkFlow Identifier   

Resource Workflow.PK_RSRC_WORKFLOW Bound Attachments 
Name  Current Value 


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

Sample.PK_SAMPLE Index Columns 
ColumnName  Sort Order 
Sample Identifier   

Sample.PK_SAMPLE Bound Attachments 
Name  Current Value 


Unit of Measure.PK_UOM 
Entity Name  Unit of Measure 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Unit of Measure.PK_UOM Index Columns 
ColumnName  Sort Order 
Unit Identifier   

Unit of Measure.PK_UOM Bound Attachments 
Name  Current Value 


Unit of Measure Column.PK_UOM_TBL 
Entity Name  Unit of Measure Column 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Unit of Measure Column.PK_UOM_TBL Index Columns 
ColumnName  Sort Order 
Column Name Identifier   

Unit of Measure Column.PK_UOM_TBL Bound Attachments 
Name  Current Value 


Unit of Measure Column Association.PK_UOM_TBL_ASSC 
Entity Name  Unit of Measure Column Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Unit of Measure Column Association.PK_UOM_TBL_ASSC Index Columns 
ColumnName  Sort Order 
Unit Identifier   
Column Name Identifier   

Unit of Measure Column Association.PK_UOM_TBL_ASSC Bound Attachments 
Name  Current Value 


User Application File Association.PK_USER_APPL_FILE_ASSC 
Entity Name  User Application File Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

User Application File Association.PK_USER_APPL_FILE_ASSC Index Columns 
ColumnName  Sort Order 
Badge Number   
Application File Identifier   

User Application File Association.PK_USER_APPL_FILE_ASSC Bound Attachments 
Name  Current Value 


User Email Template Association.PK_USER_EMAIL_TMPL_ASSC 
Entity Name  User Email Template Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

User Email Template Association.PK_USER_EMAIL_TMPL_ASSC Index Columns 
ColumnName  Sort Order 
Badge Number   
Template Identifier   

User Email Template Association.PK_USER_EMAIL_TMPL_ASSC Bound Attachments 
Name  Current Value 


User Profile.PK_USER_PROF 
Entity Name  User Profile 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

User Profile.PK_USER_PROF Index Columns 
ColumnName  Sort Order 
Badge Number   

User Profile.PK_USER_PROF Bound Attachments 
Name  Current Value