mendeleev.dbml

Project "ea846d6d-5e1b-4e1e-b788-632ab20f001f" {
  database_type: "SQLite 3.45.1"
  Note: '''
-- generated by: SchemaCrawler 16.21.2
-- generated on: 2024-12-30T16:34:20.431711
-- database: SQLite 3.45.1
-- driver: SQLite JDBC 3.45.1.0
-- operating system: Linux 5.15.0-130-generic
-- JVM system: Eclipse Adoptium OpenJDK 64-Bit Server VM 11.0.22+7

  '''
}
Table "alembic_version" {
  "version_num" "VARCHAR" [not null]
}

Table "groups" {
  "group_id" "INTEGER" [not null]
  "symbol" "VARCHAR" [null]
  "name" "VARCHAR" [null]
  indexes {
    ("group_id") [pk]
  }
}

Table "ionizationenergies" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [not null]
  "species_name" "VARCHAR" [not null]
  "ion_charge" "INTEGER" [not null]
  "isoelectonic_sequence" "VARCHAR" [not null]
  "ground_shells" "VARCHAR" [null]
  "ground_configuration" "VARCHAR" [null]
  "ground_level" "VARCHAR" [null]
  "ionized_level" "VARCHAR" [null]
  "ionization_energy" "FLOAT" [null]
  "uncertainty" "FLOAT" [null]
  "references" "TEXT" [null]
  "is_semi_empirical" "BOOLEAN" [null]
  "is_theoretical" "BOOLEAN" [null]
  indexes {
    ("id") [pk]
  }
}

Table "phasetransitions" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "boiling_point" "FLOAT" [null]
  "melting_point" "FLOAT" [null]
  "critical_temperature" "FLOAT" [null]
  "critical_pressure" "FLOAT" [null]
  "triple_point_temperature" "FLOAT" [null]
  "triple_point_pressure" "FLOAT" [null]
  "allotrope" "VARCHAR" [null]
  "is_sublimation_point" "BOOLEAN" [null]
  "is_transition" "BOOLEAN" [null]
  indexes {
    ("id") [pk]
  }
}

Table "propertymetadata" {
  "id" "INTEGER" [not null]
  "table_name" "VARCHAR" [null]
  "column_name" "VARCHAR" [null]
  "class_name" "VARCHAR" [not null]
  "attribute_name" "VARCHAR" [not null]
  "category" "VARCHAR" [not null]
  "value_origin" "VARCHAR" [not null]
  "description" "TEXT" [not null]
  "unit" "VARCHAR" [null]
  "annotations" "TEXT" [null]
  "citation_keys" "VARCHAR" [null]
  indexes {
    ("id") [pk]
  }
}

Table "scattering_factors" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "energy" "FLOAT" [null]
  "f1" "FLOAT" [null]
  "f2" "FLOAT" [null]
  indexes {
    ("id") [pk]
  }
}

Table "series" {
  "id" "INTEGER" [not null]
  "name" "VARCHAR" [null]
  "color" "VARCHAR" [null]
  indexes {
    ("id") [pk]
  }
}

Table "elements" {
  "_annotation" "VARCHAR" [null]
  "atomic_number" "INTEGER" [not null]
  "atomic_radius" "FLOAT" [null]
  "atomic_volume" "FLOAT" [null]
  "block" "VARCHAR" [null]
  "density" "FLOAT" [null]
  "description" "VARCHAR" [null]
  "dipole_polarizability" "FLOAT" [null]
  "electron_affinity" "FLOAT" [null]
  "electronic_configuration" "VARCHAR" [null]
  "evaporation_heat" "FLOAT" [null]
  "fusion_heat" "FLOAT" [null]
  "group_id" "INTEGER" [null]
  "lattice_constant" "FLOAT" [null]
  "lattice_structure" "VARCHAR" [null]
  "name" "VARCHAR" [null]
  "period" "INTEGER" [null]
  "series_id" "INTEGER" [null]
  "specific_heat_capacity" "FLOAT" [null]
  "symbol" "VARCHAR" [null]
  "thermal_conductivity" "FLOAT" [null]
  "vdw_radius" "FLOAT" [null]
  "covalent_radius_cordero" "FLOAT" [null]
  "covalent_radius_pyykko" "FLOAT" [null]
  "en_pauling" "FLOAT" [null]
  "en_allen" "FLOAT" [null]
  "jmol_color" "VARCHAR" [null]
  "cpk_color" "VARCHAR" [null]
  "proton_affinity" "FLOAT" [null]
  "gas_basicity" "FLOAT" [null]
  "heat_of_formation" "FLOAT" [null]
  "c6" "FLOAT" [null]
  "covalent_radius_bragg" "FLOAT" [null]
  "vdw_radius_bondi" "FLOAT" [null]
  "vdw_radius_truhlar" "FLOAT" [null]
  "vdw_radius_rt" "FLOAT" [null]
  "vdw_radius_batsanov" "FLOAT" [null]
  "vdw_radius_dreiding" "FLOAT" [null]
  "vdw_radius_uff" "FLOAT" [null]
  "vdw_radius_mm3" "FLOAT" [null]
  "abundance_crust" "FLOAT" [null]
  "abundance_sea" "FLOAT" [null]
  "molcas_gv_color" "VARCHAR" [null]
  "en_ghosh" "FLOAT" [null]
  "vdw_radius_alvarez" "FLOAT" [null]
  "c6_gb" "FLOAT" [null]
  "atomic_weight" "FLOAT" [null]
  "atomic_weight_uncertainty" "FLOAT" [null]
  "is_monoisotopic" "BOOLEAN" [null]
  "is_radioactive" "BOOLEAN" [null]
  "cas" "VARCHAR" [null]
  "atomic_radius_rahm" "FLOAT" [null]
  "geochemical_class" "VARCHAR" [null]
  "goldschmidt_class" "VARCHAR" [null]
  "metallic_radius" "FLOAT" [null]
  "metallic_radius_c12" "FLOAT" [null]
  "covalent_radius_pyykko_double" "FLOAT" [null]
  "covalent_radius_pyykko_triple" "FLOAT" [null]
  "discoverers" "VARCHAR" [null]
  "discovery_year" "INTEGER" [null]
  "discovery_location" "VARCHAR" [null]
  "name_origin" "VARCHAR" [null]
  "sources" "VARCHAR" [null]
  "uses" "VARCHAR" [null]
  "mendeleev_number" "INTEGER" [null]
  "dipole_polarizability_unc" "FLOAT" [null]
  "pettifor_number" "INTEGER" [null]
  "glawe_number" "INTEGER" [null]
  "molar_heat_capacity" "FLOAT" [null]
  "en_miedema" "FLOAT" [null]
  "miedema_molar_volume" "FLOAT" [null]
  "miedema_electron_density" "FLOAT" [null]
  "en_gunnarsson_lundqvist" "FLOAT" [null]
  "en_robles_bartolotti" "FLOAT" [null]
  "production_concentration" "FLOAT" [null]
  "relative_supply_risk" "FLOAT" [null]
  "reserve_distribution" "FLOAT" [null]
  "political_stability_of_top_producer" "FLOAT" [null]
  "political_stability_of_top_reserve_holder" "FLOAT" [null]
  "top_3_producers" "VARCHAR" [null]
  "top_3_reserve_holders" "VARCHAR" [null]
  "recycling_rate" "VARCHAR" [null]
  "substitutability" "VARCHAR" [null]
  indexes {
    ("atomic_number") [pk]
  }
}

Table "ionicradii" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "charge" "INTEGER" [null]
  "econf" "VARCHAR" [null]
  "coordination" "VARCHAR" [null]
  "spin" "VARCHAR" [null]
  "crystal_radius" "FLOAT" [null]
  "ionic_radius" "FLOAT" [null]
  "origin" "VARCHAR" [null]
  "most_reliable" "BOOLEAN" [null]
  indexes {
    ("id") [pk]
  }
}

Table "isotopes" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "mass" "FLOAT" [null]
  "abundance" "FLOAT" [null]
  "mass_number" "INTEGER" [null]
  "mass_uncertainty" "FLOAT" [null]
  "is_radioactive" "BOOLEAN" [null]
  "half_life" "FLOAT" [null]
  "half_life_unit" "VARCHAR" [null]
  "spin" "VARCHAR" [null]
  "g_factor" "FLOAT" [null]
  "quadrupole_moment" "FLOAT" [null]
  "parity" "VARCHAR" [null]
  "discovery_year" "INTEGER" [null]
  "g_factor_uncertainty" "FLOAT" [null]
  "abundance_uncertainty" "FLOAT" [null]
  "half_life_uncertainty" "FLOAT" [null]
  "quadrupole_moment_uncertainty" "FLOAT" [null]
  indexes {
    ("id") [pk]
  }
}

Table "oxidationstates" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "oxidation_state" "INTEGER" [null]
  "category" "VARCHAR" [null]
  indexes {
    ("id") [pk]
  }
}

Table "screeningconstants" {
  "id" "INTEGER" [not null]
  "atomic_number" "INTEGER" [null]
  "n" "INTEGER" [null]
  "s" "VARCHAR" [null]
  "screening" "FLOAT" [null]
  indexes {
    ("id") [pk]
  }
}

Table "isotopedecaymodes" {
  "id" "INTEGER" [not null]
  "isotope_id" "INTEGER" [not null]
  "mode" "VARCHAR" [not null]
  "relation" "VARCHAR" [null]
  "intensity" "FLOAT" [null]
  "is_allowed_not_observed" "BOOLEAN" [null]
  "is_observed_intensity_unknown" "BOOLEAN" [null]
  indexes {
    ("id") [pk]
  }
}

Ref "SCHCRWLR_B63DD9D4_FF80C0F7" {
  "groups".("group_id") < "elements".("group_id") [update: no action, delete: no action]
}

Ref "SCHCRWLR_CA01FE77_FF80C0F7" {
  "series".("id") < "elements".("series_id") [update: no action, delete: no action]
}

Ref "SCHCRWLR_FF80C0F7_805EF613" {
  "elements".("atomic_number") < "ionicradii".("atomic_number") [update: no action, delete: no action]
}

Ref "SCHCRWLR_FF80C0F7_22C8BF5E" {
  "elements".("atomic_number") < "isotopes".("atomic_number") [update: no action, delete: no action]
}

Ref "SCHCRWLR_FF80C0F7_279A15F3" {
  "elements".("atomic_number") < "oxidationstates".("atomic_number") [update: no action, delete: no action]
}

Ref "SCHCRWLR_FF80C0F7_510F3619" {
  "elements".("atomic_number") < "screeningconstants".("atomic_number") [update: no action, delete: no action]
}

Ref "fk_isotope_decaymodes_1" {
  "isotopes".("id") < "isotopedecaymodes".("isotope_id") [update: no action, delete: cascade]
}


TableGroup " " {
  "alembic_version"
  "groups"
  "ionizationenergies"
  "phasetransitions"
  "propertymetadata"
  "scattering_factors"
  "series"
  "elements"
  "ionicradii"
  "isotopes"
  "oxidationstates"
  "screeningconstants"
  "isotopedecaymodes"
}