NMR-STAR dictionary: database table: EntityCommonName

Detailed description of the fields

_Entity_common_name.Name (Name)

(go to parent tag category listing)
NMR-STAR tag name_Entity_common_name.Name 
DescriptionNMR-STAR name: _Entity_common_name.Name
A name commonly used in the literature to refer to this biopolymer. This may be a full name or an abbreviation.  
Database field nameName 
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 
PromptEntity name  
ExamplesRnase  
Help text 

_Entity_common_name.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Entity_common_name.Type 
DescriptionNMR-STAR name: _Entity_common_name.Type
A code defining the type of the common name provided.  
Database field nameType 
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 
PromptType of name  
Examplesabbreviation  
Help text 

_Entity_common_name.Sf_ID (SfID)

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

_Entity_common_name.Entry_ID (EntryID)

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

_Entity_common_name.Entity_ID (EntityID)

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