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
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)