Field-oriented overview of Research Connector Hub data domains for stakeholders and web-server copy-back. This page replaces the former full-column SQL catalog. Operational schema truth is the live Flask SQLAlchemy models and Alembic migrations.
docs/schema.md, docs/data_import.md) expand developer detail| Data area | Key information (representative fields) | Current status |
|---|---|---|
| Accounts and access | Email, role (researcher / partner / community / admin), institution scope, verification, last login / last activity, optional 2FA, suspension status, invitation tokens, password-reset tokens | Implemented |
| Researcher profiles | Name, title, department, bio, affiliations, keywords, contact details, profile links, availability / vacation mode, claim status, public visibility, generated and custom profile sections with order/visibility | Implemented Publication editing UI and self-service photo upload still planned |
| Partner organizations | Organization name, type/sector, location, website, description, members, prospect/source notes, admin CRM notes, organization status | Implemented |
| Partnership requests | Project title and description, problem statement, specialization, sector, timeline, TRL, contact, lifecycle status (including draft), attachments, partner-visible history, admin request notes | Implemented Login required for intake |
| Matching and partnerships | Matched researcher, request, score, explanation, review decision, active partnership status, start context, primary researcher link, partnership file metadata | Deterministic matching implemented Workspace upload UI and AI-assisted matching remain partial/planned |
| Communication | Message threads, participants, messages, connection approvals, user alerts (seen/dismissed), email templates, delivery logs, outreach CRM records | Implemented Message attachments planned |
| Research intelligence | Import runs, file-upload candidates, research engine runs, embeddings, Network Explorer saved views/annotations, deep-research batch/query monitors, scheduled intelligence tasks/runs | Workbench implemented External scraping workers, citation persistence, and unsupervised writes planned |
| Administration & ops | System settings, activity logs, SEO/GEO metadata, help article governance/feedback, rate-limit sensitive flows, capability-gated technical admin surfaces | Implemented Production MySQL/SMTP validation pending |
| Files & storage | Partner request attachments; partnership_files metadata; shared storage service (local backend); profile photos (admin-managed today) | Partial S3/Spaces, researcher libraries, message attachments, admin evidence uploads planned |
Admin CSV/XLSX researcher import and Research Engine file-upload review use a documented column set (name, email, title, department, bio, keywords, affiliations, profile URLs, and related quality fields). Exact accepted columns live in project data-import documentation; rows require human approval before creating hidden unclaimed profiles.
Last updated: July 17, 2026. Related: SDLC proposal, guidelines.