NMR-STAR dictionary: detail of OtherConstraintList table

NMR-STAR dictionary: database table: OtherConstraintList

Detailed description of the fields

_Other_constraint_list.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Sf_category
Description	NMR-STAR name: _Other_constraint_list.Sf_category Category definition for the information content of the saveframe
Database field name	SfCategory
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	Sf category
Examples	?
Help text

_Other_constraint_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Sf_framecode
Description	NMR-STAR name: _Other_constraint_list.Sf_framecode A label for the saveframe that describes in very brief terms the information contained in the saveframe.
Database field name	SfFramecode
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?	yes
Prompt	Label for list of other deposited constraints
Examples	?
Help text

_Other_constraint_list.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Other_constraint_list.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Sf_ID
Description	NMR-STAR name: _Other_constraint_list.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 name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	,
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

_Other_constraint_list.ID (OtherConstraintListID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.ID
Description	NMR-STAR name: _Other_constraint_list.ID Unique identifier for the list of constraints classified as 'other.'
Database field name	OtherConstraintListID
SQL Database type	INTEGER
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	ID
Examples	?
Help text

_Other_constraint_list.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Details
Description	NMR-STAR name: _Other_constraint_list.Details Text description providing additional information about the reported constraints.
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

_Other_constraint_list.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Entity_assembly_ID
Description	NMR-STAR name: _Other_constraint_list.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

_Other_constraint_list.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Entity_ID
Description	NMR-STAR name: _Other_constraint_list.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

_Other_constraint_list.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Type
Description	NMR-STAR name: _Other_constraint_list.Type The type of reported constraint.
Database field name	Type
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?	yes
Prompt	Type
Examples	?
Help text

_Other_constraint_list.Subtype (Subtype)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Subtype
Description	NMR-STAR name: _Other_constraint_list.Subtype A subclassification for the type of reported constraint.
Database field name	Subtype
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?	yes
Prompt	Subtype
Examples	?
Help text

_Other_constraint_list.File_name (FileName)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.File_name
Description	NMR-STAR name: _Other_constraint_list.File_name Name of the file that contains the 'other' constraints.
Database field name	FileName
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	File name
Examples	?
Help text

_Other_constraint_list.File_format (FileFormat)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.File_format
Description	NMR-STAR name: _Other_constraint_list.File_format The format in which the constraint data are provided.
Database field name	FileFormat
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?	yes
Prompt	File format
Examples	?
Help text

_Other_constraint_list.Constraint_file_ID (ConstraintFileID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Constraint_file_ID
Description	NMR-STAR name: _Other_constraint_list.Constraint_file_ID Pointer to '_Constraint_file.ID'
Database field name	ConstraintFileID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Constraint_file, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Constraint file ID
Examples	?
Help text

_Other_constraint_list.Block_ID (BlockID)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Block_ID
Description	NMR-STAR name: _Other_constraint_list.Block_ID Pointer to '_Constraint_file.Block_ID'
Database field name	BlockID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Constraint_file, Block_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Block ID
Examples	?
Help text

_Other_constraint_list.Text_data_format (TextDataFormat)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Text_data_format
Description	NMR-STAR name: _Other_constraint_list.Text_data_format ?
Database field name	TextDataFormat
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	Text data format
Examples	?
Help text

_Other_constraint_list.Text_data (TextData)

(go to parent tag category listing)

NMR-STAR tag name	_Other_constraint_list.Text_data
Description	NMR-STAR name: _Other_constraint_list.Text_data The constraint data in a text format. This will be a large block of text.
Database field name	TextData
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?	yes
Prompt	List
Examples	?
Help text