Author.PK_AUTHOR |
Entity Name | Author |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Author.PK_AUTHOR Index Columns |
ColumnName | Sort Order |
Author Identifier |
Author.PK_AUTHOR Bound Attachments |
Name | Current Value |
Conference.PK_CONF |
Entity Name | Conference |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Conference.PK_CONF Index Columns |
ColumnName | Sort Order |
Conference Identifier |
Conference.PK_CONF Bound Attachments |
Name | Current Value |
Conference Proceeding.PK_CONF_PROCEED |
Entity Name | Conference Proceeding |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Conference Proceeding.PK_CONF_PROCEED Index Columns |
ColumnName | Sort Order |
Conference Identifier | |
Proceeding Identifier |
Conference Proceeding.PK_CONF_PROCEED 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 Non-Instrument.PK_FACIL_NON_INSTR |
Entity Name | Facility Non-Instrument |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Facility Non-Instrument.PK_FACIL_NON_INSTR Index Columns |
ColumnName | Sort Order |
Facility Identifier | |
Non-Instrument Identifier |
Facility Non-Instrument.PK_FACIL_NON_INSTR Bound Attachments |
Name | Current Value |
Feedback.PK_FEEDBACK |
Entity Name | Feedback |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Feedback.PK_FEEDBACK Index Columns |
ColumnName | Sort Order |
Email Addr |
Feedback.PK_FEEDBACK Bound Attachments |
Name | Current Value |
Feedback Status.PK_FEEDBACK_STAT |
Entity Name | Feedback Status |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Feedback Status.PK_FEEDBACK_STAT Index Columns |
ColumnName | Sort Order |
Status Identifier |
Feedback Status.PK_FEEDBACK_STAT 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 Exclude.PK_INSTR_EXCL |
Entity Name | Instrument Exclude |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Instrument Exclude.PK_INSTR_EXCL Index Columns |
ColumnName | Sort Order |
Instrument Identifier |
Instrument Exclude.PK_INSTR_EXCL Bound Attachments |
Name | Current Value |
Journal.PK_JOURNAL |
Entity Name | Journal |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Journal.PK_JOURNAL Index Columns |
ColumnName | Sort Order |
Journal Identifier |
Journal.PK_JOURNAL Bound Attachments |
Name | Current Value |
Journal Impact Factor.PK_JL_IMP_FACT |
Entity Name | Journal Impact Factor |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Journal Impact Factor.PK_JL_IMP_FACT Index Columns |
ColumnName | Sort Order |
Journal Identifier | |
Year |
Journal Impact Factor.PK_JL_IMP_FACT Bound Attachments |
Name | Current Value |
Person.PK_PERSON |
Entity Name | Person |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Person.PK_PERSON Index Columns |
ColumnName | Sort Order |
Person Identifier |
Person.PK_PERSON Bound Attachments |
Name | Current Value |
Person.idx_username |
Entity Name | Person |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Person.idx_username Index Columns |
ColumnName | Sort Order |
Username |
Person.idx_username Bound Attachments |
Name | Current Value |
Proposal.PK_PROPOSAL |
Entity Name | Proposal |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Proposal.PK_PROPOSAL Index Columns |
ColumnName | Sort Order |
Proposal Identifier |
Proposal.PK_PROPOSAL Bound Attachments |
Name | Current Value |
Proposal.PROPOSAL_SOR_INDEX |
Entity Name | Proposal |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal.PROPOSAL_SOR_INDEX Index Columns |
ColumnName | Sort Order |
Statement of Research |
Proposal.PROPOSAL_SOR_INDEX Bound Attachments |
Name | Current Value |
Proposal.IDX_PRPSL_STAT_IND |
Entity Name | Proposal |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal.IDX_PRPSL_STAT_IND Index Columns |
ColumnName | Sort Order |
Proposal Identifier | |
Status Identifier |
Proposal.IDX_PRPSL_STAT_IND Bound Attachments |
Name | Current Value |
Proposal.FK_PRPSL_PRPSL_STAT |
Entity Name | Proposal |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal.FK_PRPSL_PRPSL_STAT Index Columns |
ColumnName | Sort Order |
Status Identifier |
Proposal.FK_PRPSL_PRPSL_STAT Bound Attachments |
Name | Current Value |
Proposal.FK_PRPSL_USR_CAT |
Entity Name | Proposal |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal.FK_PRPSL_USR_CAT Index Columns |
ColumnName | Sort Order |
Proposal Type Identifer |
Proposal.FK_PRPSL_USR_CAT Bound Attachments |
Name | Current Value |
Proposal Instrument.PK_PRPSL_INSTR |
Entity Name | Proposal Instrument |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Proposal Instrument.PK_PRPSL_INSTR Index Columns |
ColumnName | Sort Order |
Proposal Identifier | |
Submission Number | |
Instrument Identifier |
Proposal Instrument.PK_PRPSL_INSTR Bound Attachments |
Name | Current Value |
Proposal Instrument.PRPSL_INSTR_IND1 |
Entity Name | Proposal Instrument |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal Instrument.PRPSL_INSTR_IND1 Index Columns |
ColumnName | Sort Order |
Instrument Identifier | |
Instrument Preference |
Proposal Instrument.PRPSL_INSTR_IND1 Bound Attachments |
Name | Current Value |
Proposal Instrument.FK_INSTR_PRPSL_INSTR |
Entity Name | Proposal Instrument |
Logical Only | NO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Proposal Instrument.FK_INSTR_PRPSL_INSTR Index Columns |
ColumnName | Sort Order |
Instrument Identifier |
Proposal Instrument.FK_INSTR_PRPSL_INSTR Bound Attachments |
Name | Current Value |
Publication.PK_PUBL |
Entity Name | Publication |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication.PK_PUBL Index Columns |
ColumnName | Sort Order |
Publication Identifer |
Publication.PK_PUBL Bound Attachments |
Name | Current Value |
Publication Activity.PK_PUBL_ACT |
Entity Name | Publication Activity |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Activity.PK_PUBL_ACT Index Columns |
ColumnName | Sort Order |
Activity Identifier |
Publication Activity.PK_PUBL_ACT Bound Attachments |
Name | Current Value |
Publication Author Association.PK_PUB_AUTHOR_ASSC |
Entity Name | Publication Author Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Author Association.PK_PUB_AUTHOR_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Author Identifier | |
Rank |
Publication Author Association.PK_PUB_AUTHOR_ASSC Bound Attachments |
Name | Current Value |
Publication Facility Non_Instrument Association.PK_PUBL_FACIL_NON_INSTR_ASSC |
Entity Name | Publication Facility Non_Instrument Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Facility Non_Instrument Association.PK_PUBL_FACIL_NON_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Facility Identifier | |
Non-Instrument Identifier |
Publication Facility Non_Instrument Association.PK_PUBL_FACIL_NON_INSTR_ASSC Bound Attachments |
Name | Current Value |
Publication Instrument Assocation.PK_PUBL_PRPSL_INSTR_ASSC |
Entity Name | Publication Instrument Assocation |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Instrument Assocation.PK_PUBL_PRPSL_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Instrument Identifier |
Publication Instrument Assocation.PK_PUBL_PRPSL_INSTR_ASSC Bound Attachments |
Name | Current Value |
Publication Log.PK_PUB_LOG |
Entity Name | Publication Log |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Log.PK_PUB_LOG Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Activity Identifier | |
Current Date |
Publication Log.PK_PUB_LOG Bound Attachments |
Name | Current Value |
Publication Proposal Instrument Association.PK_PUBL_PRPSL_ASSC |
Entity Name | Publication Proposal Instrument Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Proposal Instrument Association.PK_PUBL_PRPSL_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Proposal Identifier | |
Submission Number | |
Instrument Identifier |
Publication Proposal Instrument Association.PK_PUBL_PRPSL_ASSC Bound Attachments |
Name | Current Value |
Publication Research Area Association.PK_PUBL_RSCH_AREA_ASSC |
Entity Name | Publication Research Area Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Research Area Association.PK_PUBL_RSCH_AREA_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Proposal Identifier | |
Research Area Identifier |
Publication Research Area Association.PK_PUBL_RSCH_AREA_ASSC Bound Attachments |
Name | Current Value |
Publication Special Recognition Association.PK_PUBL_SPEC_RECOG_ASSC |
Entity Name | Publication Special Recognition Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Special Recognition Association.PK_PUBL_SPEC_RECOG_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Special Recognition Identifier |
Publication Special Recognition Association.PK_PUBL_SPEC_RECOG_ASSC Bound Attachments |
Name | Current Value |
Publication Stage.PK_PUBL_STAGE |
Entity Name | Publication Stage |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Stage.PK_PUBL_STAGE Index Columns |
ColumnName | Sort Order |
Publication Identifer |
Publication Stage.PK_PUBL_STAGE Bound Attachments |
Name | Current Value |
Publication Stage Instrument Association.PK_PUBL_STAGE_INSTR_ASSC |
Entity Name | Publication Stage Instrument Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Stage Instrument Association.PK_PUBL_STAGE_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Instrument Identifier |
Publication Stage Instrument Association.PK_PUBL_STAGE_INSTR_ASSC Bound Attachments |
Name | Current Value |
Publication Stage Non-Instrument Association.PK_PUBL_STAGE_NON_INSTR_ASSC |
Entity Name | Publication Stage Non-Instrument Association |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Stage Non-Instrument Association.PK_PUBL_STAGE_NON_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Facility Identifier | |
Non-Instrument Identifier |
Publication Stage Non-Instrument Association.PK_PUBL_STAGE_NON_INSTR_ASSC Bound Attachments |
Name | Current Value |
Publication Stage Research Area Assc.PK_PUBL_STAGE_RSCH_AREA_ASSC |
Entity Name | Publication Stage Research Area Assc |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Stage Research Area Assc.PK_PUBL_STAGE_RSCH_AREA_ASSC Index Columns |
ColumnName | Sort Order |
Publication Identifer | |
Research Area Identifier |
Publication Stage Research Area Assc.PK_PUBL_STAGE_RSCH_AREA_ASSC Bound Attachments |
Name | Current Value |
Publication Type.PK_PUBL_TYPE |
Entity Name | Publication Type |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Publication Type.PK_PUBL_TYPE Index Columns |
ColumnName | Sort Order |
Publication Type Identifer |
Publication Type.PK_PUBL_TYPE Bound Attachments |
Name | Current Value |
Special Recognition.PK_SPEC_RECOG |
Entity Name | Special Recognition |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Special Recognition.PK_SPEC_RECOG Index Columns |
ColumnName | Sort Order |
Special Recognition Identifier |
Special Recognition.PK_SPEC_RECOG Bound Attachments |
Name | Current Value |
Status.PK_STATUS |
Entity Name | Status |
Logical Only | NO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Status.PK_STATUS Index Columns |
ColumnName | Sort Order |
Status Identifier |
Status.PK_STATUS Bound Attachments |
Name | Current Value |