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