NMR-STAR dictionary: database table: SubsystemCitation

Detailed description of the fields

_Subsystem_citation.Citation_ID (CitationID)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_citation.Citation_ID 
DescriptionNMR-STAR name: _Subsystem_citation.Citation_ID
Pointer to '_Citation.ID'  
Database field nameCitationID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnCitation, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptCit ID  
Examples
Help text 

_Subsystem_citation.Citation_label (CitationLabel)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_citation.Citation_label 
DescriptionNMR-STAR name: _Subsystem_citation.Citation_label
Pointer to a saveframe of the category citation.  
Database field nameCitationLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnCitation, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptCit label  
Examples
Help text 

_Subsystem_citation.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_citation.Sf_ID 
DescriptionNMR-STAR name: _Subsystem_citation.Sf_ID
Pointer to '_Assembly_subsystem.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssembly_subsystem, 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  
Examples
Help text 

_Subsystem_citation.Entry_ID (EntryID)

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

_Subsystem_citation.Assembly_subsystem_ID (AssemblySubsystemID)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_citation.Assembly_subsystem_ID 
DescriptionNMR-STAR name: _Subsystem_citation.Assembly_subsystem_ID
Pointer to '_Assembly_subsystem.ID'  
Database field nameAssemblySubsystemID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssembly_subsystem, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSubsystem list ID  
Examples
Help text