chemosensor

Tables (7)

Pubilcation (ref)

  • reference_doi (ref_id) — BIGINT — Primary key
  • author — VARCHAR(30)
  • Field (curation_status) — VARCHAR(20)

Untitled (solvent)

  • Key (solvent_id) — INT — Primary key — NOT NULL — FK
  • Field (solvent_name) — VARCHAR(20)
  • Field (solvent_smiles)
  • Field2 (solvent_mf)
  • Field (buffer) — VARCHAR(60) — e.g. NaCl

Untitled (performance_metric)

  • Key (metric_id) — BIGSERIAL — Primary key — NOT NULL — PK
  • Key (event_id) — BIGSERIAL — Foreign key → sensing event.Key — NOT NULL — PK
  • Field2 (metric_type) — VARCHAR(30) — LOD/LOQ/Ka/lambda
  • Field (method) — VARCHAR(40)
  • Field (is_experimental) — BOOLEAN
  • Field3 (value) — NUMERIC — numeric value
  • Field (unit) — VARCHAR(20) — in LaTeX form

Untitled (measurement)

    metal_ion (Analyte)

    • ion_id — SERIAL — Primary key — NOT NULL — PK
    • symbol — VARCHAR(6) — e.g., 'Hg', 'Cu'
    • charge — SMALLINT — e.g., +2
    • oxidation_state — SMALLINT
    • ion_label — VARCHAR(12) — UNIQUE, e.g., 'Hg2+', 'Fe3+'
    • element_name — VARCHAR(40)
    • category — VARCHAR(30) — transition/heavy/alkali/lanthanide etc.

    probe (Chemosensor)

    • probe_id — BIGSERIAL — Primary key — NOT NULL — PK
    • canonical_smiles — TEXT — NOT NULL
    • inchi — TEXT
    • inchikey — CHAR(27) — UNIQUE, B-tree index; dedup key
    • common_name — TEXT — NOT NULL
    • iupac_name — TEXT
    • pubchem_cid — BIGINT — external xref
    • Field (chembl_id) — VARCHAR(20)
    • molecular_weight — NUMERIC(10,4)
    • curation_status — VARCHAR(20) — enum: auto/validated/flagged
    • Field (chemical_class_id) — INT
    • Field2 (synthesis_ref_pub_id) — BIGINT

    sensing event (sensing_event)

    • Key (event_id) — BIGSERIAL — Primary key — NOT NULL — PK
    • probe_id — BIGSERIAL — Foreign key → probe.probe_id — NOT NULL — FK
    • ion_id — SERIAL — Foreign key → metal_ion.ion_id — NOT NULL — FK
    • Key (solvent_id) — INT — Foreign key → Untitled.Key — NOT NULL — FK
    • reference_doi (ref_id) — BIGINT — Foreign key → Pubilcation.reference_doi
    • Field2 (detection_mode) — VARCHAR(30) — ex. colorimetric/fluorimetric/ dual etc..
    • Field3 (response_type) — VARCHAR(20) — turn-on/turn-off/ratiometric
    • Field (is_selective) — BOOLEAN — primary selectivity flag
    • Field (reversibility) — VARCHAR(20) — reversible/irreversible(chemodosimeter)
    • Field (time_s) — NUMERIC
    • Field (temp_k) — NUMERIC(5,2)