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

Additional Reviewer.PK_ADDNL_REV Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
First Name   
Last Name   

Additional Reviewer.PK_ADDNL_REV Bound Attachments 
Name  Current Value 


Basic Energy Science Research Area.PK_BES_RSCH_AREA 
Entity Name  Basic Energy Science Research Area 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Basic Energy Science Research Area.PK_BES_RSCH_AREA Index Columns 
ColumnName  Sort Order 
Research Area Identifier   

Basic Energy Science Research Area.PK_BES_RSCH_AREA Bound Attachments 
Name  Current Value 


CNMS Proposal System Activity.PK_CUPS_ACT 
Entity Name  CNMS Proposal System Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

CNMS Proposal System Activity.PK_CUPS_ACT Index Columns 
ColumnName  Sort Order 
Activity Identifier   

CNMS Proposal System Activity.PK_CUPS_ACT Bound Attachments 
Name  Current Value 


CNMS Proposal System Log.PK_CUPS_LOG 
Entity Name  CNMS Proposal System Log 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

CNMS Proposal System Log.PK_CUPS_LOG Index Columns 
ColumnName  Sort Order 
Activity Identifier   
Modify Date   

CNMS Proposal System Log.PK_CUPS_LOG Bound Attachments 
Name  Current Value 


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

Content Type.PK_CONTENT_TYPE Index Columns 
ColumnName  Sort Order 
Content Identifier   

Content Type.PK_CONTENT_TYPE 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 


Description of Research.PK_DESC_RSCH 
Entity Name  Description of Research 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Description of Research.PK_DESC_RSCH Index Columns 
ColumnName  Sort Order 
Description of Research Identifier   

Description of Research.PK_DESC_RSCH 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 Identifer   

Email Preview.PK_EMAIL_PREV Bound Attachments 
Name  Current Value 


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

Email Sent.PK_EMAIL_SENT Index Columns 
ColumnName  Sort Order 
Template Identifier   
Sequence Identifer   

Email Sent.PK_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 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 Identifier   

Email Template Tag.PK_TAG_SRC 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 Cycle.PK_EXPT_CYCLE 
Entity Name  Experiment Cycle 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Experiment Cycle.PK_EXPT_CYCLE Index Columns 
ColumnName  Sort Order 
Cycle Identifier   

Experiment Cycle.PK_EXPT_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 


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

Funding Status.PK_FUND_STAT Index Columns 
ColumnName  Sort Order 
Funding Status Identifier   

Funding Status.PK_FUND_STAT Bound Attachments 
Name  Current Value 


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

Group Capability.PK_GRP_CAPBLTY Index Columns 
ColumnName  Sort Order 
Capability Identifier   

Group Capability.PK_GRP_CAPBLTY Bound Attachments 
Name  Current Value 


Group Leader Research Capability Association.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC 
Entity Name  Group Leader Research Capability Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Group Leader Research Capability Association.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC Index Columns 
ColumnName  Sort Order 
Person Identifier   
Research Capability Identifier   

Group Leader Research Capability Association.PK_GRP_LEAD_RSCH_CAPBLTY_ASSC 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 


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

Member Role.PK_MBR_ROLE Index Columns 
ColumnName  Sort Order 
Member Role Identifier   

Member Role.PK_MBR_ROLE Bound Attachments 
Name  Current Value 


Nonvalidated Experiment Team Member.PK_NONVAL_EXPRT_TEAM_MBR 
Entity Name  Nonvalidated Experiment Team Member 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Nonvalidated Experiment Team Member.PK_NONVAL_EXPRT_TEAM_MBR Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Email Addr   

Nonvalidated Experiment Team Member.PK_NONVAL_EXPRT_TEAM_MBR Bound Attachments 
Name  Current Value 


Page Help.PK_PAGE_HELP 
Entity Name  Page Help 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Page Help.PK_PAGE_HELP Index Columns 
ColumnName  Sort Order 
Page Id   

Page Help.PK_PAGE_HELP 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 Activity.PK_PRPSL_ACT 
Entity Name  Proposal Activity 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Activity.PK_PRPSL_ACT Index Columns 
ColumnName  Sort Order 
Activity Identifier   

Proposal Activity.PK_PRPSL_ACT Bound Attachments 
Name  Current Value 


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

Proposal Category.PK_PRPSL_CAT Index Columns 
ColumnName  Sort Order 
Proposal Category Identifier   

Proposal Category.PK_PRPSL_CAT Bound Attachments 
Name  Current Value 


Proposal Description of Research Association.PK_PRPSL_DESC_RSCH_ASSC 
Entity Name  Proposal Description of Research Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Description of Research Association.PK_PRPSL_DESC_RSCH_ASSC Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Description of Research Identifier   

Proposal Description of Research Association.PK_PRPSL_DESC_RSCH_ASSC Bound Attachments 
Name  Current Value 


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

Proposal Feasibility Review.PK_PRPSL_FEAS_REV Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Feasibility Review.PK_PRPSL_FEAS_REV Bound Attachments 
Name  Current Value 


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

Proposal Funding.PK_PRPSL_FUND Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Funding Identifier   

Proposal Funding.PK_PRPSL_FUND Bound Attachments 
Name  Current Value 


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

Proposal Funding Agency.PK_PRPSL_FUND_AGCY Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Funding Status Identifier   
Funding Agency   

Proposal Funding Agency.PK_PRPSL_FUND_AGCY Bound Attachments 
Name  Current Value 


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

Proposal Funding Country.PK_PRPSL_FUND_CNTRY Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Funding Identifier   
Country Identifier   

Proposal Funding Country.PK_PRPSL_FUND_CNTRY Bound Attachments 
Name  Current Value 


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

Proposal Funding Status.PK_PRPSL_FUND_STAT Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Funding Status Identifier   

Proposal Funding Status.PK_PRPSL_FUND_STAT Bound Attachments 
Name  Current Value 


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

Proposal Instrument Association.PK_PRPSL_INSTR_ASSC Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Instrument Identifier   

Proposal Instrument Association.PK_PRPSL_INSTR_ASSC Bound Attachments 
Name  Current Value 


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

Proposal Log.PK_PRPSL_LOG Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Activity Identifier   
Current Date   

Proposal Log.PK_PRPSL_LOG Bound Attachments 
Name  Current Value 


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

Proposal PDF.PK_PRPSL_PDF Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Content Identifier   

Proposal PDF.PK_PRPSL_PDF Bound Attachments 
Name  Current Value 


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

Proposal Research Area.PK_PRPSL_RSCH_AREA Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Research Area Identifier   

Proposal Research Area.PK_PRPSL_RSCH_AREA Bound Attachments 
Name  Current Value 


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

Proposal Review Committee.PK_PRPSL_REV_COMM Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Review Committee.PK_PRPSL_REV_COMM Bound Attachments 
Name  Current Value 


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

Proposal Role.PK_PRPSL_ROLE Index Columns 
ColumnName  Sort Order 
Role Identifier   

Proposal Role.PK_PRPSL_ROLE Bound Attachments 
Name  Current Value 


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

Proposal Role Person Association.PK_PRPSL_ROLE_PERS_ASSC Index Columns 
ColumnName  Sort Order 
Role Identifier   
Person Identifier   

Proposal Role Person Association.PK_PRPSL_ROLE_PERS_ASSC Bound Attachments 
Name  Current Value 


Proposal Sample Hazard Association.PK_PRPSL_SMPL_HAZ_ASSC 
Entity Name  Proposal Sample Hazard Association 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Proposal Sample Hazard Association.PK_PRPSL_SMPL_HAZ_ASSC Index Columns 
ColumnName  Sort Order 
Sample Safety Identifier   

Proposal Sample Hazard Association.PK_PRPSL_SMPL_HAZ_ASSC Bound Attachments 
Name  Current Value 


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

Proposal Sample Type Association.PK_PRPSL_SMPL_TYPE_ASSC Index Columns 
ColumnName  Sort Order 
Sample Type Identifier   
Proposal Identifier   

Proposal Sample Type Association.PK_PRPSL_SMPL_TYPE_ASSC Bound Attachments 
Name  Current Value 


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

Proposal Science Review.PK_PRPSL_SCI_REV Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Science Review.PK_PRPSL_SCI_REV Bound Attachments 
Name  Current Value 


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

Proposal Staff Contact.PK_PRPSL_STAFF_CONT Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Staff Contact.PK_PRPSL_STAFF_CONT Bound Attachments 
Name  Current Value 


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

Proposal Status.PK_PRPSL_STAT Index Columns 
ColumnName  Sort Order 
Status Identifier   

Proposal Status.PK_PRPSL_STAT Bound Attachments 
Name  Current Value 


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

Proposal Suggested Reviewer.PK_PRPSL_SUGG_REV Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Suggested Reviewer.PK_PRPSL_SUGG_REV Bound Attachments 
Name  Current Value 


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

Proposal Technical Contact.PK_PRPSL_TECH_CONT Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Proposal Technical Contact.PK_PRPSL_TECH_CONT Bound Attachments 
Name  Current Value 


Research Capability.PK_RSCH_CAPBLTY 
Entity Name  Research Capability 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Research Capability.PK_RSCH_CAPBLTY Index Columns 
ColumnName  Sort Order 
Research Capability Identifier   

Research Capability.PK_RSCH_CAPBLTY 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 


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

Sample Type.PK_SMPL_TYPE Index Columns 
ColumnName  Sort Order 
Sample Type Identifier   

Sample Type.PK_SMPL_TYPE Bound Attachments 
Name  Current Value 


Science Review Merit.PK_SCI_REVIEW_MERIT 
Entity Name  Science Review Merit 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Science Review Merit.PK_SCI_REVIEW_MERIT Index Columns 
ColumnName  Sort Order 
Rating Identifier   

Science Review Merit.PK_SCI_REVIEW_MERIT Bound Attachments 
Name  Current Value 


User Access Mode.PK_USER_ACESS_MODE 
Entity Name  User Access Mode 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

User Access Mode.PK_USER_ACESS_MODE Index Columns 
ColumnName  Sort Order 
User Access Identifer   

User Access Mode.PK_USER_ACESS_MODE Bound Attachments 
Name  Current Value 


Validated Experiment Team Member.PK_EXPT_TEAM_MBR 
Entity Name  Validated Experiment Team Member 
Logical Only  NO 
Unique  YES 
Clustered Option  NON-CLUSTERED 
Key Type  PrimaryKey 

Validated Experiment Team Member.PK_EXPT_TEAM_MBR Index Columns 
ColumnName  Sort Order 
Proposal Identifier   
Person Identifier   

Validated Experiment Team Member.PK_EXPT_TEAM_MBR Bound Attachments 
Name  Current Value