NMR-STAR dictionary: database table: ChromatographicColumn

Detailed description of the fields

_Chromatographic_column.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Sf_category 
DescriptionNMR-STAR name: _Chromatographic_column.Sf_category
Category assigned to the information in the saveframe.  
Database field nameSfCategory 
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 
PromptSf category  
Examples
Help text 

_Chromatographic_column.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Sf_framecode 
DescriptionNMR-STAR name: _Chromatographic_column.Sf_framecode
A label that uniquely identifies the Mass spectrometer from other spectrometers listed in the entry.  
Database field nameSfFramecode 
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 
PromptMass spectrometer label  
Examples
Help text 

_Chromatographic_column.Entry_ID (EntryID)

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

_Chromatographic_column.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Sf_ID 
DescriptionNMR-STAR name: _Chromatographic_column.Sf_ID
An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system.  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
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 

_Chromatographic_column.ID (ChromatographicColumnID)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.ID 
DescriptionNMR-STAR name: _Chromatographic_column.ID
A value that uniquely identifies the Mass spectrometer from other spectrometers listed in the entry.  
Database field nameChromatographicColumnID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptMass spectrometer ID  
Examples
Help text 

_Chromatographic_column.Vendor (Vendor)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Vendor 
DescriptionNMR-STAR name: _Chromatographic_column.Vendor
?  
Database field nameVendor 
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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptVendor  
Examples
Help text 

_Chromatographic_column.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Type 
DescriptionNMR-STAR name: _Chromatographic_column.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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptType  
Examples
Help text 

_Chromatographic_column.Packing_material (PackingMaterial)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Packing_material 
DescriptionNMR-STAR name: _Chromatographic_column.Packing_material
?  
Database field namePackingMaterial 
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 
PromptPacking material  
Examples
Help text 

_Chromatographic_column.Packing_material_pore_size (PackingMaterialPoreSize)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Packing_material_pore_size 
DescriptionNMR-STAR name: _Chromatographic_column.Packing_material_pore_size
?  
Database field namePackingMaterialPoreSize 
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 
PromptPacking material pore size  
Examples
Help text 

_Chromatographic_column.Width (Width)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Width 
DescriptionNMR-STAR name: _Chromatographic_column.Width
?  
Database field nameWidth 
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 
PromptWidth  
Examples
Help text 

_Chromatographic_column.Length (Length)

(go to parent tag category listing)
NMR-STAR tag name_Chromatographic_column.Length 
DescriptionNMR-STAR name: _Chromatographic_column.Length
?  
Database field nameLength 
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 
PromptLength  
Examples
Help text