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 |