NMR-STAR dictionary: database table: SecondaryStructList

Detailed description of the fields

_Secondary_struct_list.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.Sf_category 
DescriptionNMR-STAR name: _Secondary_struct_list.Sf_category
Category definition for the information content of the saveframe  
Database field nameSfCategory 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSf category  
Examples
Help text 

_Secondary_struct_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.Sf_framecode 
DescriptionNMR-STAR name: _Secondary_struct_list.Sf_framecode
A label for the saveframe that describes in very brief terms the information contained in the saveframe.  
Database field nameSfFramecode 
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?yes 
PromptLabel for the set of secondary structural elements deduced from the atomic coordinates  
Examples
Help text 

_Secondary_struct_list.Entry_ID (EntryID)

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

_Secondary_struct_list.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.Sf_ID 
DescriptionNMR-STAR name: _Secondary_struct_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 nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
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  
Examples
Help text 

_Secondary_struct_list.ID (SecondaryStructListID)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.ID 
DescriptionNMR-STAR name: _Secondary_struct_list.ID
An integer value that uniquely identifies this saveframe of secondary structure element data from other saveframes of this category in an entry.  
Database field nameSecondaryStructListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSecondary struct list ID  
Examples1  
Help text 

_Secondary_struct_list.Representative_conformer_ID (RepresentativeConformerID)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.Representative_conformer_ID 
DescriptionNMR-STAR name: _Secondary_struct_list.Representative_conformer_ID
Pointer to '_Representative_conformer.ID'  
Database field nameRepresentativeConformerID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnRepresentative_conformer, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptRepresentative conformer ID  
Examples
Help text 

_Secondary_struct_list.Representative_conformer_label (RepresentativeConformerLabel)

(go to parent tag category listing)
NMR-STAR tag name_Secondary_struct_list.Representative_conformer_label 
DescriptionNMR-STAR name: _Secondary_struct_list.Representative_conformer_label
Pointer to a saveframe of the category 'representative_conformer'  
Database field nameRepresentativeConformerLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnRepresentative_conformer, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptLabel for the representative conformer exhibiting the listed tertiary structure elements.  
Examples
Help text