| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Ambiguous_atom_chem_shift.Ambiguous_shift_set_ID | AmbiguousShiftSetID | INTEGER | no | no | yes | |
| _Ambiguous_atom_chem_shift.Atom_chem_shift_ID | AtomChemShiftID | INTEGER | no | no | no | |
|
[saveframe id tag] _Ambiguous_atom_chem_shift.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Ambiguous_atom_chem_shift.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Ambiguous_atom_chem_shift.Assigned_chem_shift_list_ID | AssignedChemShiftListID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Angle.ID |
AngleID | INTEGER | no | no | yes | |
| _Angle.Angle_name | AngleName | VARCHAR(127) | no | no | no | |
| _Angle.Assembly_atom_ID_1 | AssemblyAtomID1 | INTEGER | no | no | no | |
| _Angle.Entity_assembly_ID_1 | EntityAssemblyID1 | INTEGER | no | no | no | |
| _Angle.Entity_ID_1 | EntityID1 | INTEGER | no | no | no | |
| _Angle.Entity_label_1 | EntityLabel1 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_ID_1 | CompID1 | CHAR(12) | no | no | no | |
| _Angle.Comp_label_1 | CompLabel1 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_index_ID_1 | CompIndexID1 | INTEGER | no | no | no | |
| _Angle.Seq_ID_1 | SeqID1 | INTEGER | no | no | no | |
| _Angle.Atom_ID_1 | AtomID1 | CHAR(12) | no | no | no | |
| _Angle.Atom_type_1 | AtomType1 | VARCHAR(15) | no | no | no | |
| _Angle.Assembly_atom_ID_2 | AssemblyAtomID2 | INTEGER | no | no | no | |
| _Angle.Entity_assembly_ID_2 | EntityAssemblyID2 | INTEGER | no | no | no | |
| _Angle.Entity_ID_2 | EntityID2 | INTEGER | no | no | no | |
| _Angle.Entity_label_2 | EntityLabel2 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_ID_2 | CompID2 | CHAR(12) | no | no | no | |
| _Angle.Comp_label_2 | CompLabel2 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_index_ID_2 | CompIndexID2 | INTEGER | no | no | no | |
| _Angle.Seq_ID_2 | SeqID2 | INTEGER | no | no | no | |
| _Angle.Atom_ID_2 | AtomID2 | CHAR(12) | no | no | no | |
| _Angle.Atom_type_2 | AtomType2 | VARCHAR(15) | no | no | no | |
| _Angle.Assembly_atom_ID_3 | AssemblyAtomID3 | INTEGER | no | no | no | |
| _Angle.Entity_assembly_ID_3 | EntityAssemblyID3 | INTEGER | no | no | no | |
| _Angle.Entity_ID_3 | EntityID3 | INTEGER | no | no | no | |
| _Angle.Entity_label_3 | EntityLabel3 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_ID_3 | CompID3 | CHAR(12) | no | no | no | |
| _Angle.Comp_label_3 | CompLabel3 | VARCHAR(127) | no | no | no | |
| _Angle.Comp_index_ID_3 | CompIndexID3 | INTEGER | no | no | no | |
| _Angle.Seq_ID_3 | SeqID3 | INTEGER | no | no | no | |
| _Angle.Atom_ID_3 | AtomID3 | CHAR(12) | no | no | no | |
| _Angle.Atom_type_3 | AtomType3 | VARCHAR(15) | no | no | no | |
|
[saveframe id tag] _Angle.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Angle.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Angle.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Angular_order_param.ID |
AngularOrderParamID | INTEGER | no | no | yes | |
| _Angular_order_param.Assembly_atom_ID | AssemblyAtomID | INTEGER | no | no | no | |
| _Angular_order_param.Entity_assembly_ID | EntityAssemblyID | INTEGER | no | no | no | |
| _Angular_order_param.Entity_ID | EntityID | INTEGER | no | no | no | |
| _Angular_order_param.Comp_index_ID | CompIndexID | INTEGER | no | no | no | |
| _Angular_order_param.Seq_ID | SeqID | INTEGER | no | no | no | |
| _Angular_order_param.Comp_ID | CompID | CHAR(12) | no | no | no | |
| _Angular_order_param.Phi_S_angle_val | PhiSAngleVal | FLOAT | no | no | no | |
| _Angular_order_param.Psi_S_angle_val | PsiSAngleVal | FLOAT | no | no | no | |
| _Angular_order_param.Chi_1_S_angle_val | Chi1SAngleVal | FLOAT | no | no | no | |
| _Angular_order_param.Chi_2_S_angle_val | Chi2SAngleVal | FLOAT | no | no | no | |
| _Angular_order_param.Auth_entity_assembly_ID | AuthEntityAssemblyID | INTEGER | no | no | no | |
| _Angular_order_param.Auth_seq_ID | AuthSeqID | VARCHAR(15) | no | no | no | |
| _Angular_order_param.Auth_comp_ID | AuthCompID | VARCHAR(15) | no | no | no | |
| _Angular_order_param.Auth_atom_ID | AuthAtomID | VARCHAR(15) | no | no | no | |
|
[saveframe id tag] _Angular_order_param.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Angular_order_param.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Angular_order_param.Angular_order_parameter_list_ID | AngularOrderParameterListID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Angular_order_parameter_list.Sf_category | SfCategory | VARCHAR(31) | no | no | no | |
| _Angular_order_parameter_list.Sf_framecode | SfFramecode | VARCHAR(127) | no | no | no | |
| _Angular_order_parameter_list.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
|
[saveframe id tag] _Angular_order_parameter_list.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Angular_order_parameter_list.ID | AngularOrderParameterListID | INTEGER | no | no | yes | |
| _Angular_order_parameter_list.Data_file_name | DataFileName | VARCHAR(127) | no | no | no | |
| _Angular_order_parameter_list.Text_data_format | TextDataFormat | VARCHAR(31) | no | no | no | |
| _Angular_order_parameter_list.Text_data | TextData | TEXT | no | no | no |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly.Sf_category | SfCategory | VARCHAR(127) | no | no | no | |
| _Assembly.Sf_framecode | SfFramecode | VARCHAR(127) | no | no | no | |
| _Assembly.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
|
[saveframe id tag] _Assembly.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly.ID | AssemblyID | INTEGER | no | no | yes | |
| _Assembly.Name | Name | VARCHAR(127) | no | no | no | |
| _Assembly.BMRB_code | BMRBCode | CHAR(12) | no | no | no | |
| _Assembly.Number_of_components | NumberOfComponents | INTEGER | no | no | no | |
| _Assembly.Organic_ligands | OrganicLigands | INTEGER | no | no | no | |
| _Assembly.Metal_ions | MetalIons | INTEGER | no | no | no | |
| _Assembly.Non_standard_bonds | NonStandardBonds | VARCHAR(3) | no | no | no | |
| _Assembly.Ambiguous_conformational_states | AmbiguousConformationalStates | VARCHAR(3) | no | no | no | |
| _Assembly.Ambiguous_chem_comp_sites | AmbiguousChemCompSites | VARCHAR(3) | no | no | no | |
| _Assembly.Molecules_in_chemical_exchange | MoleculesInChemicalExchange | VARCHAR(3) | no | no | no | |
| _Assembly.Paramagnetic | Paramagnetic | VARCHAR(3) | no | no | no | |
| _Assembly.Thiol_state | ThiolState | VARCHAR(127) | no | no | no | |
| _Assembly.Molecular_mass | MolecularMass | FLOAT | no | no | no | |
| _Assembly.Enzyme_commission_number | EnzymeCommissionNumber | VARCHAR(127) | no | no | no | |
| _Assembly.Details | Details | TEXT | no | no | no | |
| _Assembly.DB_query_date | DBQueryDate | DATETIME year to day | no | no | no | |
| _Assembly.DB_query_revised_last_date | DBQueryRevisedLastDate | DATETIME year to day | no | no | no |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_annotation_list.Sf_category | SfCategory | VARCHAR(127) | no | no | no | |
| _Assembly_annotation_list.Sf_framecode | SfFramecode | VARCHAR(127) | no | no | no | |
| _Assembly_annotation_list.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
|
[saveframe id tag] _Assembly_annotation_list.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_annotation_list.ID | AssemblyAnnotationListID | INTEGER | no | no | yes | |
| _Assembly_annotation_list.Source | Source | VARCHAR(127) | no | no | no | |
| _Assembly_annotation_list.Details | Details | TEXT | no | no | no |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_bio_function.Biological_function | BiologicalFunction | VARCHAR(127) | no | no | yes | |
|
[saveframe id tag] _Assembly_bio_function.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_bio_function.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_bio_function.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_citation.Citation_ID | CitationID | INTEGER | no | no | yes | |
| _Assembly_citation.Citation_label | CitationLabel | VARCHAR(127) | no | no | no | |
|
[saveframe id tag] _Assembly_citation.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_citation.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_citation.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_common_name.Name | Name | VARCHAR(127) | no | no | yes | |
| _Assembly_common_name.Type | Type | VARCHAR(127) | no | no | no | |
|
[saveframe id tag] _Assembly_common_name.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_common_name.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_common_name.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_db_link.Author_supplied | AuthorSupplied | VARCHAR(3) | no | no | no | |
| _Assembly_db_link.Database_code | DatabaseCode | VARCHAR(127) | no | no | yes | |
| _Assembly_db_link.Accession_code | AccessionCode | VARCHAR(15) | no | no | yes | |
| _Assembly_db_link.Entry_mol_code | EntryMolCode | VARCHAR(127) | no | no | no | |
| _Assembly_db_link.Entry_mol_name | EntryMolName | VARCHAR(127) | no | no | no | |
| _Assembly_db_link.Entry_experimental_method | EntryExperimentalMethod | VARCHAR(127) | no | no | no | |
| _Assembly_db_link.Entry_structure_resolution | EntryStructureResolution | FLOAT | no | no | no | |
| _Assembly_db_link.Entry_relation_type | EntryRelationType | VARCHAR(127) | no | no | no | |
| _Assembly_db_link.Entry_details | EntryDetails | TEXT | no | no | no | |
|
[saveframe id tag] _Assembly_db_link.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_db_link.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_db_link.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Assembly_interaction.ID |
AssemblyInteractionID | INTEGER | no | no | yes | |
| _Assembly_interaction.Entity_assembly_ID_1 | EntityAssemblyID1 | INTEGER | no | no | no | |
| _Assembly_interaction.Entity_assembly_ID_2 | EntityAssemblyID2 | INTEGER | no | no | no | |
| _Assembly_interaction.Mol_interaction_type | MolInteractionType | VARCHAR(127) | no | no | no | |
|
[saveframe id tag] _Assembly_interaction.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_interaction.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_interaction.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_keyword.Keyword | Keyword | VARCHAR(127) | no | no | yes | |
|
[saveframe id tag] _Assembly_keyword.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_keyword.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_keyword.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Assembly_segment.ID |
AssemblySegmentID | INTEGER | no | no | yes | |
| _Assembly_segment.Entity_assembly_ID | EntityAssemblyID | INTEGER | no | no | no | |
| _Assembly_segment.Entity_ID | EntityID | INTEGER | no | no | no | |
| _Assembly_segment.Entity_label | EntityLabel | VARCHAR(127) | no | no | no | |
| _Assembly_segment.Comp_index_ID | CompIndexID | INTEGER | no | no | no | |
| _Assembly_segment.Comp_ID | CompID | CHAR(12) | no | no | no | |
| _Assembly_segment.Comp_label | CompLabel | VARCHAR(127) | no | no | no | |
| _Assembly_segment.Seq_ID | SeqID | INTEGER | no | no | no | |
| _Assembly_segment.Atom_ID | AtomID | CHAR(12) | no | no | no | |
| _Assembly_segment.Assembly_atom_ID | AssemblyAtomID | INTEGER | no | no | no | |
|
[saveframe id tag] _Assembly_segment.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_segment.Entry_ID | EntryID | CHAR(12) | no | no | no | |
| _Assembly_segment.Assembly_ID | AssemblyID | INTEGER | no | no | no |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Assembly_segment_description.Assembly_segment_ID |
AssemblySegmentID | INTEGER | no | no | no | |
| _Assembly_segment_description.Code | Code | VARCHAR(15) | no | no | no | |
| _Assembly_segment_description.Details | Details | TEXT | no | no | no | |
|
[saveframe id tag] _Assembly_segment_description.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_segment_description.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_segment_description.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_subsystem.Sf_category | SfCategory | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.Sf_framecode | SfFramecode | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
|
[saveframe id tag] _Assembly_subsystem.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_subsystem.ID | AssemblySubsystemID | INTEGER | no | no | yes | |
| _Assembly_subsystem.Name | Name | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.CAS_name | CASName | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.CAS_registry_number | CASRegistryNumber | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.Enzyme_commission_number | EnzymeCommissionNumber | VARCHAR(127) | no | no | no | |
| _Assembly_subsystem.Molecular_mass | MolecularMass | FLOAT | no | no | no | |
| _Assembly_subsystem.Details | Details | TEXT | no | no | no | |
| _Assembly_subsystem.DB_query_date | DBQueryDate | DATETIME year to day | no | no | no | |
| _Assembly_subsystem.DB_last_query_revised_last_date | DBLastQueryRevisedLastDate | DATETIME year to day | no | no | no |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_systematic_name.Name | Name | VARCHAR(127) | no | no | no | |
| _Assembly_systematic_name.Naming_system | NamingSystem | VARCHAR(127) | no | no | yes | |
|
[saveframe id tag] _Assembly_systematic_name.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_systematic_name.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_systematic_name.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Assembly_type.Type | Type | VARCHAR(127) | no | no | yes | |
|
[saveframe id tag] _Assembly_type.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Assembly_type.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Assembly_type.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Atom.Assembly_atom_ID |
AssemblyAtomID | INTEGER | no | no | yes | |
| _Atom.Entity_assembly_ID | EntityAssemblyID | INTEGER | no | no | no | |
| _Atom.Entity_ID | EntityID | INTEGER | no | no | no | |
| _Atom.Comp_index_ID | CompIndexID | INTEGER | no | no | no | |
| _Atom.Seq_ID | SeqID | INTEGER | no | no | no | |
| _Atom.Comp_ID | CompID | CHAR(12) | no | no | no | |
| _Atom.Atom_type_ID | AtomTypeID | INTEGER | no | no | no | |
| _Atom.Atom_ID | AtomID | CHAR(12) | no | no | no | |
| _Atom.Type_symbol | TypeSymbol | VARCHAR(15) | no | no | no | |
| _Atom.PDB_one_letter_code | PDBOneLetterCode | VARCHAR(15) | no | no | no | |
| _Atom.PDB_strand_ID | PDBStrandID | VARCHAR(15) | no | no | no | |
| _Atom.PDB_ins_code | PDBInsCode | VARCHAR(15) | no | no | no | |
| _Atom.PDB_asym_ID | PDBAsymID | CHAR(12) | no | no | no | |
| _Atom.PDB_seq_ID | PDBSeqID | INTEGER | no | no | no | |
| _Atom.PDB_comp_ID | PDBCompID | CHAR(12) | no | no | no | |
| _Atom.PDB_group | PDBGroup | VARCHAR(15) | no | no | no | |
| _Atom.PDB_atom_ID | PDBAtomID | VARCHAR(15) | no | no | no | |
| _Atom.PDB_atom_type | PDBAtomType | VARCHAR(15) | no | no | no | |
|
[saveframe id tag] _Atom.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Atom.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Atom.Assembly_ID | AssemblyID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
|
[row index tag] _Atom_chem_shift.ID |
AtomChemShiftID | INTEGER | no | no | yes | |
| _Atom_chem_shift.Assembly_atom_ID | AssemblyAtomID | INTEGER | no | no | no | |
| _Atom_chem_shift.Entity_assembly_ID | EntityAssemblyID | INTEGER | no | no | no | |
| _Atom_chem_shift.Entity_ID | EntityID | INTEGER | no | no | no | |
| _Atom_chem_shift.Comp_index_ID | CompIndexID | INTEGER | no | no | no | |
| _Atom_chem_shift.Seq_ID | SeqID | INTEGER | no | no | no | |
| _Atom_chem_shift.Comp_ID | CompID | CHAR(12) | no | no | no | |
| _Atom_chem_shift.Atom_ID | AtomID | CHAR(12) | no | no | no | |
| _Atom_chem_shift.Atom_type | AtomType | VARCHAR(15) | no | no | no | |
| _Atom_chem_shift.Atom_isotope_number | AtomIsotopeNumber | INTEGER | no | no | no | |
| _Atom_chem_shift.Val | Val | FLOAT | no | no | no | |
| _Atom_chem_shift.Val_err | ValErr | FLOAT | no | no | no | |
| _Atom_chem_shift.Assign_fig_of_merit | AssignFigOfMerit | FLOAT | no | no | no | |
| _Atom_chem_shift.Ambiguity_code | AmbiguityCode | VARCHAR(3) | no | no | no | |
| _Atom_chem_shift.Occupancy | Occupancy | CHAR(12) | no | no | no | |
| _Atom_chem_shift.Resonance_ID | ResonanceID | INTEGER | no | no | no | |
| _Atom_chem_shift.Auth_entity_assembly_ID | AuthEntityAssemblyID | VARCHAR(15) | no | no | no | |
| _Atom_chem_shift.Auth_seq_ID | AuthSeqID | VARCHAR(15) | no | no | no | |
| _Atom_chem_shift.Auth_comp_ID | AuthCompID | VARCHAR(15) | no | no | no | |
| _Atom_chem_shift.Auth_atom_ID | AuthAtomID | VARCHAR(15) | no | no | no | |
| _Atom_chem_shift.Details | Details | TEXT | no | no | no | |
|
[saveframe id tag] _Atom_chem_shift.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Atom_chem_shift.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Atom_chem_shift.Assigned_chem_shift_list_ID | AssignedChemShiftListID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Atom_nomenclature.Atom_ID | AtomID | CHAR(12) | no | no | yes | |
| _Atom_nomenclature.Atom_name | AtomName | VARCHAR(15) | no | no | no | |
| _Atom_nomenclature.Naming_system | NamingSystem | VARCHAR(127) | no | no | no | |
|
[saveframe id tag] _Atom_nomenclature.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Atom_nomenclature.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Atom_nomenclature.Comp_ID | CompID | CHAR(12) | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Atom_site.Model_ID | ModelID | INTEGER | no | no | no | |
| _Atom_site.Model_site_ID | ModelSiteID | INTEGER | no | no | no | |
|
[row index tag] _Atom_site.ID |
AtomSiteID | INTEGER | no | no | yes | |
| _Atom_site.Assembly_atom_ID | AssemblyAtomID | INTEGER | no | no | no | |
| _Atom_site.Label_entity_assembly_ID | LabelEntityAssemblyID | INTEGER | no | no | no | |
| _Atom_site.Label_entity_ID | LabelEntityID | INTEGER | no | no | no | |
| _Atom_site.Label_comp_index_ID | LabelCompIndexID | INTEGER | no | no | no | |
| _Atom_site.Label_comp_ID | LabelCompID | CHAR(12) | no | no | no | |
| _Atom_site.Label_atom_ID | LabelAtomID | CHAR(12) | no | no | no | |
| _Atom_site.Type_symbol | TypeSymbol | VARCHAR(15) | no | no | no | |
| _Atom_site.Cartn_x | CartnX | FLOAT | no | no | no | |
| _Atom_site.Cartn_y | CartnY | FLOAT | no | no | no | |
| _Atom_site.Cartn_z | CartnZ | FLOAT | no | no | no | |
| _Atom_site.Cartn_x_esd | CartnXEsd | FLOAT | no | no | no | |
| _Atom_site.Cartn_y_esd | CartnYEsd | FLOAT | no | no | no | |
| _Atom_site.Cartn_z_esd | CartnZEsd | FLOAT | no | no | no | |
| _Atom_site.Occupancy | Occupancy | FLOAT | no | no | no | |
| _Atom_site.Occupancy_esd | OccupancyEsd | FLOAT | no | no | no | |
| _Atom_site.Uncertainty | Uncertainty | FLOAT | no | no | no | |
| _Atom_site.Ordered_flag | OrderedFlag | INTEGER | no | no | no | |
| _Atom_site.Footnote_ID | FootnoteID | INTEGER | no | no | no | |
| _Atom_site.PDBX_label_asym_ID | PDBXLabelAsymID | CHAR(12) | no | no | no | |
| _Atom_site.PDBX_label_seq_ID | PDBXLabelSeqID | INTEGER | no | no | no | |
| _Atom_site.PDBX_label_comp_ID | PDBXLabelCompID | VARCHAR(15) | no | no | no | |
| _Atom_site.PDBX_label_atom_ID | PDBXLabelAtomID | CHAR(12) | no | no | no | |
| _Atom_site.PDBX_label_entity_ID | PDBXLabelEntityID | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_record_ID | PDBRecordID | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_atom_name | PDBAtomName | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_ins_code | PDBInsCode | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_model_num | PDBModelNum | INTEGER | no | no | no | |
| _Atom_site.PDB_residue_name | PDBResidueName | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_residue_no | PDBResidueNo | VARCHAR(15) | no | no | no | |
| _Atom_site.PDB_strand_id | PDBStrandId | VARCHAR(15) | no | no | no | |
| _Atom_site.Auth_asym_ID | AuthAsymID | CHAR(12) | no | no | no | |
| _Atom_site.Auth_chain_ID | AuthChainID | VARCHAR(15) | no | no | no | |
| _Atom_site.Auth_entity_assembly_ID | AuthEntityAssemblyID | INTEGER | no | no | no | |
| _Atom_site.Auth_seq_ID | AuthSeqID | CHAR(12) | no | no | no | |
| _Atom_site.Auth_comp_ID | AuthCompID | VARCHAR(15) | no | no | no | |
| _Atom_site.Auth_atom_ID | AuthAtomID | VARCHAR(15) | no | no | no | |
| _Atom_site.Auth_atom_name | AuthAtomName | VARCHAR(15) | no | no | no | |
| _Atom_site.Details | Details | TEXT | no | no | no | |
|
[saveframe id tag] _Atom_site.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Atom_site.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Atom_site.Conformer_family_coord_set_ID | ConformerFamilyCoordSetID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Atom_sites_footnote.Footnote_ID | FootnoteID | INTEGER | no | no | yes | |
| _Atom_sites_footnote.Text | Text | TEXT | no | no | no | |
|
[saveframe id tag] _Atom_sites_footnote.Sf_ID |
SfID | INTEGER | no | yes | no | |
| _Atom_sites_footnote.Entry_ID | EntryID | CHAR(12) | no | no | yes | |
| _Atom_sites_footnote.Conformer_family_coord_set_ID | ConformerFamilyCoordSetID | INTEGER | no | no | yes |
| tag name |
database column name |
depositiion mandatory code |
data type | indexed for searching |
internal use only |
part of the primary key |
|---|---|---|---|---|---|---|
| _Atom_type.ID | AtomTypeID | INTEGER | no | no | yes | |