NMR-STAR dictionary: database table: AssemblySystematicName

Detailed description of the fields

_Assembly_systematic_name.Name (Name)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_systematic_name.Name 
DescriptionNMR-STAR name: _Assembly_systematic_name.Name
Name for the molecular assembly that has been assigned by an organization or derived using rules defined by an organization recognized by the scientific community.  
Database field nameName 
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 
PromptSystematic name  
Examples
Help text 

_Assembly_systematic_name.Naming_system (NamingSystem)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_systematic_name.Naming_system 
DescriptionNMR-STAR name: _Assembly_systematic_name.Naming_system
A recognized or common systematic method used to name molecules and molecular systems.  
Database field nameNamingSystem 
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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptNaming system  
ExamplesCAS  
Help text 

_Assembly_systematic_name.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_systematic_name.Sf_ID 
DescriptionNMR-STAR name: _Assembly_systematic_name.Sf_ID
Pointer to '_Assembly.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssembly, 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 

_Assembly_systematic_name.Entry_ID (EntryID)

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

_Assembly_systematic_name.Assembly_ID (AssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_systematic_name.Assembly_ID 
DescriptionNMR-STAR name: _Assembly_systematic_name.Assembly_ID
Pointer to '_Assembly.ID'  
Database field nameAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssembly ID  
Examples
Help text