| NMR-STAR tag name | _Study_list.Sf_category |
|---|---|
| Description | NMR-STAR name: _Study_list.Sf_category Category assigned to the information in the saveframe. |
| Database field name | SfCategory |
| 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? | yes |
| Prompt | Sf category |
| Examples | study |
| Help text |
| NMR-STAR tag name | _Study_list.Sf_framecode |
|---|---|
| Description | NMR-STAR name: _Study_list.Sf_framecode Character string that is unique to the saveframe within the data block defined by a specific entry. The character string names the saveframe and may be used to reference or to point to the saveframe later in the data block. |
| Database field name | SfFramecode |
| 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? | yes |
| Prompt | Sf framecode |
| Examples | study |
| Help text |
| NMR-STAR tag name | _Study_list.Entry_ID |
|---|---|
| Description | NMR-STAR name: _Study_list.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 | Entry, ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Entry ID |
| Examples | 4567 |
| Help text |
| NMR-STAR tag name | _Study_list.Sf_ID |
|---|---|
| Description | NMR-STAR name: _Study_list.Sf_ID An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system. |
| Database field name | SfID |
| SQL Database type | INTEGER |
| Part of primary Key | no |
| Foreign Key on table, column | , |
| 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 | 32 |
| Help text |
| NMR-STAR tag name | _Study_list.ID |
|---|---|
| Description | NMR-STAR name: _Study_list.ID An integer value that uniquely identifies one Study_list saveframe from all other Study_list saveframes in the entry. |
| Database field name | StudyListID |
| SQL Database type | INTEGER |
| Part of primary Key | yes |
| Foreign Key on table, column | , |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | ID |
| Examples | 1 |
| Help text |