Relational Map
Relational Map
Read the spreadsheet like one record, not twenty tabs.
Click one branch at a time. Class -> system -> worksheet -> owner -> connected worksheet. This page exists to show who likely owns each sheet, what join key ties it forward, and which connected sheet carries the missing proof.
Source spreadsheet: apex_therapeutics_demo_tracker.xlsx · Click or hover a node and the detail panel below updates live.
// SPREADSHEET STRUCTURE
6 sheets
5 entities
11 FK edges
0 shard group(s)
2 durable
2 fragile
2 exposed
! multiple masters claim PK for: batch_id, deviation_id, operator_id — pick one source of truth.
! intake review required for: Template_Readme, Open_Actions
Relational lineage map
Click any class, system, worksheet, owner, or connected worksheet to pivot the path. Hover a bar to see what that sheet owns or what it joins to.
This view is interactive. It is meant to behave like a decomposition tree, not a static screenshot.
Sheet durability6 item(s)
exposed
Template_Readme
EM
79% confidence
chain: EM uses Template_Readme. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: No join key. Linked sheet: linked sheet pending.
next: Fix no obvious room / area field detected before the next review.
mapped: no mapped fields
evidence: sheet:em
weak spots: no obvious room / area field detected; no canonical columns mapped
fragile
Batch_Release_Queue
MES
80% confidence
chain: MES uses Batch_Release_Queue. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: asset_id. Linked sheet: linked sheet pending.
next: Check the linked sheet before this owner path is trusted.
mapped: batch_id <- batch id, batch_id <- lot id, system_id <- system, deviation_id <- deviation id and 1 more
evidence: sheet:batch, header:batch
weak spots: no immediate intake gaps
durable
Deviation_CAPA
QMS
97% confidence
chain: QMS uses Deviation_CAPA. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: asset_id. Linked sheet: linked sheet pending.
next: Check the linked sheet before this owner path is trusted.
mapped: deviation_id <- deviation id, batch_id <- batch id, batch_id <- lot id, asset_id <- asset id and 1 more
evidence: sheet:deviation, sheet:capa, header:impact, header:deviation, header:quality, header:capa
weak spots: no immediate intake gaps
durable
Calibration_Master
CAL
97% confidence
chain: CAL uses Calibration_Master. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: asset_id. Linked sheet: linked sheet pending.
next: Check the linked sheet before this owner path is trusted.
mapped: asset_id <- asset id, instrument_id <- instrument, room_area <- area, batch_id <- linked batch id and 1 more
evidence: sheet:calibration, sheet:cal, header:calibration
weak spots: no immediate intake gaps
fragile
Training_Matrix_Draft
MES
78% confidence
chain: MES uses Training_Matrix_Draft. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: batch_id. Linked sheet: linked sheet pending.
next: Check the linked sheet before this owner path is trusted.
mapped: operator_id <- operator id, operator_id <- operator, batch_id <- batch id
evidence: header:operator, header:batch
weak spots: no immediate intake gaps
exposed
Open_Actions
MES
65% confidence
chain: MES uses Open_Actions. Owner: Owner missing. Date: ETA signal missing. Status: Status signal missing. Join key: asset_id. Linked sheet: linked sheet pending.
next: Check the linked sheet before this owner path is trusted.
mapped: batch_id <- batch id, batch_id <- lot id, asset_id <- asset id
evidence: header:batch
weak spots: no immediate intake gaps
Sheets6 item(s)
registry
Template_Readme
4 rows
2 cols
tracker
Batch_Release_Queue
5 rows
11 cols
PK: batch id, lot id, deviation id
keys: asset_id, batch_id, deviation_id, system_id
tracker
Deviation_CAPA
5 rows
10 cols
PK: deviation id, batch id, lot id, capa action
keys: asset_id, batch_id, deviation_id
registry
Calibration_Master
5 rows
8 cols
PK: asset id, instrument, linked batch id
keys: asset_id, batch_id, instrument_id, room_area, system_id
tracker
Training_Matrix_Draft
5 rows
8 cols
PK: operator id, operator, batch id
keys: batch_id, operator_id
tracker
Open_Actions
5 rows
8 cols
PK: action id, batch id, lot id
keys: asset_id, batch_id
Shared IDs5 item(s)
batch_id
master
Batch_Release_Queue.batch id
0 ref(s)
(orphaned - no external references)
deviation_id
master
Batch_Release_Queue.deviation id
0 ref(s)
(orphaned - no external references)
asset_id
master
Calibration_Master.asset id
3 ref(s)
Batch_Release_Queue.asset id, Deviation_CAPA.asset id, Open_Actions.asset id
instrument_id
master
Calibration_Master.instrument
0 ref(s)
(orphaned - no external references)
operator_id
master
Training_Matrix_Draft.operator id
0 ref(s)
(orphaned - no external references)
Cross-sheet links11 item(s)
Deviation_CAPA.batch id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Deviation_CAPA.lot id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Calibration_Master.linked batch id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Training_Matrix_Draft.batch id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Open_Actions.batch id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Open_Actions.lot id
to
Batch_Release_Queue.batch id
batch_id
duplicate master — drift risk
Deviation_CAPA.deviation id
to
Batch_Release_Queue.deviation id
deviation_id
duplicate master — drift risk
Deviation_CAPA.capa action
to
Batch_Release_Queue.deviation id
deviation_id
duplicate master — drift risk
Batch_Release_Queue.asset id
to
Calibration_Master.asset id
asset_id
Deviation_CAPA.asset id
to
Calibration_Master.asset id
asset_id
Open_Actions.asset id
to
Calibration_Master.asset id
asset_id
Join keys are inferred from repeated headers and repeated identifiers.
The interactive tree is the fast read: which sheet you are on, who likely owns it, and which other sheet it ties into.