DF2 Schema Graph Interactive Editor (ZIP+Code Matched)

How to use: Drag nodes to reposition | Right-click a node to resize | Drag edge labels to reposition | Save/Load the layout as JSON

This graph is updated to match the DF2 extraction code and the produced ZIP outputs (tables + column schemas). It is pair-centric: pair_id is the hub key, while retrieval query/gallery IDs join via image_id_int.

Checked elements Validating...

Nodes

Edges

Join semantics (exactly reflecting the extractor behavior):

Pairs is the hub table keyed by pair_id.
Images preserves both image_id_raw (zero-padded filename stem) and image_id_int (int string).
RetrievalPairs stores query/gallery IDs as seen in retrieval JSONs (often non-padded numeric strings), so the stable join is:
RetrievalPairs.query_image_id_raw / gallery_image_id_raw → Images.image_id_int
Items, BBox, Segmentation, KeypointsRaw, QualityFlags are item-centric and join via item_uid.
QCSummary is run-level metadata; the edge from Pairs is conceptual (not a FK) and is rendered as a black dashed edge.

DF2 Schema Graph Interactive Editor (ZIP + Code Matched)

Checked elements Validating...