NMR-STAR dictionary: database table: Computer

Detailed description of the fields

_Computer.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Sf_category 
DescriptionNMR-STAR name: _Computer.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 

_Computer.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Sf_framecode 
DescriptionNMR-STAR name: _Computer.Sf_framecode
A label that uniquely identifies the computer from other computers 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 
PromptCompter label  
Examples
Help text 

_Computer.Entry_ID (EntryID)

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

_Computer.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Sf_ID 
DescriptionNMR-STAR name: _Computer.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 

_Computer.ID (ComputerID)

(go to parent tag category listing)
NMR-STAR tag name_Computer.ID 
DescriptionNMR-STAR name: _Computer.ID
A value that uniquely identifies the computer from other computers listed in the entry.  
Database field nameComputerID 
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 
PromptID  
Examples
Help text 

_Computer.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Details 
DescriptionNMR-STAR name: _Computer.Details
Text information describing the computer.  
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 

_Computer.Manufacturer (Manufacturer)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Manufacturer 
DescriptionNMR-STAR name: _Computer.Manufacturer
Name of the company or other entity that built the Computer.  
Database field nameManufacturer 
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 
PromptManufacturer  
ExamplesDell  
Help text 

_Computer.Model (Model)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Model 
DescriptionNMR-STAR name: _Computer.Model
The name or acronym used to describe the model of the computer.  
Database field nameModel 
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 
PromptModel  
ExamplesLatitude  
Help text 

_Computer.Operating_system (OperatingSystem)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Operating_system 
DescriptionNMR-STAR name: _Computer.Operating_system
The operating system used on the computer.  
Database field nameOperatingSystem 
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 
PromptOperating system  
ExamplesLinux  
Help text 

_Computer.Operating_system_version (OperatingSystemVersion)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Operating_system_version 
DescriptionNMR-STAR name: _Computer.Operating_system_version
Version number or code for the computer operating system used.  
Database field nameOperatingSystemVersion 
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 
PromptOperating system version  
ExamplesRedHat 7.2  
Help text 

_Computer.Hardware_code (HardwareCode)

(go to parent tag category listing)
NMR-STAR tag name_Computer.Hardware_code 
DescriptionNMR-STAR name: _Computer.Hardware_code
Code assigned to the computer by the manufacturer that uniquely identifies that computer from all others.  
Database field nameHardwareCode 
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 
PromptHardware code  
Examples
Help text