SQL

CREATE TABLE elements (
  id INT,
  frame_id INT,
  source TEXT,
  role TEXT,
  text TEXT,
  parent_id INT,
  depth INT,
  left_bound REAL,
  top_bound REAL,
  width_bound REAL,
  height_bound REAL,
  confidence REAL,
  sort_order INT,
  properties TEXT
)

Columns

Column Data type Allow null Primary key Actions
id INT ✓ read-only
frame_id INT ✓ read-only
source TEXT ✓ read-only
role TEXT ✓ read-only
text TEXT ✓ read-only
parent_id INT ✓ read-only
depth INT ✓ read-only
left_bound REAL ✓ read-only
top_bound REAL ✓ read-only
width_bound REAL ✓ read-only
height_bound REAL ✓ read-only
confidence REAL ✓ read-only
sort_order INT ✓ read-only
properties TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_elements_frame_id frame_id SQL 
CREATE INDEX idx_elements_frame_id
ON elements(frame_id)
read-only
idx_elements_frame_src_role
  • frame_id
  • source
  • role
 SQL 
CREATE INDEX idx_elements_frame_src_role
ON elements(frame_id, source, role) WHERE text IS NOT NULL
read-only