| NMR-STAR tag name | _Spectral_transition.ID |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.ID Unique identifier for the spectral peak. |
| Database field name | SpectralTransitionID |
| 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 | Peak ID |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Spectral_transition.Figure_of_merit |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.Figure_of_merit A quantitative or qualitative value that provides a measure of certainty that the peak listed represents a real piece of data. |
| Database field name | FigureOfMerit |
| SQL Database type | FLOAT |
| 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 | Figure of merit |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Spectral_transition.Details |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.Details Text providing additional information regarding the spectral peak. |
| Database field name | Details |
| SQL Database type | VARCHAR(127) |
| 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 | Details |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Spectral_transition.Sf_ID |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.Sf_ID Pointer to '_Spectral_peak_list.Sf_ID' |
| Database field name | SfID |
| SQL Database type | INTEGER |
| Part of primary Key | no |
| Foreign Key on table, column | Spectral_peak_list, 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 | _Spectral_transition.Entry_ID |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.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 | Spectral_peak_list, 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 | _Spectral_transition.Spectral_peak_list_ID |
|---|---|
| Description | NMR-STAR name: _Spectral_transition.Spectral_peak_list_ID Pointer to '_Spectral_peak_list.ID' |
| Database field name | SpectralPeakListID |
| SQL Database type | INTEGER |
| Part of primary Key | yes |
| Foreign Key on table, column | Spectral_peak_list, ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Spectral peak list ID |
| Examples | ? |
| Help text |