Query

ontos.db — document_batch_mappings

SQL

CREATE TABLE document_batch_mappings  (
  id VARCHAR(50) NOT NULL,
  batch_id VARCHAR(50) NOT NULL,
  original_document_id VARCHAR(50),
  original_filename VARCHAR(255),
  start_offset INTEGER,
  end_offset INTEGER,
  sequence_order INTEGER,
  tenant_id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  created_at JSON NOT NULL,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
batch_id VARCHAR(50) Rename | Drop
original_document_id VARCHAR(50) ✓ Rename | Drop
original_filename VARCHAR(255) ✓ Rename | Drop
start_offset INTEGER ✓ Rename | Drop
end_offset INTEGER ✓ Rename | Drop
sequence_order INTEGER ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
project_id VARCHAR(50) ✓ Rename | Drop
created_at JSON Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_document_batch_mappings_1 id ✓ SQL
-- no sql found --
 Drop