NMR-STAR dictionary: database table: StudyEntryList

Detailed description of the fields

_Study_entry_list.Study_ID (StudyID)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.Study_ID 
DescriptionNMR-STAR name: _Study_entry_list.Study_ID
Pointer to '_Study.ID' not within the entry but across the database.  
Database field nameStudyID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnStudy, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptStudy ID  
Examples  
Help text 

_Study_entry_list.BMRB_accession_code (BMRBAccessionCode)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.BMRB_accession_code 
DescriptionNMR-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 nameBMRBAccessionCode 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptBMRB accession number for an entry in the study  
Examples4398  
Help text 

_Study_entry_list.BMRB_entry_description (BMRBEntryDescription)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.BMRB_entry_description 
DescriptionNMR-STAR name: _Study_entry_list.BMRB_entry_description
A brief description defining the relationship between the entry and the study.  
Database field nameBMRBEntryDescription 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptDescription for BMRB entry  
ExamplesAssigned chemical shift entry  
Help text 

_Study_entry_list.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.Details 
DescriptionNMR-STAR name: _Study_entry_list.Details
Text providing additional information describing the relationship between the entry and the study.  
Database field nameDetails 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptText details concerning BMRB entry  
ExamplesComplete 13C 15N and 1H chemical shift assignments.  
Help text 

_Study_entry_list.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.Sf_ID 
DescriptionNMR-STAR name: _Study_entry_list.Sf_ID
Pointer to '_Study_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnStudy_list, Sf_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagyes
This field's data is for internal use only and should be hidden in public versiond of the data. 
Nulls allowed in database?yes 
PromptSf ID  
Examples32  
Help text 

_Study_entry_list.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.Entry_ID 
DescriptionNMR-STAR name: _Study_entry_list.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnStudy_list, Entry_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntry ID  
Examples4567  
Help text 

_Study_entry_list.Study_list_ID (StudyListID)

(go to parent tag category listing)
NMR-STAR tag name_Study_entry_list.Study_list_ID 
DescriptionNMR-STAR name: _Study_entry_list.Study_list_ID
Pointer to '_Study_list.ID'  
Database field nameStudyListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnStudy_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptStudy list ID  
Examples1  
Help text