ODMX [ODMX_DBWrench_Schema.xml]
Relationship between Citations and their Authors
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| BridgeID | Integer |
| nextval('"ODMXProvenance"."AuthorLists_BridgeID_seq"'::regclass) | Primary key for a bridge table, enabling many-to-many joins. | ||
| CitationID | Integer | Foreign key identifier for a Citation |
|
||||
| PersonID | Integer | Foreign key identifier for a Person that is an author of the Citation |
|
||||
| AuthorOrder | Integer | Integer order of the authors of the Citation starting with 1 for first author |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_AuthorLists_Citations | ODMXProvenance.Citations | ODMXProvenance.AuthorLists | CitationID | CitationID |
| fk_AuthorLists_People | ODMXCore.Persons | ODMXProvenance.AuthorLists | PersonID | PersonID |
(none)
| Diagram Name |
| ODMXProvenance |