NMR-STAR dictionary: database table: Release

Detailed description of the fields

_Release.Release_number (ReleaseNumber)

(go to parent tag category listing)
NMR-STAR tag name_Release.Release_number 
DescriptionNMR-STAR name: _Release.Release_number
Unique code assigned to each release of an entry  
Database field nameReleaseNumber 
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 
PromptRelease ID  
Examples1  
Help text 

_Release.Date (Date)

(go to parent tag category listing)
NMR-STAR tag name_Release.Date 
DescriptionNMR-STAR name: _Release.Date
Date entry was released.  
Database field nameDate 
SQL Database typeDATETIME year to day 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptRelease date  
Examples2004-02-29'  
Help text 

_Release.Submission_date (SubmissionDate)

(go to parent tag category listing)
NMR-STAR tag name_Release.Submission_date 
DescriptionNMR-STAR name: _Release.Submission_date
Date the entry or an update to the entry was submitted to BMRB.  
Database field nameSubmissionDate 
SQL Database typeDATETIME year to day 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptUpdate submission date  
Examples2004-02-29'  
Help text 

_Release.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Release.Type 
DescriptionNMR-STAR name: _Release.Type
Value describing with a key word the type of entry that was released.  
Database field nameType 
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?yes 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptRelease type  
Examplesoriginal  
Help text 

_Release.Author (Author)

(go to parent tag category listing)
NMR-STAR tag name_Release.Author 
DescriptionNMR-STAR name: _Release.Author
A keyword indicating the type of author of the release.  
Database field nameAuthor 
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?yes 
PromptAuthor of the update  
Examplesauthor  
Help text 

_Release.Detail (Detail)

(go to parent tag category listing)
NMR-STAR tag name_Release.Detail 
DescriptionNMR-STAR name: _Release.Detail
Text describing the changes made to the entry.  
Database field nameDetail 
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 
PromptDetail  
ExamplesOringinal entry release  
Help text 

_Release.Sf_ID (SfID)

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

_Release.Entry_ID (EntryID)

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