| NMR-STAR tag name | _Chem_comp_systematic_name.Name |
|---|---|
| Description | NMR-STAR name: _Chem_comp_systematic_name.Name A name for the chemical compound that has been defined by an official body or is derived from rules defined by an official organization recognized by the scientific community. |
| Database field name | Name |
| SQL Database type | VARCHAR(1024) |
| 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 | Systematic name |
| Examples | ? |
| Help text |
| NMR-STAR tag name | _Chem_comp_systematic_name.Naming_system |
|---|---|
| Description | NMR-STAR name: _Chem_comp_systematic_name.Naming_system An official method of nomenclature or defined set of nomenclature for chemical compounds recognized by the scientific community. |
| Database field name | NamingSystem |
| 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 | Naming system |
| Examples | IUPAC |
| Help text |
| NMR-STAR tag name | _Chem_comp_systematic_name.Sf_ID |
|---|---|
| Description | NMR-STAR name: _Chem_comp_systematic_name.Sf_ID Pointer to '_Chem_comp.Sf_ID' |
| Database field name | SfID |
| SQL Database type | INTEGER |
| Part of primary Key | no |
| Foreign Key on table, column | Chem_comp, 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 |
| NMR-STAR tag name | _Chem_comp_systematic_name.Entry_ID |
|---|---|
| Description | NMR-STAR name: _Chem_comp_systematic_name.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 | Chem_comp, 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 |
| NMR-STAR tag name | _Chem_comp_systematic_name.Comp_ID |
|---|---|
| Description | NMR-STAR name: _Chem_comp_systematic_name.Comp_ID Pointer to '_Chem_comp.ID' |
| Database field name | CompID |
| SQL Database type | CHAR(12) |
| Part of primary Key | yes |
| Foreign Key on table, column | Chem_comp, ID |
| Saveframe ID | no |
| Row Index | no |
| Secondary Index | no |
| Internal Flag | no |
| Nulls allowed in database? | yes |
| Prompt | Comp ID |
| Examples | ? |
| Help text |