NMR-STAR dictionary: database table: SubsystemDbLink

Detailed description of the fields

_Subsystem_db_link.Author_supplied (AuthorSupplied)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Author_supplied 
DescriptionNMR-STAR name: _Subsystem_db_link.Author_supplied
Boolean code that defines if the link to a database was provided by the author (yes) or from another source (no).  
Database field nameAuthorSupplied 
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 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
PromptAuthor supplied  
Examples
Help text 

_Subsystem_db_link.Database_code (DatabaseCode)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Database_code 
DescriptionNMR-STAR name: _Subsystem_db_link.Database_code
Abbreviation for the database  
Database field nameDatabaseCode 
SQL Database typeVARCHAR(127) 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptDatabase code  
Examples
Help text 

_Subsystem_db_link.Accession_code (AccessionCode)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Accession_code 
DescriptionNMR-STAR name: _Subsystem_db_link.Accession_code
Accession code for the entry in the database.  
Database field nameAccessionCode 
SQL Database typeVARCHAR(31) 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAccession code  
Examples
Help text 

_Subsystem_db_link.Entry_mol_code (EntryMolCode)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_mol_code 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_mol_code
Code assigned by the database to the molecule in the database entry.  
Database field nameEntryMolCode 
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 
PromptEntry mol code  
Examples
Help text 

_Subsystem_db_link.Entry_mol_name (EntryMolName)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_mol_name 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_mol_name
Name of the molecular assembly in the database entry.  
Database field nameEntryMolName 
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 
PromptEntry mol name  
Examples
Help text 

_Subsystem_db_link.Entry_experimental_method (EntryExperimentalMethod)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_experimental_method 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_experimental_method
Experimental method used to generate the data in the database entry.  
Database field nameEntryExperimentalMethod 
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 
PromptEntry experimental method  
Examples
Help text 

_Subsystem_db_link.Entry_relation_type (EntryRelationType)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_relation_type 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_relation_type
Relationship between the database entry and this BMRB entry.  
Database field nameEntryRelationType 
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 
PromptEntry relation type  
Examples
Help text 

_Subsystem_db_link.Entry_details (EntryDetails)

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_details 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_details
Any text information relevant to the database entry.  
Database field nameEntryDetails 
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 
PromptEntry details  
Examples
Help text 

_Subsystem_db_link.Sf_ID (SfID)

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

(go to parent tag category listing)
NMR-STAR tag name_Subsystem_db_link.Entry_ID 
DescriptionNMR-STAR name: _Subsystem_db_link.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
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_db_link.Assembly_subsystem_ID (AssemblySubsystemID)

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