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