NMR-STAR tag name | _Study_entry_list.Study_ID |
---|---|
Description | NMR-STAR name: _Study_entry_list.Study_ID Pointer to '_Study.ID' not within the entry but across the database. |
Database field name | StudyID |
SQL Database type | INTEGER |
Part of primary Key | yes |
Foreign Key on table, column | Study, ID |
Saveframe ID | no |
Row Index | no |
Secondary Index | no |
Internal Flag | no |
Nulls allowed in database? | yes |
Prompt | Study ID |
Examples | |
Help text |
NMR-STAR tag name | _Study_entry_list.BMRB_accession_code |
---|---|
Description | NMR-STAR name: _Study_entry_list.BMRB_accession_code Enter the BMRB accession number(s) for the entries that are members of the study. |
Database field name | BMRBAccessionCode |
SQL Database type | CHAR(12) |
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 | BMRB accession number for an entry in the study |
Examples | 4398 |
Help text |
NMR-STAR tag name | _Study_entry_list.BMRB_entry_description |
---|---|
Description | NMR-STAR name: _Study_entry_list.BMRB_entry_description A brief description defining the relationship between the entry and the study. |
Database field name | BMRBEntryDescription |
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 | Description for BMRB entry |
Examples | Assigned chemical shift entry |
Help text |
NMR-STAR tag name | _Study_entry_list.Details |
---|---|
Description | NMR-STAR name: _Study_entry_list.Details Text providing additional information describing the relationship between the entry and the study. |
Database field name | Details |
SQL Database type | TEXT |
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 | Text details concerning BMRB entry |
Examples | Complete 13C 15N and 1H chemical shift assignments. |
Help text |
NMR-STAR tag name | _Study_entry_list.Sf_ID |
---|---|
Description | NMR-STAR name: _Study_entry_list.Sf_ID Pointer to '_Study_list.Sf_ID' |
Database field name | SfID |
SQL Database type | INTEGER |
Part of primary Key | no |
Foreign Key on table, column | Study_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 | 32 |
Help text |
NMR-STAR tag name | _Study_entry_list.Entry_ID |
---|---|
Description | NMR-STAR name: _Study_entry_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 | Study_list, 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_entry_list.Study_list_ID |
---|---|
Description | NMR-STAR name: _Study_entry_list.Study_list_ID Pointer to '_Study_list.ID' |
Database field name | StudyListID |
SQL Database type | INTEGER |
Part of primary Key | yes |
Foreign Key on table, column | Study_list, ID |
Saveframe ID | no |
Row Index | no |
Secondary Index | no |
Internal Flag | no |
Nulls allowed in database? | yes |
Prompt | Study list ID |
Examples | 1 |
Help text |