NMR-STAR dictionary: database table: SpinSystemLink

Detailed description of the fields

_Spin_system_link.From_spin_system_ID (FromSpinSystemID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.From_spin_system_ID 
DescriptionNMR-STAR name: _Spin_system_link.From_spin_system_ID
Pointer to '_Spin_system.ID'  
Database field nameFromSpinSystemID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnSpin_system, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptFrom spin system ID  
Examples
Help text 

_Spin_system_link.To_spin_system_ID (ToSpinSystemID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.To_spin_system_ID 
DescriptionNMR-STAR name: _Spin_system_link.To_spin_system_ID
Pointer to '_Spin_system.ID'  
Database field nameToSpinSystemID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnSpin_system, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptTo spin system ID  
Examples
Help text 

_Spin_system_link.Offset (SSOffset)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.Offset 
DescriptionNMR-STAR name: _Spin_system_link.Offset
?  
Database field nameSSOffset 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptOffset  
Examples
Help text 

_Spin_system_link.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.Type 
DescriptionNMR-STAR name: _Spin_system_link.Type
?  
Database field nameType 
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
PromptType  
Examples
Help text 

_Spin_system_link.Selected (Selected)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.Selected 
DescriptionNMR-STAR name: _Spin_system_link.Selected
?  
Database field nameSelected 
SQL Database typeVARCHAR(3) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSelected  
Examples
Help text 

_Spin_system_link.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.Sf_ID 
DescriptionNMR-STAR name: _Spin_system_link.Sf_ID
Pointer to '_Resonance_linker_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnResonance_linker_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?no 
PromptSf ID  
Examples
Help text 

_Spin_system_link.Entry_ID (EntryID)

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

_Spin_system_link.Resonance_linker_list_ID (ResonanceLinkerListID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system_link.Resonance_linker_list_ID 
DescriptionNMR-STAR name: _Spin_system_link.Resonance_linker_list_ID
Pointer to '_Resonance_linker_list.ID'  
Database field nameResonanceLinkerListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnResonance_linker_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptResonance linker list ID  
Examples
Help text