NMR-STAR dictionary: database table: ExperimentFile

Detailed description of the fields

_Experiment_file.Experiment_ID (ExperimentID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Experiment_ID 
DescriptionNMR-STAR name: _Experiment_file.Experiment_ID
Pointer to '_Experiment.ID'  
Database field nameExperimentID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnExperiment, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptExperiment ID  
Examples
Help text 

_Experiment_file.Name (Name)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Name 
DescriptionNMR-STAR name: _Experiment_file.Name
?  
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?no 
PromptName  
Examples
Help text 

_Experiment_file.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Type 
DescriptionNMR-STAR name: _Experiment_file.Type
?  
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  
Examples
Help text 

_Experiment_file.Directory_path (DirectoryPath)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Directory_path 
DescriptionNMR-STAR name: _Experiment_file.Directory_path
?  
Database field nameDirectoryPath 
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 
PromptDirectory path  
Examples
Help text 

_Experiment_file.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Details 
DescriptionNMR-STAR name: _Experiment_file.Details
?  
Database field nameDetails 
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 
PromptDetails  
Examples
Help text 

_Experiment_file.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Sf_ID 
DescriptionNMR-STAR name: _Experiment_file.Sf_ID
Pointer to '_Experiment_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnExperiment_list, Sf_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Experiment_file.Entry_ID (EntryID)

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

_Experiment_file.Experiment_list_ID (ExperimentListID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_file.Experiment_list_ID 
DescriptionNMR-STAR name: _Experiment_file.Experiment_list_ID
Pointer to '_Experiment_list.ID'  
Database field nameExperimentListID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnExperiment_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptExperiment list ID  
Examples
Help text