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 |