NMR-STAR dictionary: database table: Vendor

Detailed description of the fields

_Vendor.Name (Name)

(go to parent tag category listing)
NMR-STAR tag name_Vendor.Name 
DescriptionNMR-STAR name: _Vendor.Name
Enter the name of the author of the software or the commercial supplier or vendor of the software product.  
Database field nameName 
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. 
PromptAuthor (vendor)  
ExamplesNIH  
Help text 

_Vendor.Address (Address)

(go to parent tag category listing)
NMR-STAR tag name_Vendor.Address 
DescriptionNMR-STAR name: _Vendor.Address
Address or location for the person or company who supplies the software.  
Database field nameAddress 
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 
PromptAddress  
Examples
Help text 

_Vendor.Electronic_address (ElectronicAddress)

(go to parent tag category listing)
NMR-STAR tag name_Vendor.Electronic_address 
DescriptionNMR-STAR name: _Vendor.Electronic_address
An internet address for the vendor or author of the software.  
Database field nameElectronicAddress 
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 
PromptElectronic address  
Examples
Help text 

_Vendor.Sf_ID (SfID)

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

_Vendor.Entry_ID (EntryID)

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

_Vendor.Software_ID (SoftwareID)

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