"Person to Proposal Instrument" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Proposal Instrument |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Person to Proposal Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Proposal Instrument" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Feasbility Review Person Identifier |
"Person to Proposal Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Proposal Instrument" Bound Attachments |
Name | Current Value |
"Person to Author" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_AUTHOR_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Author |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Person to Author" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Author" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Author" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Author" Bound Attachments |
Name | Current Value |
"Conference to Conference Proceeding" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CONF_PROCEED_TO_CONF |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Conference |
Child Entity | Conference Proceeding |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Conference to Conference Proceeding" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Conference to Conference Proceeding" Foreign Keys |
Parent Key | Child Key |
Conference Identifier | Conference Identifier |
"Conference to Conference Proceeding" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Conference to Conference Proceeding" Bound Attachments |
Name | Current Value |
"Facility Non-Instrument to Publication Facility Non_Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FAC_NINSTR_TO_FAC_NINSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Facility Non-Instrument |
Child Entity | Publication Facility Non_Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Facility Non-Instrument to Publication Facility Non_Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Facility Non-Instrument to Publication Facility Non_Instrument Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Non-Instrument Identifier | Facility Identifier, Non-Instrument Identifier |
"Facility Non-Instrument to Publication Facility Non_Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Facility Non-Instrument to Publication Facility Non_Instrument Association" Bound Attachments |
Name | Current Value |
"Publication to Publication Facility Non_Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FACIL_NINSTR_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Facility Non_Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Facility Non_Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Facility Non_Instrument Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Facility Non_Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Facility Non_Instrument Association" Bound Attachments |
Name | Current Value |
"Experiment Facility to Facility Non-Instrument" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FACIL_NON_INSTR_TO_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Facility Non-Instrument |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Facility Non-Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Facility Non-Instrument" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Facility Non-Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Facility Non-Instrument" Bound Attachments |
Name | Current Value |
"Feedback Status to Feedback" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_FEED_TO_FEED_STAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Feedback Status |
Child Entity | Feedback |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Feedback Status to Feedback" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Feedback Status to Feedback" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Feedback Status to Feedback" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Feedback Status to Feedback" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Exclude" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_excl_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Exclude |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Exclude" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Exclude" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Exclude" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Exclude" Bound Attachments |
Name | Current Value |
"Experiment Facility to Instrument" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_EXPT_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Instrument |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Instrument" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Instrument" Bound Attachments |
Name | Current Value |
"Journal to Journal Impact Factor" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_JL_IMP_FACT_TO_JL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Journal |
Child Entity | Journal Impact Factor |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Journal to Journal Impact Factor" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Journal to Journal Impact Factor" Foreign Keys |
Parent Key | Child Key |
Journal Identifier | Journal Identifier |
"Journal to Journal Impact Factor" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Journal to Journal Impact Factor" Bound Attachments |
Name | Current Value |
"Person to Proposal Instrument" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_LOCAL_CONT_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Proposal Instrument |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Person to Proposal Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Proposal Instrument" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Experiment Local Contact Person Identifier |
"Person to Proposal Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Proposal Instrument" Bound Attachments |
Name | Current Value |
"Person to Proposal Instrument" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_OPER_FEAS_REV_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Proposal Instrument |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Person to Proposal Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Proposal Instrument" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Oeprational Feasibility Review Person Identifier |
"Person to Proposal Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Proposal Instrument" Bound Attachments |
Name | Current Value |
"Institute to Person" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_TO_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Institute to Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Person" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Person" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Proposal Instrument" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PRPSL_INSTR_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Proposal Instrument |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Proposal Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Proposal Instrument" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Proposal Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Proposal Instrument" Bound Attachments |
Name | Current Value |
"Institute to Proposal" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_to_inst |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Proposal |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Institute to Proposal" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Proposal" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Proposal" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Proposal" Bound Attachments |
Name | Current Value |
"Person to Proposal" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_to_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Proposal |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Proposal" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Proposal" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Proposal" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Proposal" Bound Attachments |
Name | Current Value |
"Facility Non-Instrument to Publication Stage Non-Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSNIA_TO_FACIL_NON_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Facility Non-Instrument |
Child Entity | Publication Stage Non-Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Facility Non-Instrument to Publication Stage Non-Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Facility Non-Instrument to Publication Stage Non-Instrument Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Non-Instrument Identifier | Facility Identifier, Non-Instrument Identifier |
"Facility Non-Instrument to Publication Stage Non-Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Facility Non-Instrument to Publication Stage Non-Instrument Association" Bound Attachments |
Name | Current Value |
"Publication Stage to Publication Stage Non-Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSNIA_TO_PUBL_STAGE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Stage |
Child Entity | Publication Stage Non-Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Stage to Publication Stage Non-Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Stage to Publication Stage Non-Instrument Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication Stage to Publication Stage Non-Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Stage to Publication Stage Non-Instrument Association" Bound Attachments |
Name | Current Value |
"Publication Stage to Publication Stage Research Area Assc" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSRAA_TO_PUBL_STAGE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Stage |
Child Entity | Publication Stage Research Area Assc |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Stage to Publication Stage Research Area Assc" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Stage to Publication Stage Research Area Assc" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication Stage to Publication Stage Research Area Assc" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Stage to Publication Stage Research Area Assc" Bound Attachments |
Name | Current Value |
"Proposal Instrument to Publication Proposal Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUB_PRP_ASSC_TO_PRP_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Instrument |
Child Entity | Publication Proposal Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Instrument to Publication Proposal Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Instrument to Publication Proposal Instrument Association" Foreign Keys |
Parent Key | Child Key |
Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
"Proposal Instrument to Publication Proposal Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Instrument to Publication Proposal Instrument Association" Bound Attachments |
Name | Current Value |
"Publication Stage to Publication Stage Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUB_ST_INS_ASSC_TO_PUB_ST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Stage |
Child Entity | Publication Stage Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Stage to Publication Stage Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Stage to Publication Stage Instrument Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication Stage to Publication Stage Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Stage to Publication Stage Instrument Association" Bound Attachments |
Name | Current Value |
"Institute to Publication Author Association" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_AUTH_ASSC_TO_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Publication Author Association |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Institute to Publication Author Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Publication Author Association" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Publication Author Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Publication Author Association" Bound Attachments |
Name | Current Value |
"Author to Publication Author Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_AUTHOR_TO_AUTHOR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Author |
Child Entity | Publication Author Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Author to Publication Author Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Author to Publication Author Association" Foreign Keys |
Parent Key | Child Key |
Author Identifier | Author Identifier |
"Author to Publication Author Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Author to Publication Author Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Publication Instrument Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_INSTR_ASSC_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Publication Instrument Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Publication Instrument Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Publication Instrument Assocation" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Publication Instrument Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Publication Instrument Assocation" Bound Attachments |
Name | Current Value |
"Publication to Publication Instrument Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_INSTR_ASSC_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Instrument Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Instrument Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Instrument Assocation" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Instrument Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Instrument Assocation" Bound Attachments |
Name | Current Value |
"Publication to Publication Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_LOG_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Log" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Log" Bound Attachments |
Name | Current Value |
"Publication Activity to Publication Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_LOG_TO_PUBL_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Activity |
Child Entity | Publication Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Activity to Publication Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Activity to Publication Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Publication Activity to Publication Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Activity to Publication Log" Bound Attachments |
Name | Current Value |
"Publication to Publication Proposal Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_PRPSL_ASSC_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Proposal Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Proposal Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Proposal Instrument Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Proposal Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Proposal Instrument Association" Bound Attachments |
Name | Current Value |
"Publication to Publication Research Area Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_RSCH_AREA_ASSC_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Research Area Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Research Area Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Research Area Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Research Area Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Research Area Association" Bound Attachments |
Name | Current Value |
"Publication to Publication Special Recognition Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_SR_ASSC_TO_PUBL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Special Recognition Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Special Recognition Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Special Recognition Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Special Recognition Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Special Recognition Association" Bound Attachments |
Name | Current Value |
"Special Recognition to Publication Special Recognition Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_SR_ASSC_TO_SPEC_RECOG |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Special Recognition |
Child Entity | Publication Special Recognition Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Special Recognition to Publication Special Recognition Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Special Recognition to Publication Special Recognition Association" Foreign Keys |
Parent Key | Child Key |
Special Recognition Identifier | Special Recognition Identifier |
"Special Recognition to Publication Special Recognition Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Special Recognition to Publication Special Recognition Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Publication Stage Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_ST_INSTR_ASSC_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Publication Stage Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Publication Stage Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Publication Stage Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Publication Stage Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Publication Stage Instrument Association" Bound Attachments |
Name | Current Value |
"Conference to Publication Stage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_CONF |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Conference |
Child Entity | Publication Stage |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Conference to Publication Stage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Conference to Publication Stage" Foreign Keys |
Parent Key | Child Key |
Conference Identifier | Conference Identifier |
"Conference to Publication Stage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Conference to Publication Stage" Bound Attachments |
Name | Current Value |
"Institute to Publication Stage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Publication Stage |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Institute to Publication Stage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Publication Stage" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Publication Stage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Publication Stage" Bound Attachments |
Name | Current Value |
"Journal to Publication Stage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_JOURNAL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Journal |
Child Entity | Publication Stage |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Journal to Publication Stage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Journal to Publication Stage" Foreign Keys |
Parent Key | Child Key |
Journal Identifier | Journal Identifier |
"Journal to Publication Stage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Journal to Publication Stage" Bound Attachments |
Name | Current Value |
"Publication Type to Publication Stage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_PUBL_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Type |
Child Entity | Publication Stage |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Type to Publication Stage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Type to Publication Stage" Foreign Keys |
Parent Key | Child Key |
Publication Type Identifer | Publication Type Identifer |
"Publication Type to Publication Stage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Type to Publication Stage" Bound Attachments |
Name | Current Value |
"PUBL.Status to Publication Stage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_publ_stage_to_status |
Relationship Business Name | |
Logical Only | No |
Parent Entity | PUBL.Status |
Child Entity | Publication Stage |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"PUBL.Status to Publication Stage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL.Status to Publication Stage" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"PUBL.Status to Publication Stage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL.Status to Publication Stage" Bound Attachments |
Name | Current Value |
"Conference to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_CONF |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Conference |
Child Entity | Publication |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Conference to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Conference to Publication" Foreign Keys |
Parent Key | Child Key |
Conference Identifier | Conference Identifier |
"Conference to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Conference to Publication" Bound Attachments |
Name | Current Value |
"Conference Proceeding to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_CONF_PROCEED |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Conference Proceeding |
Child Entity | Publication |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Conference Proceeding to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Conference Proceeding to Publication" Foreign Keys |
Parent Key | Child Key |
Conference Identifier, Proceeding Identifier | Conference Identifier, Proceeding Identifier |
"Conference Proceeding to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Conference Proceeding to Publication" Bound Attachments |
Name | Current Value |
"Institute to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Publication |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Institute to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Publication" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Publication" Bound Attachments |
Name | Current Value |
"Journal to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_JOURNAL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Journal |
Child Entity | Publication |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Journal to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Journal to Publication" Foreign Keys |
Parent Key | Child Key |
Journal Identifier | Journal Identifier |
"Journal to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Journal to Publication" Bound Attachments |
Name | Current Value |
"Publication to Publication Author Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_PUBL_AUTHOR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication |
Child Entity | Publication Author Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication to Publication Author Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication to Publication Author Association" Foreign Keys |
Parent Key | Child Key |
Publication Identifer | Publication Identifer |
"Publication to Publication Author Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication to Publication Author Association" Bound Attachments |
Name | Current Value |
"Publication Type to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_PUBL_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Publication Type |
Child Entity | Publication |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Publication Type to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Publication Type to Publication" Foreign Keys |
Parent Key | Child Key |
Publication Type Identifer | Publication Type Identifer |
"Publication Type to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Publication Type to Publication" Bound Attachments |
Name | Current Value |
"PUBL.Status to Publication" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_STATUS |
Relationship Business Name | |
Logical Only | No |
Parent Entity | PUBL.Status |
Child Entity | Publication |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"PUBL.Status to Publication" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL.Status to Publication" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"PUBL.Status to Publication" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL.Status to Publication" Bound Attachments |
Name | Current Value |