MDDR Database

Tables (3)

ATOM (atom)

  • ID (id) — VARCHAR — Primary key — NOT NULL
  • Parent (parent) — INT — Foreign key → Molecule.Name — NOT NULL
  • Name (name) — VARCHAR
  • Visible (visible) — VARCHAR
  • Color (color) — VARCHAR
  • Element (element) — VARCHAR
  • Hybridization (hybridization) — VARCHAR
  • Partial Charge (partial_charge) — INT
  • Formal Charge (formal charge) — INT
  • Chirality (chirality) — VARCHAR
  • Occupancy (occupancy) — INT
  • Isotropic Displacement (isotropic _displacement) — INT
  • Oxidation State (oxidation_state) — INT

Bond (bond)

  • Name (name) — VARCHAR — Primary key — NOT NULL
  • Parent (parent) — INT — Foreign key → Molecule.Name — NOT NULL
  • ID (id) — INT
  • Visible (visible) — VARCHAR
  • Order (order) — INT
  • Type (type) — VARCHAR
  • Length (length) — DOUBLE

Molecule (molecule)

  • Name (name) — INT — Primary key — NOT NULL
  • Index (index) — INT
  • Visible (visible) — VARCHAR
  • Tagged (tagged) — VARCHAR
  • Visibility Locked (visibility_locked) — VARCHAR
  • Molregno (molegno) — INT
  • Molecular Weight (molecular_weight) — VARCHAR
  • Molformula (molformula) — VARCHAR
  • Extreg (extreg) — VARCHAR
  • Molname (molname) — VARCHAR
  • Pref.Number (pref.number) — VARCHAR
  • Phase (phase) — VARCHAR
  • Phase_Year (phase_year) — VARCHAR
  • Act.Investigation (act.investigation) — VARCHAR
  • Action (action) — VARCHAR
  • Hacceptors — INT
  • Hdonors — INT
  • Molweight.Frag (molweight.Frag) — VARCHAR
  • Rule5 (rule5) — INT
  • TDF — INT
  • CLogP — DOUBLE
  • Chem.Name (chem.name) — VARCHAR
  • Model_Extreg (model_Extreg) — VARCHAR
  • Modelname (modelname) — VARCHAR
  • Model_Source (model_source) — VARCHAR
  • CCRatio — DOUBLE
  • Warning (warning) — VARCHAR
  • Generic.name (generic.name) — VARCHAR
  • Company.code (company.code) — VARCHAR
  • Trademark (trademark) — VARCHAR
  • CAS — VARCHAR
  • Source (source) — VARCHAR
  • License.info (license.info) — VARCHAR
  • Mol.mech (mol.mech) — VARCHAR
  • Thera.Group (thera.group) — VARCHAR
  • Prous.Ref (prous.ref) — VARCHAR
  • Lit.Title (lit.title) — VARCHAR
  • Lit.Type (lit.type) — VARCHAR
  • Lit.ref (lit.ref) — VARCHAR
  • Openrl (openurl) — VARCHAR
  • DOI — VARCHAR
  • Pat.Source (pat.source) — VARCHAR
  • Pat.title (pat.title) — VARCHAR
  • Pat.Invent (pat.invent) — VARCHAR
  • Pat.priority (pat.priority) — VARCHAR
  • Pat.Number (pat.number) — VARCHAR
  • Pat.Type (pat.type) — VARCHAR
  • Rel.Code (rel.code) — VARCHAR
  • Derivative (derivatie) — VARCHAR
  • Phys.Properties (phys.propertires) — VARCHAR
  • Last_Phase_Change (last_phase_change) — VARCHAR
  • Last_Phase (last_phase) — VARCHAR
  • Clean Energy (clean_energy) — DOUBLE
  • Cell.Mech (cell.mech) — VARCHAR