NMR-STAR dictionary: detail of AssemblyDbLink table

NMR-STAR dictionary: database table: AssemblyDbLink

Detailed description of the fields

_Assembly_db_link.Author_supplied (AuthorSupplied)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Author_supplied
Description	NMR-STAR name: _Assembly_db_link.Author_supplied A code that indicates whether the database link is provided by the author (yes) or has been obtained through other methods (no).
Database field name	AuthorSupplied
SQL Database type	VARCHAR(3)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Author supplied
Examples	yes
Help text

_Assembly_db_link.Database_code (DatabaseCode)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Database_code
Description	NMR-STAR name: _Assembly_db_link.Database_code Abbreviation for the database
Database field name	DatabaseCode
SQL Database type	VARCHAR(127)
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
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.
Prompt	Common database abbreviation
Examples	PDB
Help text

_Assembly_db_link.Accession_code (AccessionCode)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Accession_code
Description	NMR-STAR name: _Assembly_db_link.Accession_code Accession code for the entry in the database.
Database field name	AccessionCode
SQL Database type	VARCHAR(31)
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Database accession code
Examples	1brv
Help text

_Assembly_db_link.Entry_mol_code (EntryMolCode)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_mol_code
Description	NMR-STAR name: _Assembly_db_link.Entry_mol_code A code assigned to the molecule in the entry by the database. Entries in databases may contain information on more than one molecule and each molecule in the entry may be assigned a unique code. Providing this code will indicate the exact molecule in the database entry that is related to the molecular assembly defined in the BMRB entry.
Database field name	EntryMolCode
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry mol code
Examples	?
Help text

_Assembly_db_link.Entry_mol_name (EntryMolName)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_mol_name
Description	NMR-STAR name: _Assembly_db_link.Entry_mol_name Name of the molecular assembly in the database entry.
Database field name	EntryMolName
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry mol name
Examples	?
Help text

_Assembly_db_link.Entry_experimental_method (EntryExperimentalMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_experimental_method
Description	NMR-STAR name: _Assembly_db_link.Entry_experimental_method Experimental method used to generate the data in the database entry.
Database field name	EntryExperimentalMethod
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
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.
Prompt	Experimental method used to collect data
Examples	X-ray
Help text

_Assembly_db_link.Entry_structure_resolution (EntryStructureResolution)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_structure_resolution
Description	NMR-STAR name: _Assembly_db_link.Entry_structure_resolution The resolution of the data in a structure entry.
Database field name	EntryStructureResolution
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Structure resolution
Examples	1.3A
Help text

_Assembly_db_link.Entry_relation_type (EntryRelationType)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_relation_type
Description	NMR-STAR name: _Assembly_db_link.Entry_relation_type Relationship between the database entry and this BMRB entry.
Database field name	EntryRelationType
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Relationship to current entry
Examples	Structure for the free repressor that is bound to DNA in this study.
Help text

_Assembly_db_link.Entry_details (EntryDetails)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_details
Description	NMR-STAR name: _Assembly_db_link.Entry_details Any text information relevant to the database entry.
Database field name	EntryDetails
SQL Database type	TEXT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Comments regarding the entry
Examples	?
Help text

_Assembly_db_link.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Sf_ID
Description	NMR-STAR name: _Assembly_db_link.Sf_ID Pointer to '_Assembly.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Assembly, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Assembly_db_link.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Entry_ID
Description	NMR-STAR name: _Assembly_db_link.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Assembly, Entry_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text

_Assembly_db_link.Assembly_ID (AssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_db_link.Assembly_ID
Description	NMR-STAR name: _Assembly_db_link.Assembly_ID Pointer to '_Assembly.ID'
Database field name	AssemblyID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Assembly ID
Examples	?
Help text