NMR-STAR dictionary: database table: T1

Detailed description of the fields

_T1.ID (T1ID)

(go to parent tag category listing)
NMR-STAR tag name_T1.ID 
DescriptionNMR-STAR name: _T1.ID
Unique identifier for the observed T1 relaxation value.  
Database field nameT1ID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID yes: This tag contains the identifier for this saveframe in the entry. 
Row Indexyes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptID  
Examples
Help text 

_T1.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Assembly_atom_ID 
DescriptionNMR-STAR name: _T1.Assembly_atom_ID
Pointer to '_Atom.Assembly_atom_ID'  
Database field nameAssemblyAtomID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAtom, Assembly_atom_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAssembly atom ID  
Examples
Help text 

_T1.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Entity_assembly_ID 
DescriptionNMR-STAR name: _T1.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?yes 
PromptEntity assembly ID  
Examples
Help text 

_T1.Entity_ID (EntityID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Entity_ID 
DescriptionNMR-STAR name: _T1.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?yes 
PromptEntity ID  
Examples
Help text 

_T1.Comp_index_ID (CompIndexID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Comp_index_ID 
DescriptionNMR-STAR name: _T1.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?yes 
PromptComp index ID  
Examples
Help text 

_T1.Seq_ID (SeqID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Seq_ID 
DescriptionNMR-STAR name: _T1.Seq_ID
Pointer to '_PDBX_poly_seq_scheme.Seq_ID'  
Database field nameSeqID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_poly_seq, Num 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSeq ID  
Examples
Help text 

_T1.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Comp_ID 
DescriptionNMR-STAR name: _T1.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?yes 
PromptComp ID  
Examples
Help text 

_T1.Atom_ID (AtomID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Atom_ID 
DescriptionNMR-STAR name: _T1.Atom_ID
Pointer to '_Chem_comp_atom.Atom_ID'  
Database field nameAtomID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnChem_comp_atom, Atom_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAtom ID  
Examples
Help text 

_T1.Atom_type (AtomType)

(go to parent tag category listing)
NMR-STAR tag name_T1.Atom_type 
DescriptionNMR-STAR name: _T1.Atom_type
The value for this tag is a standard IUPAC abbreviation for an element (i.e., H, C, P, etc).  
Database field nameAtomType 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAtom type  
Examples
Help text 

_T1.Atom_isotope_number (AtomIsotopeNumber)

(go to parent tag category listing)
NMR-STAR tag name_T1.Atom_isotope_number 
DescriptionNMR-STAR name: _T1.Atom_isotope_number
?  
Database field nameAtomIsotopeNumber 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAtom isotope number  
Examples
Help text 

_T1.Val (Val)

(go to parent tag category listing)
NMR-STAR tag name_T1.Val 
DescriptionNMR-STAR name: _T1.Val
The T1 relaxation value.  
Database field nameVal 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptVal  
Examples
Help text 

_T1.Val_err (ValErr)

(go to parent tag category listing)
NMR-STAR tag name_T1.Val_err 
DescriptionNMR-STAR name: _T1.Val_err
The estimated error in the reported T1 relaxation value.  
Database field nameValErr 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptVal err  
Examples
Help text 

_T1.Resonance_ID (ResonanceID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Resonance_ID 
DescriptionNMR-STAR name: _T1.Resonance_ID
Pointer to '_Resonance.ID'  
Database field nameResonanceID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnResonance, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptResonance ID  
Examples
Help text 

_T1.Auth_entity_assembly_ID (AuthEntityAssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Auth_entity_assembly_ID 
DescriptionNMR-STAR name: _T1.Auth_entity_assembly_ID
?  
Database field nameAuthEntityAssemblyID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAuth entity assembly ID  
Examples
Help text 

_T1.Auth_seq_ID (AuthSeqID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Auth_seq_ID 
DescriptionNMR-STAR name: _T1.Auth_seq_ID
An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.  
Database field nameAuthSeqID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAuth seq ID  
Examples-3  
Help text 

_T1.Auth_comp_ID (AuthCompID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Auth_comp_ID 
DescriptionNMR-STAR name: _T1.Auth_comp_ID
An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.  
Database field nameAuthCompID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAuth comp ID  
ExamplesDPN  
Help text 

_T1.Auth_atom_ID (AuthAtomID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Auth_atom_ID 
DescriptionNMR-STAR name: _T1.Auth_atom_ID
An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.  
Database field nameAuthAtomID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAuth atom ID  
ExamplesHB1  
Help text 

_T1.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Sf_ID 
DescriptionNMR-STAR name: _T1.Sf_ID
Pointer to '_Heteronucl_T1_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnHeteronucl_T1_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?yes 
PromptSf ID  
Examples
Help text 

_T1.Entry_ID (EntryID)

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

_T1.Heteronucl_T1_list_ID (HeteronuclT1ListID)

(go to parent tag category listing)
NMR-STAR tag name_T1.Heteronucl_T1_list_ID 
DescriptionNMR-STAR name: _T1.Heteronucl_T1_list_ID
Pointer to '_Heteronucl_T1_list.ID'  
Database field nameHeteronuclT1ListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnHeteronucl_T1_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptHeteronucl T1 list ID  
Examples
Help text