← atlas·database-tables

add-foreign-key

User initiates creation of a foreign key relationship in the database tables view. The journey covers the FK dialog (table/column selection), relationship visualization (Nate's SchemaMap), impact analysis (Sara's KpiBand), and team context (Monica).

default path · what bare Studio does

  1. 01
    route/project/[ref]/database/tablesactionselect-tablehookuseDatabaseTablesSnapshot
  2. 02
    route/project/[ref]/database/tablesactionopen-foreign-key-creationuiopen-modal
  3. 03
    route/project/[ref]/database/tablesactionselect-target-table
  4. 04
    route/project/[ref]/database/tablesactionselect-target-column
  5. 05
    route/project/[ref]/database/tablesactionconfirm-add-foreign-keyside-effectexecute-ddl
  6. 06
    route/project/[ref]/database/tablesactionserver-ackuischema-update-toast

per-profile overrides · vehicle × route

Three vehicles, three routes

Connector · Battleship

Monica

sea route

“Bring the team into the workflow.”

deltas

  • ›Enter: recent-activity-feed
  • ›prelude · CollabRail
  • ›on save · TeamSaveAck

slot fillers wired

  • preright-rail · CollabRail
  • on savesave-confirmation · TeamSaveAckFK created: 2 team members use this relationship

cognitive justification

HSP + Connector → relationship creation anxiety softens with team context. The collab rail surfaces who might be impacted; the save-ack provides social proof that the FK is consistent with team patterns (GABA −22 sensory relief).

Try Monica's route →

Explorer · Tractor

Nate

field route

“Show me what I don't already know.”

deltas

  • ›Enter: schema-map-tile
  • ›prelude · SchemaMap
  • ›destructive · AdvanceNoticeStrip 3000ms
  • ›chunk · 4

slot fillers wired

  • premain-prelude · SchemaMap
  • pre-destructiveadvance-notice · AdvanceNoticeStrip3000ms

cognitive justification

ASD prediction-error + DYS GLUT-drain → SchemaMap first lets Nate see the relationship visually before committing. Advance-notice strip buffers surprise. Zero motion + chunking respect HSP flood and GLUT-drain.

Try Nate's route →

Analyst · Airplane

Sara

air route

“Numbers first. Then we talk.”

deltas

  • ›Enter: kpi-drill
  • ›prelude · KpiBand
  • ›on save · SaveLedger

slot fillers wired

  • premain-prelude · KpiBand
  • on savemain-postlude · SaveLedger✓ FK created · {{parent_count}}/{{child_count}} rows linked

cognitive justification

CORT +19 + Analyst (A 0.000) → KpiBand's cardinality counts ("2000 parent / 15000 child") satisfy DA-seeking. SaveLedger's final link count provides reassurance that the FK encompasses the intended data (no orphans visible).

Try Sara's route →