NMR-STAR dictionary: detail of DeducedSecdStructExptl table

NMR-STAR dictionary: database table: DeducedSecdStructExptl

Detailed description of the fields

_Deduced_secd_struct_exptl.ID (DeducedSecdStructExptlID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.ID An integer value that uniquely defines the secondary structure in the list.
Database field name	DeducedSecdStructExptlID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	yes: This tag contains the identifier for this saveframe in the entry.
Row Index	yes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	ID
Examples	?
Help text

_Deduced_secd_struct_exptl.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Entity_assembly_ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Entity_assembly_ID Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity assembly ID
Examples	?
Help text

_Deduced_secd_struct_exptl.Entity_ID (EntityID)

(go to parent tag category listing)

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

_Deduced_secd_struct_exptl.Comp_index_ID_start (CompIndexIDStart)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Comp_index_ID_start
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Comp_index_ID_start Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexIDStart
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID start
Examples	?
Help text

_Deduced_secd_struct_exptl.Comp_index_ID_end (CompIndexIDEnd)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Comp_index_ID_end
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Comp_index_ID_end Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexIDEnd
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID end
Examples	?
Help text

_Deduced_secd_struct_exptl.Seq_ID_start (SeqIDStart)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Seq_ID_start
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Seq_ID_start Pointer to '_Entity_poly_seq.Num'
Database field name	SeqIDStart
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Seq ID start
Examples	?
Help text

_Deduced_secd_struct_exptl.Seq_ID_end (SeqIDEnd)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Seq_ID_end
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Seq_ID_end Pointer to '_Entity_poly_seq.Num'
Database field name	SeqIDEnd
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Seq ID end
Examples	?
Help text

_Deduced_secd_struct_exptl.Auth_seq_ID_start (AuthSeqIDStart)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Auth_seq_ID_start
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Auth_seq_ID_start An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
Database field name	AuthSeqIDStart
SQL Database type	CHAR(12)
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	Auth seq ID start
Examples	?
Help text

_Deduced_secd_struct_exptl.Auth_seq_ID_end (AuthSeqIDEnd)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Auth_seq_ID_end
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Auth_seq_ID_end An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
Database field name	AuthSeqIDEnd
SQL Database type	CHAR(12)
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	Auth seq ID end
Examples	?
Help text

_Deduced_secd_struct_exptl.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Name
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Name Name assigned to the secondary structural element.
Database field name	Name
SQL Database type	VARCHAR(31)
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
Prompt	Name
Examples	helix A
Help text

_Deduced_secd_struct_exptl.Code (Code)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Code
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Code Code that defines the type of secondary structural element.
Database field name	Code
SQL Database type	VARCHAR(31)
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
Prompt	Code
Examples	?
Help text

_Deduced_secd_struct_exptl.Static_field_orientation_angle (StaticFieldOrientationAngle)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Static_field_orientation_angle
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Static_field_orientation_angle The angle between the axis of+BA1528 a helical structural element and the static field (Bo) for a solid state sample.
Database field name	StaticFieldOrientationAngle
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	Static field orientation angle
Examples	?
Help text

_Deduced_secd_struct_exptl.Selection_method_ID (SelectionMethodID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Selection_method_ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Selection_method_ID Pointer to '_Method.ID'
Database field name	SelectionMethodID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Method, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Selection method ID
Examples	?
Help text

_Deduced_secd_struct_exptl.Selection_method_label (SelectionMethodLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Selection_method_label
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Selection_method_label Pointer to a saveframe of the category 'method'
Database field name	SelectionMethodLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Method, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Selection method label
Examples	?
Help text

_Deduced_secd_struct_exptl.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Details
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Details Text providing additional information regarding the secondary structure element.
Database field name	Details
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	Details
Examples	?
Help text

_Deduced_secd_struct_exptl.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Sf_ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Sf_ID Pointer to '_Deduced_secd_struct_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Deduced_secd_struct_list, 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

_Deduced_secd_struct_exptl.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Entry_ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.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	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

_Deduced_secd_struct_exptl.Deduced_secd_struct_list_ID (DeducedSecdStructListID)

(go to parent tag category listing)

NMR-STAR tag name	_Deduced_secd_struct_exptl.Deduced_secd_struct_list_ID
Description	NMR-STAR name: _Deduced_secd_struct_exptl.Deduced_secd_struct_list_ID Pointer to '_Deduced_secd_struct_list.ID'
Database field name	DeducedSecdStructListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Deduced_secd_struct_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Deduced secd struct list ID
Examples	?
Help text