| NMR-STAR tag name | _Citation_author.Ordinal |
|---|---|
| Description | NMR-STAR name: _Citation_author.Ordinal Enter a number that defines the position of the author's name in the list of authors. |
| Database field name | Ordinal |
| SQL Database type | INTEGER |
| Part of primary Key | yes |
| Foreign Key on table, column | , |
| Saveframe ID | yes: This tag contains the identifier for this saveframe in the entry. |
| Row Index | yes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Author order |
| Examples | 1 |
| Help text |
| NMR-STAR tag name | _Citation_author.Given_name |
|---|---|
| Description | NMR-STAR name: _Citation_author.Given_name The name given the author at birth or currently used by the author for publication purposes. Can be an initial if the author uses a second name as a full name when publishing. |
| Database field name | GivenName |
| SQL Database type | VARCHAR(31) |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | no |
| Prompt | Author's first name |
| Examples | John |
| Help text |
| NMR-STAR tag name | _Citation_author.Family_name |
|---|---|
| Description | NMR-STAR name: _Citation_author.Family_name The family name of the author. |
| Database field name | FamilyName |
| SQL Database type | VARCHAR(31) |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Author's last name |
| Examples | Doe |
| Help text |
| NMR-STAR tag name | _Citation_author.First_initial |
|---|---|
| Description | NMR-STAR name: _Citation_author.First_initial Initial of the author's first name. |
| Database field name | FirstInitial |
| SQL Database type | VARCHAR(15) |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | no |
| Prompt | Author's first name initial |
| Examples | J. |
| Help text |
| NMR-STAR tag name | _Citation_author.Middle_initials |
|---|---|
| Description | NMR-STAR name: _Citation_author.Middle_initials The initials for the author's middle names. A name can be used here, if the author uses a middle name for publications. |
| Database field name | MiddleInitials |
| SQL Database type | VARCHAR(15) |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | no |
| Prompt | Author's middle initials |
| Examples | L.R. |
| Help text |
| NMR-STAR tag name | _Citation_author.Family_title |
|---|---|
| Description | NMR-STAR name: _Citation_author.Family_title A common family title (not a professional title). |
| Database field name | FamilyTitle |
| SQL Database type | VARCHAR(15) |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | no |
| Enumerations | [click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced. |
| Prompt | Author's family title (not a professional title) |
| Examples | Jr. |
| Help text |
| NMR-STAR tag name | _Citation_author.Sf_ID |
|---|---|
| Description | NMR-STAR name: _Citation_author.Sf_ID Pointer to '_Citation.Sf_ID' |
| Database field name | SfID |
| SQL Database type | INTEGER |
| Part of primary Key | no |
| Foreign Key on table, column | Citation, Sf_ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | yes This field's data is for internal use only and should be hidden in public versiond of the data. |
| Nulls allowed in database? | yes |
| Prompt | Sf ID |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Citation_author.Entry_ID |
|---|---|
| Description | NMR-STAR name: _Citation_author.Entry_ID Pointer to '_Entry.ID' |
| Database field name | EntryID |
| SQL Database type | CHAR(12) |
| Part of primary Key | yes |
| Foreign Key on table, column | Citation, Entry_ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Entry ID |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Citation_author.Citation_ID |
|---|---|
| Description | NMR-STAR name: _Citation_author.Citation_ID Pointer to '_Citation.ID' |
| Database field name | CitationID |
| SQL Database type | INTEGER |
| Part of primary Key | yes |
| Foreign Key on table, column | Citation, ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Citation ID |
| Examples | ? |
| Help text |