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 |