config:
  primaryKey: prd_id
  schema: prd
  skipForeignKeys: true
tables:
  - name: brief_summary
    columns:
      - - prd_id
        - text
        - null
      - - docid
        - integer
        - null
      - - name
        - text
        - null
      - - formula
        - text
        - null
      - - description
        - text
        - null
      - - update_date
        - timestamp without time zone
        - null
      - - keywords
        - 'text[]'
        - null
    primary_key:
      - prd_id
    foreign_keys: []
    indexes:
      - docid
      - keywords
    unique: []
    keywords: []
    unique_keys: []
  - name: chem_comp
    columns:
      - - prd_id
        - text
      - - formula
        - text
      - - formula_weight
        - double precision
      - - id
        - text
      - - name
        - text
      - - type
        - text
      - - pdbx_release_status
        - text
    primary_key:
      - prd_id
      - id
    foreign_keys:
      - - - prd_id
        - brief_summary
        - - prd_id
    unique_keys: []
    keywords:
      - formula
      - model_details
      - model_source
      - mon_nstd_class
      - mon_nstd_details
      - name
      - pdbx_synonyms
      - pdbx_modification_details
      - pdbx_subcomponent_list
      - pdbx_model_coordinates_details
      - pdbx_ideal_coordinates_details
      - pdbx_reserved_name
      - pdbx_smiles
  - name: chem_comp_atom
    columns:
      - - prd_id
        - text
      - - alt_atom_id
        - text
      - - atom_id
        - text
      - - charge
        - integer
      - - model_Cartn_x
        - double precision
      - - model_Cartn_y
        - double precision
      - - model_Cartn_z
        - double precision
      - - comp_id
        - text
      - - type_symbol
        - text
      - - pdbx_align
        - integer
      - - pdbx_ordinal
        - integer
      - - pdbx_component_atom_id
        - text
      - - pdbx_component_comp_id
        - text
      - - pdbx_model_Cartn_x_ideal
        - double precision
      - - pdbx_model_Cartn_y_ideal
        - double precision
      - - pdbx_model_Cartn_z_ideal
        - double precision
      - - pdbx_stereo_config
        - text
      - - pdbx_aromatic_flag
        - text
      - - pdbx_leaving_atom_flag
        - text
      - - pdbx_residue_numbering
        - integer
      - - pdbx_polymer_type
        - text
      - - pdbx_ref_id
        - text
      - - pdbx_component_id
        - integer
    primary_key:
      - prd_id
      - comp_id
      - atom_id
    foreign_keys:
      - - - prd_id
        - brief_summary
        - - prd_id
    unique_keys: []
    keywords: []
  - name: chem_comp_bond
    columns:
      - - prd_id
        - text
      - - atom_id_1
        - text
      - - atom_id_2
        - text
      - - comp_id
        - text
      - - value_order
        - text
      - - pdbx_ordinal
        - integer
      - - pdbx_stereo_config
        - text
      - - pdbx_aromatic_flag
        - text
    primary_key:
      - prd_id
      - comp_id
      - atom_id_1
      - atom_id_2
    foreign_keys:
      - - - prd_id
        - brief_summary
        - - prd_id
    unique_keys: []
    keywords: []
  - name: pdbx_chem_comp_descriptor
    columns:
      - - prd_id
        - text
      - - comp_id
        - text
      - - descriptor
        - text
      - - type
        - text
      - - program
        - text
      - - program_version
        - text
    primary_key:
      - prd_id
      - comp_id
      - type
      - program
      - program_version
    foreign_keys:
      - - - prd_id
        - brief_summary
        - - prd_id
    unique_keys: []
    keywords:
      - descriptor
  - name: pdbx_chem_comp_identifier
    columns:
      - - prd_id
        - text
      - - comp_id
        - text
      - - identifier
        - text
      - - type
        - text
      - - program
        - text
      - - program_version
        - text
    primary_key:
      - prd_id
      - comp_id
      - type
      - program
      - program_version
    foreign_keys:
      - - - prd_id
        - brief_summary
        - - prd_id
    unique_keys: []
    keywords:
      - identifier
customQuery:
  - >-
    create table prd.brief_summary_with_hit_score (hit_score real) inherits 
    (brief_summary);