spool-drawing

Tables (5)

component_connections

  • id — SERIAL
  • drawing_id — INTEGER — Foreign key → drawings.id
  • from_id — INTEGER — Foreign key → extracted_components.id
  • to_id — INTEGER — Foreign key → extracted_components.id
  • connection_type — VARCHAR(50)

drawings

  • id — SERIAL
  • project_id — INTEGER — Foreign key → projects.id
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — TEXT
  • status — VARCHAR(50)
  • uploaded_at — TIMESTAMP

extracted_components

  • id — SERIAL
  • drawing_id — INTEGER — Foreign key → drawings.id
  • category — VARCHAR(50)
  • tag_no — VARCHAR(100)
  • attributes — JSONB
  • location — JSONB
  • confidence — FLOAT
  • created_at — TIMESTAMP

ocr_raw_results

  • id — SERIAL
  • drawing_id — INTEGER — Foreign key → drawings.id
  • engine_version — VARCHAR(100)
  • raw_data — JSONB
  • processed_at — TIMESTAMP

projects

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • config — JSONB
  • created_at — TIMESTAMP