FIH Scout Database Schema for HNSCC Trial Analysis
Source type:
obs· Harvested: 2026-05-03 · Original date: 2026-05-03T12:14:47.628Z Metadata:{"project":"lunhsiangyuan","type":"discovery","obs_id":65004}
obs/65004 · discovery · 2026-05-03T12:14:47.628Z
FIH Scout Database Schema for HNSCC Trial Analysis
Explored the FIH Scout database schema to understand how HNSCC trial data is structured and queried. The database uses a view-based architecture where v_trial_indication_family provides disease area classification by pattern-matching trial conditions against indication_family_pattern lookup table. Each trial links to sponsor via sponsor_id foreign key and to interventions via trial_intervention junction table. The is_fih_subset boolean flag filters for first-in-human trials. The schema supports efficient querying of trials by indication family (e.g., head_neck_cancer) combined with phase, sponsor, and intervention filters. This pattern enables rapid extraction of competitive intelligence data for specific therapeutic areas.
Concepts: [“how-it-works”,“pattern”]
Facts: [“v_trial_indication_family view joins trial_condition table with indication_family_pattern using LIKE pattern matching on condition text”,“Trial table contains 20 core columns: nct_id, brief_title, phases, overall_status, start_date, sponsor_id, is_fih_subset, enrollment_count, location_count”,“trial_intervention table stores intervention_name and intervention_type linked by trial_id”,“sponsor table uses sponsor_class field with default ‘OTHER’ classification”,“Query pattern for indication family filtering: JOIN v_trial_indication_family WHERE family_key = ‘head_neck_cancer’ AND is_fih_subset = 1”,“40 FIH HNSCC trials returned spanning 2024-01 to 2026-04 start dates”]
[← 回 Alfred Brain Hub]