NMR-STAR dictionary: database table: ConstraintFile

Detailed description of the fields

_Constraint_file.ID (ConstraintFileID)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.ID 
DescriptionNMR-STAR name: _Constraint_file.ID
?  
Database field nameConstraintFileID 
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 
PromptID  
Examples
Help text 

_Constraint_file.Constraint_filename (ConstraintFilename)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_filename 
DescriptionNMR-STAR name: _Constraint_file.Constraint_filename
Name of the uploaded file that contains the constraint data.  
Database field nameConstraintFilename 
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 
PromptName of the file with the following constraints  
Examplessns_restraints.txt  
Help text 

_Constraint_file.Software_ID (SoftwareID)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Software_ID 
DescriptionNMR-STAR name: _Constraint_file.Software_ID
Pointer to '_Software.ID'  
Database field nameSoftwareID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnSoftware, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSoftware ID  
Examples
Help text 

_Constraint_file.Software_label (SoftwareLabel)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Software_label 
DescriptionNMR-STAR name: _Constraint_file.Software_label
Please enter the name of the software application for which the constraint data file has been formatted. If the software application has been entered above in the 'Software description' section, its name will appear in a pull down list. This information will allow a constraint report to be generated and statistics to be calculated automatically.  
Database field nameSoftwareLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnSoftware, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSoftware file format  
ExamplesX-PLOR NIH  
Help text 

_Constraint_file.Software_name (SoftwareName)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Software_name 
DescriptionNMR-STAR name: _Constraint_file.Software_name
?  
Database field nameSoftwareName 
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 
PromptSoftware name  
Examples
Help text 

_Constraint_file.Block_ID (BlockID)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Block_ID 
DescriptionNMR-STAR name: _Constraint_file.Block_ID
An integer value assigned to a group (block) of restraints extracted from a file containing the restraints used to carry out a structure calculation.  
Database field nameBlockID 
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 
PromptBlock indentification number  
Examples5  
Help text 

_Constraint_file.Constraint_type (ConstraintType)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_type 
DescriptionNMR-STAR name: _Constraint_file.Constraint_type
The general type of constraint (distance, torsion angle, RDC, etc.)  
Database field nameConstraintType 
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. 
PromptGeneral type of constraint  
Examplesdistance  
Help text 

_Constraint_file.Constraint_subtype (ConstraintSubtype)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_subtype 
DescriptionNMR-STAR name: _Constraint_file.Constraint_subtype
Specific type of constraint.  
Database field nameConstraintSubtype 
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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptSpecific type of constraint  
ExamplesNOE  
Help text 

_Constraint_file.Constraint_subsubtype (ConstraintSubsubtype)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_subsubtype 
DescriptionNMR-STAR name: _Constraint_file.Constraint_subsubtype
Another level of description of the type of constraints in the file (simple, ambiguous, etc.)  
Database field nameConstraintSubsubtype 
SQL Database typeVARCHAR(31) 
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. 
PromptAmbiguous constraints of this kind present  
Examplesyes  
Help text 

_Constraint_file.Constraint_number (ConstraintNumber)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_number 
DescriptionNMR-STAR name: _Constraint_file.Constraint_number
Number of constraints of this type and subtype in the file.  
Database field nameConstraintNumber 
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 
PromptNumber of constraints of this kind in the file  
Examples2045  
Help text 

_Constraint_file.Sf_ID (SfID)

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

_Constraint_file.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Entry_ID 
DescriptionNMR-STAR name: _Constraint_file.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 

_Constraint_file.Constraint_stat_list_ID (ConstraintStatListID)

(go to parent tag category listing)
NMR-STAR tag name_Constraint_file.Constraint_stat_list_ID 
DescriptionNMR-STAR name: _Constraint_file.Constraint_stat_list_ID
Pointer to '_Constraint_stat_list.ID'  
Database field nameConstraintStatListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnConstraint_stat_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptConstraint stat list ID  
Examples
Help text