Basic Energy Sciences Institute Category.PK_BES_INST_CAT 
Entity Name  Basic Energy Sciences Institute Category 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Basic Energy Sciences Institute Category.PK_BES_INST_CAT Index Columns 
ColumnName  Sort Order 
Category Identifier   

Basic Energy Sciences Institute Category.PK_BES_INST_CAT Bound Attachments 
Name  Current Value 


Beam Allocation.PK_BEAM_ALLOC 
Entity Name  Beam Allocation 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Beam Allocation.PK_BEAM_ALLOC Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Facility Identifier   
Run Cycle Identifier   
Allotment Identifier   
Proposal Type Identifer   

Beam Allocation.PK_BEAM_ALLOC Bound Attachments 
Name  Current Value 


Beam Allocation Allotment.PK_BEAM_ALLOC_ALLOT 
Entity Name  Beam Allocation Allotment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Beam Allocation Allotment.PK_BEAM_ALLOC_ALLOT Index Columns 
ColumnName  Sort Order 
Allotment Identifier   

Beam Allocation Allotment.PK_BEAM_ALLOC_ALLOT Bound Attachments 
Name  Current Value 


Beam Allocation Allotment Default.PK_BEAM_ALLOC_DEF 
Entity Name  Beam Allocation Allotment Default 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Beam Allocation Allotment Default.PK_BEAM_ALLOC_DEF Index Columns 
ColumnName  Sort Order 
Allotment Identifier   
Proposal Type Identifer   

Beam Allocation Allotment Default.PK_BEAM_ALLOC_DEF Bound Attachments 
Name  Current Value 


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

Country.PK_CNTRY Index Columns 
ColumnName  Sort Order 
Country Identifier   

Country.PK_CNTRY Bound Attachments 
Name  Current Value 


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

Email Log.PK_EMAIL_LOG Index Columns 
ColumnName  Sort Order 
Template Identifier   
Run Cycle Identifier   
Current Date   
Email Addr   

Email Log.PK_EMAIL_LOG Bound Attachments 
Name  Current Value 


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

Email Preview.PK_EMAIL_PREV Index Columns 
ColumnName  Sort Order 
Template Identifier   
Sequence Identitifer   

Email Preview.PK_EMAIL_PREV Bound Attachments 
Name  Current Value 


Email Preview Attachment.PK_EMAIL_PREV_ATTACH 
Entity Name  Email Preview Attachment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Email Preview Attachment.PK_EMAIL_PREV_ATTACH Index Columns 
ColumnName  Sort Order 
Template Identifier   
Schema   
Attachment Identifier   
Sequence Identitifer   

Email Preview Attachment.PK_EMAIL_PREV_ATTACH Bound Attachments 
Name  Current Value 


Email Sent.IDX_EMAIL_SENT 
Entity Name  Email Sent 
Logical Only  NO 
Unique  NO 
Clustered Option  NON-CLUSTERED 
Key Type  Inversion Entry 

Email Sent.IDX_EMAIL_SENT Index Columns 
ColumnName  Sort Order 
TEMPLATE_ID   
RECPT_EMAIL_ADDR   
PRPSL_ID   

Email Sent.IDX_EMAIL_SENT 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 


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

Email Template Carbon Copy.PK_EMAIL_TMPL_CC Index Columns 
ColumnName  Sort Order 
Template Identifier   
Email Addr   

Email Template Carbon Copy.PK_EMAIL_TMPL_CC Bound Attachments 
Name  Current Value 


Email Template Proposal Type Status Association.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC 
Entity Name  Email Template Proposal Type Status Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Email Template Proposal Type Status Association.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Index Columns 
ColumnName  Sort Order 
Template Identifier   
Proposal Type Identifer   
Status Identifier   

Email Template Proposal Type Status Association.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Bound Attachments 
Name  Current Value 


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

Email Template Recipient.PK_EMAIL_TEMPLATE_RCPT Index Columns 
ColumnName  Sort Order 
Template Identifier   
Email Addr   

Email Template Recipient.PK_EMAIL_TEMPLATE_RCPT Bound Attachments 
Name  Current Value 


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

Email Template Tag.PK_TAG_SRC Index Columns 
ColumnName  Sort Order 
Template Identifier   
TAG_ID   

Email Template Tag.PK_TAG_SRC Bound Attachments 
Name  Current Value 


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

Email Template Tag Global.PK_EMAIL_TMPL_TAG_GLOB Index Columns 
ColumnName  Sort Order 
TAG_ID   

Email Template Tag Global.PK_EMAIL_TMPL_TAG_GLOB Bound Attachments 
Name  Current Value 


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

Email Template Type.PK_EMAIL_TMPL_TYPE Index Columns 
ColumnName  Sort Order 
Email Template Type Identifier   

Email Template Type.PK_EMAIL_TMPL_TYPE 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 


ESH Administrator.PK_ESH_ADMIN 
Entity Name  ESH Administrator 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

ESH Administrator.PK_ESH_ADMIN Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Person Identifier   

ESH Administrator.PK_ESH_ADMIN Bound Attachments 
Name  Current Value 


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

Experiment Facility.PK_EXPT_FACIL Index Columns 
ColumnName  Sort Order 
Facility Identifier   

Experiment Facility.PK_EXPT_FACIL Bound Attachments 
Name  Current Value 


Facility Notice.PK_FACIL_NOTC 
Entity Name  Facility Notice 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Facility Notice.PK_FACIL_NOTC Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Notice Identifer   

Facility Notice.PK_FACIL_NOTC Bound Attachments 
Name  Current Value 


Facility Run Cycle.PK_FACIL_RUN_CYCLE 
Entity Name  Facility Run Cycle 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Facility Run Cycle.PK_FACIL_RUN_CYCLE Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Run Cycle Identifier   
Facility Run Cycle Identifier   

Facility Run Cycle.PK_FACIL_RUN_CYCLE Bound Attachments 
Name  Current Value 


Funding Source.PK_FUND_SRC 
Entity Name  Funding Source 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Funding Source.PK_FUND_SRC Index Columns 
ColumnName  Sort Order 
Funding Identifier   

Funding Source.PK_FUND_SRC Bound Attachments 
Name  Current Value 


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

Glove Material.PK_GLOVE_MATL Index Columns 
ColumnName  Sort Order 
Glove Material Identifier   

Glove Material.PK_GLOVE_MATL Bound Attachments 
Name  Current Value 


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

Institute.PK_INST Index Columns 
ColumnName  Sort Order 
Institute Identifier   

Institute.PK_INST 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 


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

Instrument Configuration.PK_INSTR_CONFIG Index Columns 
ColumnName  Sort Order 
Instrument Configuration Identifier   

Instrument Configuration.PK_INSTR_CONFIG Bound Attachments 
Name  Current Value 


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

Instrument Configuration Association.PK_INSTR_CONFIG_ASSC Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Instrument Configuration Identifier   

Instrument Configuration Association.PK_INSTR_CONFIG_ASSC Bound Attachments 
Name  Current Value 


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

Instrument Contact.PK_INSTR_CONT Index Columns 
ColumnName  Sort Order 
Instrument Identifier   

Instrument Contact.PK_INSTR_CONT Bound Attachments 
Name  Current Value 


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

Instrument Development Team.PK_INSTR_DEV_TEAM Index Columns 
ColumnName  Sort Order 
Person Identifier   
Instrument Identifier   

Instrument Development Team.PK_INSTR_DEV_TEAM Bound Attachments 
Name  Current Value 


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

Instrument Group.PK_INSTR_1 Index Columns 
ColumnName  Sort Order 
Group Identifier   

Instrument Group.PK_INSTR_1 Bound Attachments 
Name  Current Value 


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

Instrument Group Chair.PK_INSTR_GRP_CHAIR Index Columns 
ColumnName  Sort Order 
Group Identifier   
Person Identifier   

Instrument Group Chair.PK_INSTR_GRP_CHAIR Bound Attachments 
Name  Current Value 


Instrument Group Review Subcommittee Association.PK_INSTR_GRP_REV_SUBCOMM_ASSC 
Entity Name  Instrument Group Review Subcommittee Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Group Review Subcommittee Association.PK_INSTR_GRP_REV_SUBCOMM_ASSC Index Columns 
ColumnName  Sort Order 
Group Identifier   
Subcommittee Identifier   

Instrument Group Review Subcommittee Association.PK_INSTR_GRP_REV_SUBCOMM_ASSC Bound Attachments 
Name  Current Value 


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

Instrument Instrument Proposal Question Association.PK_INSTR_INSTR_PRPSL_ASSC Index Columns 
ColumnName  Sort Order 
Question Identifier   
Instrument Identifier   

Instrument Instrument Proposal Question Association.PK_INSTR_INSTR_PRPSL_ASSC Bound Attachments 
Name  Current Value 


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

Instrument Proposal Question.PK_INSTR_PRPSL_QUES Index Columns 
ColumnName  Sort Order 
Question Identifier   

Instrument Proposal Question.PK_INSTR_PRPSL_QUES Bound Attachments 
Name  Current Value 


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

Instrument Proposal Question Select Instrument.PK_INSTR_PRPSL_QUES_SEL_INSTR Index Columns 
ColumnName  Sort Order 
Question Identifier   
Instrument Identifier   

Instrument Proposal Question Select Instrument.PK_INSTR_PRPSL_QUES_SEL_INSTR Bound Attachments 
Name  Current Value 


Instrument Proposal Question Select Value.PK_INSTR_PRPSL_QUES_SEL_VAL 
Entity Name  Instrument Proposal Question Select Value 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Instrument Proposal Question Select Value.PK_INSTR_PRPSL_QUES_SEL_VAL Index Columns 
ColumnName  Sort Order 
Question Identifier   
Value Identifier   

Instrument Proposal Question Select Value.PK_INSTR_PRPSL_QUES_SEL_VAL Bound Attachments 
Name  Current Value 


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

Instrument Reviewer.PK_INSTR_REVIEW Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Role Identifer   
Person Identifier   

Instrument Reviewer.PK_INSTR_REVIEW Bound Attachments 
Name  Current Value 


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

Instrument Scientist.PK_INSTR_SCI Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Badge Number   

Instrument Scientist.PK_INSTR_SCI Bound Attachments 
Name  Current Value 


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

Instrument Support.PK_INSTR_SUP Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Badge Number   
Support Identifier   

Instrument Support.PK_INSTR_SUP Bound Attachments 
Name  Current Value 


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

Instrument Support Role.PK_INSTR_SUP_ROLE Index Columns 
ColumnName  Sort Order 
Support Identifier   

Instrument Support Role.PK_INSTR_SUP_ROLE Bound Attachments 
Name  Current Value 


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

Instrument Team.PK_INSTR_TEAM Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Bn   

Instrument Team.PK_INSTR_TEAM Bound Attachments 
Name  Current Value 


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

Instrument Unavailable.PK_INSTR_UNAVAIL Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Begin Date   
End Date   

Instrument Unavailable.PK_INSTR_UNAVAIL 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 Personal Protection Equipment.PK_LAB_PPE 
Entity Name  Laboratory Personal Protection Equipment 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Laboratory Personal Protection Equipment.PK_LAB_PPE Index Columns 
ColumnName  Sort Order 
Laboratory PPE Identifier   

Laboratory Personal Protection Equipment.PK_LAB_PPE Bound Attachments 
Name  Current Value 


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

Material State.PK_MATL_ST Index Columns 
ColumnName  Sort Order 
State Id   

Material State.PK_MATL_ST Bound Attachments 
Name  Current Value 


Merge Account History.PK_MERGE_ACCT_HIST 
Entity Name  Merge Account History 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Merge Account History.PK_MERGE_ACCT_HIST Index Columns 
ColumnName  Sort Order 
Person Identifier   
Current Date   

Merge Account History.PK_MERGE_ACCT_HIST Bound Attachments 
Name  Current Value 


Nonvalidated Institute.PK_NONVAL_INST 
Entity Name  Nonvalidated Institute 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Nonvalidated Institute.PK_NONVAL_INST Index Columns 
ColumnName  Sort Order 
Nonvalidated Institute Identifier   

Nonvalidated Institute.PK_NONVAL_INST Bound Attachments 
Name  Current Value 


Operational Cycle.PK_OPER_CYCLE 
Entity Name  Operational Cycle 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Operational Cycle.PK_OPER_CYCLE Index Columns 
ColumnName  Sort Order 
Operational Cycle Identifier   

Operational Cycle.PK_OPER_CYCLE 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 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 


Review Subcommittee.PK_REV_SUBCOMM 
Entity Name  Review Subcommittee 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Review Subcommittee.PK_REV_SUBCOMM Index Columns 
ColumnName  Sort Order 
Subcommittee Identifier   

Review Subcommittee.PK_REV_SUBCOMM Bound Attachments 
Name  Current Value 


Review Subcommittee Person Association.PK_REV_SUBCOMM_PERS_ASSC 
Entity Name  Review Subcommittee Person Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Review Subcommittee Person Association.PK_REV_SUBCOMM_PERS_ASSC Index Columns 
ColumnName  Sort Order 
Subcommittee Identifier   
Person Identifier   

Review Subcommittee Person Association.PK_REV_SUBCOMM_PERS_ASSC Bound Attachments 
Name  Current Value 


Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC 
Entity Name  Review Subcommittee Proposal Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC Index Columns 
ColumnName  Sort Order 
Subcommittee Identifier   
Proposal Identifier   
Submission Number   
Instrument Identifier   

Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC Bound Attachments 
Name  Current Value 


Review Subcommittee Scribe.PK_REV_SUBCOMM_SCRIBE 
Entity Name  Review Subcommittee Scribe 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Review Subcommittee Scribe.PK_REV_SUBCOMM_SCRIBE Index Columns 
ColumnName  Sort Order 
Subcommittee Identifier   
Person Identifier   

Review Subcommittee Scribe.PK_REV_SUBCOMM_SCRIBE Bound Attachments 
Name  Current Value 


Run Cycle.PK_RUN_CYCLE 
Entity Name  Run Cycle 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Run Cycle.PK_RUN_CYCLE Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Run Cycle Identifier   

Run Cycle.PK_RUN_CYCLE Bound Attachments 
Name  Current Value 


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

Sample Condition.PK_SMPL_COND Index Columns 
ColumnName  Sort Order 
Sample Environment Identifier   
Sample Condition Identifier   

Sample Condition.PK_SMPL_COND Bound Attachments 
Name  Current Value 


Sample Condition Instrument Association.PK_SMPL_COND_INSTR_ASSC 
Entity Name  Sample Condition Instrument Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Sample Condition Instrument Association.PK_SMPL_COND_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Sample Environment Identifier   
Sample Condition Identifier   
Instrument Identifier   

Sample Condition Instrument Association.PK_SMPL_COND_INSTR_ASSC Bound Attachments 
Name  Current Value 


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

Sample Environment.PK_SMPL_ENV Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Sample Environment Identifier   

Sample Environment.PK_SMPL_ENV Bound Attachments 
Name  Current Value 


Sample Environment Equipment Hazards.PK_SMPL_ENV_EQUIP_HAZ 
Entity Name  Sample Environment Equipment Hazards 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Sample Environment Equipment Hazards.PK_SMPL_ENV_EQUIP_HAZ Index Columns 
ColumnName  Sort Order 
Equipment Hazard Identifier   

Sample Environment Equipment Hazards.PK_SMPL_ENV_EQUIP_HAZ Bound Attachments 
Name  Current Value 


Sample Environment Instrument Association.PK_SMPL_ENV_INSTR_ASSC 
Entity Name  Sample Environment Instrument Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Sample Environment Instrument Association.PK_SMPL_ENV_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Sample Environment Identifier   
Instrument Identifier   
Facility Identifier   

Sample Environment Instrument Association.PK_SMPL_ENV_INSTR_ASSC Bound Attachments 
Name  Current Value 


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

Sample Safety.PK_SMPL_SAFE Index Columns 
ColumnName  Sort Order 
Sample Safety Identifier   

Sample Safety.PK_SMPL_SAFE Bound Attachments 
Name  Current Value 


Science Highlight.PK_SCI_HIGH 
Entity Name  Science Highlight 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight.PK_SCI_HIGH Index Columns 
ColumnName  Sort Order 
Science Highlight Identifier   

Science Highlight.PK_SCI_HIGH Bound Attachments 
Name  Current Value 


Science Highlight Author.PK_SCI_HIGH_AUTH 
Entity Name  Science Highlight Author 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Author.PK_SCI_HIGH_AUTH Index Columns 
ColumnName  Sort Order 
Email Addr   

Science Highlight Author.PK_SCI_HIGH_AUTH Bound Attachments 
Name  Current Value 


Science Highlight Category.PK_SCI_HIGH_CAT 
Entity Name  Science Highlight Category 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Category.PK_SCI_HIGH_CAT Index Columns 
ColumnName  Sort Order 
Science Highlight Category Identifier   

Science Highlight Category.PK_SCI_HIGH_CAT Bound Attachments 
Name  Current Value 


Science Highlight Facility Association.PK_SCI_HIGH_FACIL_ASSC 
Entity Name  Science Highlight Facility Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Facility Association.PK_SCI_HIGH_FACIL_ASSC Index Columns 
ColumnName  Sort Order 
Science Highlight Identifier   
Facility Identifier   

Science Highlight Facility Association.PK_SCI_HIGH_FACIL_ASSC Bound Attachments 
Name  Current Value 


Science Highlight Instrument Association.PK_SCI_HIGH_INSTR_ASSC 
Entity Name  Science Highlight Instrument Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Instrument Association.PK_SCI_HIGH_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Science Highlight Identifier   
Instrument Identifier   

Science Highlight Instrument Association.PK_SCI_HIGH_INSTR_ASSC Bound Attachments 
Name  Current Value 


Science Highlight Principal Investigator.PK_SCI_HIGH_PI 
Entity Name  Science Highlight Principal Investigator 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Principal Investigator.PK_SCI_HIGH_PI Index Columns 
ColumnName  Sort Order 
Email Addr   

Science Highlight Principal Investigator.PK_SCI_HIGH_PI Bound Attachments 
Name  Current Value 


Science Highlight Prinical Investigator Association.PK2274 
Entity Name  Science Highlight Prinical Investigator Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Highlight Prinical Investigator Association.PK2274 Index Columns 
ColumnName  Sort Order 
Science Highlight Identifier   
Email Addr   

Science Highlight Prinical Investigator Association.PK2274 Bound Attachments 
Name  Current Value 


Science Journal.PK_SCI_JOUR 
Entity Name  Science Journal 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Journal.PK_SCI_JOUR Index Columns 
ColumnName  Sort Order 
Journal Identifier   

Science Journal.PK_SCI_JOUR Bound Attachments 
Name  Current Value 


Science Journal Highlight Association.PK_SCI_JOUR_HIGH_ASSC 
Entity Name  Science Journal Highlight Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Journal Highlight Association.PK_SCI_JOUR_HIGH_ASSC Index Columns 
ColumnName  Sort Order 
Journal Identifier   
Science Highlight Identifier   

Science Journal Highlight Association.PK_SCI_JOUR_HIGH_ASSC Bound Attachments 
Name  Current Value 


Science Topic.PK_SCI_TOPIC 
Entity Name  Science Topic 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Topic.PK_SCI_TOPIC Index Columns 
ColumnName  Sort Order 
Topic Identifier   

Science Topic.PK_SCI_TOPIC Bound Attachments 
Name  Current Value 


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

State.PK_STATE Index Columns 
ColumnName  Sort Order 
State Identifier   

State.PK_STATE Bound Attachments 
Name  Current Value 


Training Facility Association.PK_TRAIN_FACIL_ASSC 
Entity Name  Training Facility Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Training Facility Association.PK_TRAIN_FACIL_ASSC Index Columns 
ColumnName  Sort Order 
Facility Identifier   
Module Identifier   

Training Facility Association.PK_TRAIN_FACIL_ASSC Bound Attachments 
Name  Current Value 


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

Training Instrument Association.PK_TRAIN_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Instrument Identifier   
Module Identifier   

Training Instrument Association.PK_TRAIN_INSTR_ASSC Bound Attachments 
Name  Current Value 


Training Module.PK_TRAIN_MOD 
Entity Name  Training Module 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Training Module.PK_TRAIN_MOD Index Columns 
ColumnName  Sort Order 
Module Identifier   

Training Module.PK_TRAIN_MOD Bound Attachments 
Name  Current Value 


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

Training Person.PK_TRAIN_PERSON Index Columns 
ColumnName  Sort Order 
Person Identifier   
Module Identifier   
Complete Date   

Training Person.PK_TRAIN_PERSON Bound Attachments 
Name  Current Value 


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

Unit of Length.PK_UNIT_LEN Index Columns 
ColumnName  Sort Order 
Length Unit Identifier   

Unit of Length.PK_UNIT_LEN Bound Attachments 
Name  Current Value 


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

Unit of Mass.PK_UNIT_MASS Index Columns 
ColumnName  Sort Order 
Mass Unit Identifier   

Unit of Mass.PK_UNIT_MASS Bound Attachments 
Name  Current Value 


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

Unit of Pressure.PK_UNIT_OF_PRESS Index Columns 
ColumnName  Sort Order 
Pressure Unit Identifier   

Unit of Pressure.PK_UNIT_OF_PRESS Bound Attachments 
Name  Current Value 


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

Unit of Temperature.PK_UNIT_TEMP Index Columns 
ColumnName  Sort Order 
Temperature Unit Identifier   

Unit of Temperature.PK_UNIT_TEMP Bound Attachments 
Name  Current Value