NMR-STAR dictionary: database table: SpinSystem

Detailed description of the fields

_Spin_system.ID (SpinSystemID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.ID 
DescriptionNMR-STAR name: _Spin_system.ID
An integer value that uniquely identifies the spin system in the list.  
Database field nameSpinSystemID 
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 
PromptID  
Examples
Help text 

_Spin_system.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Entity_assembly_ID 
DescriptionNMR-STAR name: _Spin_system.Entity_assembly_ID
Pointer to '_Entity_assembly.ID'  
Database field nameEntityAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_assembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptEntity assembly ID  
Examples
Help text 

_Spin_system.Entity_ID (EntityID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Entity_ID 
DescriptionNMR-STAR name: _Spin_system.Entity_ID
Pointer to '_Entity.ID'  
Database field nameEntityID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptEntity ID  
Examples
Help text 

_Spin_system.Comp_index_ID (CompIndexID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Comp_index_ID 
DescriptionNMR-STAR name: _Spin_system.Comp_index_ID
Pointer to '_Entity_comp_index.ID'  
Database field nameCompIndexID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_comp_index, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptComp index ID  
Examples
Help text 

_Spin_system.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Comp_ID 
DescriptionNMR-STAR name: _Spin_system.Comp_ID
Pointer to '_Chem_comp.ID'  
Database field nameCompID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnChem_comp, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptComp ID  
Examples
Help text 

_Spin_system.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Sf_ID 
DescriptionNMR-STAR name: _Spin_system.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.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Entry_ID 
DescriptionNMR-STAR name: _Spin_system.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.Resonance_linker_list_ID (ResonanceLinkerListID)

(go to parent tag category listing)
NMR-STAR tag name_Spin_system.Resonance_linker_list_ID 
DescriptionNMR-STAR name: _Spin_system.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