DUC SQL Schema Reference — Version 4.0.0

@duc_schema

sq inspect @ 2026-09-27T14:30:46Z

Property	Value
Name	`duc_schema.sqlite`
FQ name	`duc_schema.sqlite.main`
Driver	`sqlite3`
DB product	`SQLite3 v3.53.4`
DB version	`3.53.4`
DB semver	`v3.53.4`
Schema	`main`
Catalog	`default`
Size	`712.0KB`
Tables	`93`
Views	`0`
Location	`sqlite3:///home/runner/work/duc/duc/target/duc_schema.sqlite`

Entity Relationship Diagram

erDiagram
    backgrounds {
        int id PK
        text owner_type
        text owner_id
        int sort_order
        int preference
        text src
        int visible
        float opacity
        float tiling_size_in_percent
        float tiling_angle
        float tiling_spacing
        float tiling_offset_x
        float tiling_offset_y
        int hatch_style
        text hatch_pattern_name
        float hatch_pattern_scale
        float hatch_pattern_angle
        float hatch_pattern_origin_x
        float hatch_pattern_origin_y
        int hatch_pattern_origin_mirror
        int hatch_pattern_double
        text hatch_custom_pattern_name
        text hatch_custom_pattern_desc
        float image_filter_brightness
        float image_filter_contrast
    }
    block_collection_entries {
        text collection_id PK,FK
        text child_id PK
        int is_collection
    }
    block_collections {
        text id PK
        text label
    }
    block_instance_overrides {
        text instance_id PK,FK
        text key PK
        text value
    }
    block_instances {
        text id PK
        text block_id FK
        int version
        int dup_rows
        int dup_cols
        float dup_row_spacing
        float dup_col_spacing
    }
    block_metadata {
        text owner_type PK
        text owner_id PK
        text source
        int usage_count
        int created_at
        int updated_at
        unknown localization
        bytes thumbnail
    }
    blocks {
        text id PK
        text label
        text description
        int version
    }
    checkpoint_data_chunks {
        text checkpoint_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    checkpoints {
        text id PK
        text parent_id
        text chain_id FK
        int version_number
        int schema_version
        int timestamp
        text description
        int is_manual_save
        int is_schema_boundary
        text user_id
        text data_checksum
        text storage_key
        int size_bytes
    }
    delta_changeset_chunks {
        text delta_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    deltas {
        text id PK
        text parent_id
        text base_checkpoint_id FK
        text chain_id FK
        int delta_sequence
        int version_number
        int schema_version
        int timestamp
        text description
        int is_manual_save
        text user_id
        text changeset_checksum
        int size_bytes
    }
    doc_element_referenced_files {
        text element_id PK,FK
        text file_id PK
        int sort_order
    }
    document_dictionary {
        text key PK
        text value
    }
    document_grid_config {
        text element_id PK,FK
        text file_id
        int grid_columns
        float grid_gap_x
        float grid_gap_y
        int grid_first_page_alone
        float grid_scale
    }
    duc_charter {
        int id PK
        text title
        text description
        text objective
        text phase
        text closed_reason
        int updated_at
    }
    duc_charter_constraints {
        text id PK
        text statement
        int hard
        int sort_order
    }
    duc_charter_decision_issue_ids {
        text decision_id PK,FK
        text issue_id
        int sort_order PK
    }
    duc_charter_decisions {
        text id PK
        int accepted
        text decision
        text rationale
        int decided_at
        int sort_order
    }
    duc_charter_requirement_acceptance_criteria {
        text requirement_id PK,FK
        int sort_order PK
        text criterion
    }
    duc_charter_requirements {
        text id PK
        text statement
        int must
        int sort_order
    }
    duc_charter_stakeholders {
        int sort_order PK
        text actor_identifier
        text actor_name
        text role
    }
    duc_document {
        text id PK
        text version
        text source
        text data_type
        bytes thumbnail
    }
    duc_global_state {
        int id PK
        text view_background_color
        text main_scope
        int scope_exponent_threshold
    }
    duc_issue_anchors {
        text issue_id PK,FK
        text anchor_type
        float canvas_x
        float canvas_y
        text canvas_scope
        text element_id
        float anchor_x
        float anchor_y
        float model_point_x
        float model_point_y
        float model_point_z
        float model_normal_x
        float model_normal_y
        float model_normal_z
        text topology_id
    }
    duc_issue_assignees {
        text issue_id PK,FK
        text actor_identifier PK
        int sort_order
    }
    duc_issue_followers {
        text issue_id PK,FK
        text actor_identifier PK
        int sort_order
    }
    duc_issue_message_reactions {
        text message_id PK,FK
        text emoji PK
        text actor_identifier PK
        int sort_order
    }
    duc_issue_messages {
        text id PK
        text issue_id FK
        text author_identifier
        text author_name
        text content
        text reply_to_id
        int created_at
        int edited_at
        int deleted_at
        int sort_order
    }
    duc_issues {
        text id PK
        int local_id
        text title
        text status
        text dismissed_reason
        int due_date
        text author_id
        int created_at
        int updated_at
        int deleted_at
        int sort_order
    }
    duc_local_state {
        int id PK
        text scope
        float scroll_x
        float scroll_y
        float zoom
        int is_binding_enabled
        float current_item_opacity
        text current_item_font_family
        float current_item_font_size
        int current_item_text_align
        float current_item_roundness
        int start_head_type
        text start_head_block_id
        float start_head_size
        int end_head_type
        text end_head_block_id
        float end_head_size
        int pen_mode
        int view_mode_enabled
        int objects_snap_mode_enabled
        int grid_mode_enabled
        int outline_mode_enabled
        int manual_save_mode
        int decimal_places
    }
    element_block_memberships {
        text element_id PK,FK
        text block_id PK,FK
        int sort_order
    }
    element_bound_elements {
        text element_id PK,FK
        text bound_element_id PK
        text bound_type
        int sort_order
    }
    element_doc {
        text element_id PK,FK
        text text
    }
    element_ellipse {
        text element_id PK,FK
        float ratio
        float start_angle
        float end_angle
        int show_aux_crosshair
    }
    element_embeddable {
        text element_id PK,FK
    }
    element_frame {
        text element_id PK,FK
    }
    element_freedraw {
        text element_id PK,FK
        float size
        float thinning
        float smoothing
        float streamline
        text easing
        int start_cap
        float start_taper
        text start_easing
        int end_cap
        float end_taper
        text end_easing
        bytes pressures
        int simulate_pressure
        float last_committed_point_x
        float last_committed_point_y
        int last_committed_point_mirror
        text svg_path
    }
    element_group_memberships {
        text element_id PK,FK
        text group_id PK,FK
        int sort_order
    }
    element_image {
        text element_id PK,FK
        text file_id
        int status
        float scale_x
        float scale_y
        float crop_x
        float crop_y
        float crop_width
        float crop_height
        float crop_natural_width
        float crop_natural_height
        float filter_brightness
        float filter_contrast
    }
    element_linear {
        text element_id PK,FK
        float last_committed_point_x
        float last_committed_point_y
        int last_committed_point_mirror
        text start_binding_element_id
        float start_binding_focus
        float start_binding_gap
        float start_binding_fixed_point_x
        float start_binding_fixed_point_y
        int start_binding_point_index
        float start_binding_point_offset
        int start_binding_head_type
        text start_binding_head_block_id
        float start_binding_head_size
        text end_binding_element_id
        float end_binding_focus
        float end_binding_gap
        float end_binding_fixed_point_x
        float end_binding_fixed_point_y
        int end_binding_point_index
        float end_binding_point_offset
        int end_binding_head_type
        text end_binding_head_block_id
        float end_binding_head_size
        int wipeout_below
        int elbowed
    }
    element_model {
        text element_id PK,FK
        text model_type
        text code
        bytes thumbnail
    }
    element_pdf {
        text element_id PK,FK
    }
    element_plot {
        text element_id PK,FK
        float margin_top
        float margin_right
        float margin_bottom
        float margin_left
    }
    element_polygon {
        text element_id PK,FK
        int sides
    }
    element_region_memberships {
        text element_id PK,FK
        text region_id PK,FK
        int sort_order
    }
    element_stack_properties {
        text element_id PK,FK
        text label
        text description
        int is_collapsed
        int is_plot
        int is_visible
        int locked
        float opacity
        int clip
        int label_visible
    }
    element_table {
        text element_id PK,FK
    }
    element_text {
        text element_id PK,FK
        text text
        text original_text
        int auto_resize
        text container_id
        int is_ltr
        text font_family
        text big_font_family
        int text_align
        int vertical_align
        float line_height
        float line_spacing_value
        int line_spacing_type
        float oblique_angle
        float font_size
        float width_factor
        int is_upside_down
        int is_backwards
    }
    elements {
        text id PK
        text element_type
        float x
        float y
        float width
        float height
        float angle
        text scope
        text label
        text description
        int is_visible
        int seed
        int version
        int version_nonce
        int updated
        text index
        int is_plot
        int is_deleted
        float roundness
        int blending
        float opacity
        text instance_id FK
        text layer_id FK
        text frame_id
        float z_index
        text link
        int locked
        unknown custom_data
    }
    external_file_revision_chunks {
        text revision_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    external_file_revisions {
        text id PK
        text file_id FK
        int size_bytes
        text checksum
        text source_name
        text mime_type
        text message
        int created
        int last_retrieved
    }
    external_file_text_index {
        int id PK
        text file_id
        text revision_id
        text mime_type
        text extracted_text
        int has_ocr
        int updated
    }
    external_files {
        text id PK
        text active_revision_id
        int updated
        int version
    }
    freedraw_element_points {
        text element_id PK,FK
        int sort_order PK
        float x
        float y
        int mirroring
    }
    groups {
        text id PK,FK
    }
    hatch_pattern_lines {
        int id PK
        text owner_type
        int owner_id
        int sort_order
        float angle
        float origin_x
        float origin_y
        int origin_mirroring
        float offset_x
        float offset_y
        bytes dash_pattern
    }
    layers {
        text id PK,FK
        int readonly
    }
    linear_element_lines {
        text element_id PK,FK
        int sort_order PK
        int start_index
        float start_handle_x
        float start_handle_y
        int end_index
        float end_handle_x
        float end_handle_y
    }
    linear_element_points {
        text element_id PK,FK
        int sort_order PK
        float x
        float y
        int mirroring
    }
    linear_path_override_indices {
        int path_override_id PK,FK
        int sort_order PK
        int line_index
    }
    linear_path_overrides {
        int id PK
        text element_id FK
        int sort_order
    }
    model_element_files {
        text element_id PK,FK
        text file_id PK
        int sort_order
    }
    model_viewer_state {
        text owner_type PK
        text owner_id PK
        text camera_control
        int camera_ortho
        text camera_up
        float camera_position_x
        float camera_position_y
        float camera_position_z
        float camera_quaternion_x
        float camera_quaternion_y
        float camera_quaternion_z
        float camera_quaternion_w
        float camera_target_x
        float camera_target_y
        float camera_target_z
        float camera_zoom
        float camera_pan_speed
        float camera_rotate_speed
        float camera_zoom_speed
        int camera_holroyd
        int display_wireframe
        int display_transparent
        int display_black_edges
        int display_grid_uniform
        int display_grid_xy
        int display_grid_xz
        int display_grid_yz
        int display_axes_visible
        int display_axes_at_origin
        float material_metalness
        float material_roughness
        float material_default_opacity
        int material_edge_color
        float material_ambient_intensity
        float material_direct_intensity
        int clip_x_enabled
        float clip_x_value
        float clip_x_normal_x
        float clip_x_normal_y
        float clip_x_normal_z
        int clip_y_enabled
        float clip_y_value
        float clip_y_normal_x
        float clip_y_normal_y
        float clip_y_normal_z
        int clip_z_enabled
        float clip_z_value
        float clip_z_normal_x
        float clip_z_normal_y
        float clip_z_normal_z
        int clip_intersection
        int clip_show_planes
        int clip_object_color_caps
        int explode_active
        float explode_value
        int zebra_active
        int zebra_stripe_count
        float zebra_stripe_direction
        text zebra_color_scheme
        float zebra_opacity
        text zebra_mapping_mode
    }
    regions {
        text id PK,FK
        int boolean_operation
    }
    schema_migrations {
        int id PK
        int from_schema_version
        int to_schema_version
        text migration_name
        text migration_sql
        text reverse_migration_sql
        text migration_checksum
        int applied_at
        text boundary_checkpoint_id
    }
    search_blocks_config {
        text k PK
        int v
    }
    search_blocks_data {
        int id PK
        bytes block
    }
    search_blocks_docsize {
        int id PK
        bytes sz
    }
    search_blocks_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    search_element_doc_config {
        text k PK
        int v
    }
    search_element_doc_data {
        int id PK
        bytes block
    }
    search_element_doc_docsize {
        int id PK
        bytes sz
    }
    search_element_doc_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    search_element_model_config {
        text k PK
        int v
    }
    search_element_model_data {
        int id PK
        bytes block
    }
    search_element_model_docsize {
        int id PK
        bytes sz
    }
    search_element_model_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    search_element_text_config {
        text k PK
        int v
    }
    search_element_text_data {
        int id PK
        bytes block
    }
    search_element_text_docsize {
        int id PK
        bytes sz
    }
    search_element_text_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    search_elements_config {
        text k PK
        int v
    }
    search_elements_data {
        int id PK
        bytes block
    }
    search_elements_docsize {
        int id PK
        bytes sz
    }
    search_elements_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    search_external_file_text_config {
        text k PK
        int v
    }
    search_external_file_text_data {
        int id PK
        bytes block
    }
    search_external_file_text_docsize {
        int id PK
        bytes sz
    }
    search_external_file_text_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }
    stack_properties {
        text id PK
        text label
        text description
        int is_collapsed
        int is_plot
        int is_visible
        int locked
        float opacity
    }
    strokes {
        int id PK
        text owner_type
        text owner_id
        int sort_order
        int preference
        text src
        int visible
        float opacity
        float tiling_size_in_percent
        float tiling_angle
        float tiling_spacing
        float tiling_offset_x
        float tiling_offset_y
        int hatch_style
        text hatch_pattern_name
        float hatch_pattern_scale
        float hatch_pattern_angle
        float hatch_pattern_origin_x
        float hatch_pattern_origin_y
        int hatch_pattern_origin_mirror
        int hatch_pattern_double
        text hatch_custom_pattern_name
        text hatch_custom_pattern_desc
        float image_filter_brightness
        float image_filter_contrast
        float width
        int style_preference
        int style_cap
        int style_join
        bytes style_dash
        text style_dash_line_override
        int style_dash_cap
        float style_miter_limit
        int placement
        int sides_preference
        bytes sides_values
    }
    version_chains {
        text id PK
        int schema_version
        int start_version
        int end_version
        int migration_id FK
        text root_checkpoint_id
    }
    version_graph {
        int id PK
        int current_version
        int current_schema_version
        text user_checkpoint_version_id
        text latest_version_id
        int chain_count
        int total_size
    }
    search_blocks {
        bytes label
        bytes description
    }
    search_element_doc {
        bytes text
    }
    search_element_model {
        bytes code
    }
    search_element_text {
        bytes text
        bytes original_text
    }
    search_elements {
        bytes label
        bytes description
    }
    search_external_file_text {
        bytes extracted_text
    }
    block_collections ||--o{ block_collection_entries : ""
    block_instances ||--o{ block_instance_overrides : ""
    blocks ||--o{ block_instances : ""
    checkpoints ||--o{ checkpoint_data_chunks : ""
    version_chains ||--o{ checkpoints : ""
    deltas ||--o{ delta_changeset_chunks : ""
    checkpoints ||--o{ deltas : ""
    version_chains ||--o{ deltas : ""
    element_doc ||--o{ doc_element_referenced_files : ""
    elements ||--|| document_grid_config : ""
    duc_charter_decisions ||--o{ duc_charter_decision_issue_ids : ""
    duc_charter_requirements ||--o{ duc_charter_requirement_acceptance_criteria : ""
    duc_issues ||--|| duc_issue_anchors : ""
    duc_issues ||--o{ duc_issue_assignees : ""
    duc_issues ||--o{ duc_issue_followers : ""
    duc_issue_messages ||--o{ duc_issue_message_reactions : ""
    duc_issues ||--o{ duc_issue_messages : ""
    blocks ||--o{ element_block_memberships : ""
    elements ||--o{ element_block_memberships : ""
    elements ||--o{ element_bound_elements : ""
    document_grid_config |o--|| element_doc : ""
    elements ||--|| element_ellipse : ""
    elements ||--|| element_embeddable : ""
    element_stack_properties ||--|| element_frame : ""
    elements ||--|| element_freedraw : ""
    elements ||--o{ element_group_memberships : ""
    groups ||--o{ element_group_memberships : ""
    elements ||--|| element_image : ""
    elements ||--|| element_linear : ""
    elements |o--|| element_model : ""
    document_grid_config ||--|| element_pdf : ""
    element_stack_properties ||--|| element_plot : ""
    elements ||--|| element_polygon : ""
    elements ||--o{ element_region_memberships : ""
    regions ||--o{ element_region_memberships : ""
    elements ||--|| element_stack_properties : ""
    document_grid_config ||--|| element_table : ""
    elements |o--|| element_text : ""
    block_instances |o--o{ elements : ""
    layers |o--o{ elements : ""
    external_file_revisions ||--o{ external_file_revision_chunks : ""
    external_files ||--o{ external_file_revisions : ""
    elements ||--o{ freedraw_element_points : ""
    stack_properties ||--|| groups : ""
    stack_properties ||--|| layers : ""
    elements ||--o{ linear_element_lines : ""
    elements ||--o{ linear_element_points : ""
    linear_path_overrides ||--o{ linear_path_override_indices : ""
    elements ||--o{ linear_path_overrides : ""
    elements ||--o{ model_element_files : ""
    stack_properties ||--|| regions : ""
    schema_migrations |o--o{ version_chains : ""

Tables

`backgrounds`

table · 0 rows

Entity Relationship Diagram

erDiagram
    backgrounds {
        int id PK
        text owner_type
        text owner_id
        int sort_order
        int preference
        text src
        int visible
        float opacity
        float tiling_size_in_percent
        float tiling_angle
        float tiling_spacing
        float tiling_offset_x
        float tiling_offset_y
        int hatch_style
        text hatch_pattern_name
        float hatch_pattern_scale
        float hatch_pattern_angle
        float hatch_pattern_origin_x
        float hatch_pattern_origin_y
        int hatch_pattern_origin_mirror
        int hatch_pattern_double
        text hatch_custom_pattern_name
        text hatch_custom_pattern_desc
        float image_filter_brightness
        float image_filter_contrast
    }

Columns
Column	Type	Nullable	PK	Auto	Default
`id`	`INTEGER`	✓	✓	auto_inc
`owner_type`	`TEXT`
`owner_id`	`TEXT`
`sort_order`	`INTEGER`				`0`
`preference`	`INTEGER`	✓
`src`	`TEXT`				`''`
`visible`	`INTEGER`				`1`
`opacity`	`REAL`				`1.0`
`tiling_size_in_percent`	`REAL`	✓
`tiling_angle`	`REAL`	✓
`tiling_spacing`	`REAL`	✓
`tiling_offset_x`	`REAL`	✓
`tiling_offset_y`	`REAL`	✓
`hatch_style`	`INTEGER`	✓
`hatch_pattern_name`	`TEXT`	✓
`hatch_pattern_scale`	`REAL`	✓
`hatch_pattern_angle`	`REAL`	✓
`hatch_pattern_origin_x`	`REAL`	✓
`hatch_pattern_origin_y`	`REAL`	✓
`hatch_pattern_origin_mirror`	`INTEGER`	✓
`hatch_pattern_double`	`INTEGER`	✓
`hatch_custom_pattern_name`	`TEXT`	✓
`hatch_custom_pattern_desc`	`TEXT`	✓
`image_filter_brightness`	`REAL`	✓
`image_filter_contrast`	`REAL`	✓

Indexes
Index	Columns	Unique	Primary	Type
`idx_backgrounds_owner`	`owner_type, owner_id`
`idx_backgrounds_src`	`src`

`block_collection_entries`

table · 0 rows

Entity Relationship Diagram

erDiagram
    block_collection_entries {
        text collection_id PK,FK
        text child_id PK
        int is_collection
    }
    block_collections ||--o{ block_collection_entries : ""

Columns
Column	Type	PK	FK	Default
`collection_id`	`TEXT`	✓	✓
`child_id`	`TEXT`	✓
`is_collection`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`collection_id` → `block_collections.id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_block_collection_entries_child`	`child_id`
`sqlite_autoindex_block_collection_entries_1`	`collection_id, child_id`	✓	✓

`block_collections`

table · 0 rows

Entity Relationship Diagram

erDiagram
    block_collections {
        text id PK
        text label
    }
    block_collections ||--o{ block_collection_entries : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`label`	`TEXT`				`''`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `block_collection_entries.collection_id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_block_collections_label`	`label`
`sqlite_autoindex_block_collections_1`	`id`	✓	✓

`block_instance_overrides`

table · 0 rows

Entity Relationship Diagram

erDiagram
    block_instance_overrides {
        text instance_id PK,FK
        text key PK
        text value
    }
    block_instances ||--o{ block_instance_overrides : ""

Columns
Column	Type	PK	FK
`instance_id`	`TEXT`	✓	✓
`key`	`TEXT`	✓
`value`	`TEXT`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`instance_id` → `block_instances.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_block_instance_overrides_1`	`instance_id, key`	✓	✓

`block_instances`

table · 0 rows

Entity Relationship Diagram

erDiagram
    block_instances {
        text id PK
        text block_id FK
        int version
        int dup_rows
        int dup_cols
        float dup_row_spacing
        float dup_col_spacing
    }
    block_instances ||--o{ block_instance_overrides : ""
    blocks ||--o{ block_instances : ""
    block_instances |o--o{ elements : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`block_id`	`TEXT`			✓
`version`	`INTEGER`				`1`
`dup_rows`	`INTEGER`	✓
`dup_cols`	`INTEGER`	✓
`dup_row_spacing`	`REAL`	✓
`dup_col_spacing`	`REAL`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`block_id` → `blocks.id`
`id` ← `block_instance_overrides.instance_id`			cascade
`id` ← `elements.instance_id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_block_instances_block`	`block_id`
`sqlite_autoindex_block_instances_1`	`id`	✓	✓

`block_metadata`

table · 0 rows

Entity Relationship Diagram

erDiagram
    block_metadata {
        text owner_type PK
        text owner_id PK
        text source
        int usage_count
        int created_at
        int updated_at
        unknown localization
        bytes thumbnail
    }

Columns
Column	Type	Nullable	PK	Default
`owner_type`	`TEXT`		✓
`owner_id`	`TEXT`		✓
`source`	`TEXT`	✓
`usage_count`	`INTEGER`			`0`
`created_at`	`INTEGER`
`updated_at`	`INTEGER`
`localization`	`JSONB`	✓
`thumbnail`	`BLOB`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_block_metadata_1`	`owner_type, owner_id`	✓	✓

`blocks`

table · 0 rows

Entity Relationship Diagram

erDiagram
    blocks {
        text id PK
        text label
        text description
        int version
    }
    blocks ||--o{ block_instances : ""
    blocks ||--o{ element_block_memberships : ""

Columns
Column	Type	Nullable	PK	Default
`id`	`TEXT`	✓	✓
`label`	`TEXT`			`''`
`description`	`TEXT`	✓
`version`	`INTEGER`			`1`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `block_instances.block_id`
`id` ← `element_block_memberships.block_id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_blocks_label`	`label`
`sqlite_autoindex_blocks_1`	`id`	✓	✓

Triggers
Trigger	Timing	Events	Definition
`trg_blocks_ad`	AFTER	DELETE	`CREATE TRIGGER trg_blocks_ad AFTER DELETE ON blocks BEGIN INSERT INTO search_blocks(search_blocks, rowid, label, description) VALUES ('delete', OLD.rowid, OLD.label, OLD.description); END`
`trg_blocks_ai`	AFTER	INSERT	`CREATE TRIGGER trg_blocks_ai AFTER INSERT ON blocks BEGIN INSERT INTO search_blocks(rowid, label, description) VALUES (NEW.rowid, NEW.label, NEW.description); END`
`trg_blocks_au`	AFTER	UPDATE	`CREATE TRIGGER trg_blocks_au AFTER UPDATE OF label, description ON blocks BEGIN INSERT INTO search_blocks(search_blocks, rowid, label, description) VALUES ('delete', OLD.rowid, OLD.label, OLD.description); INSERT INTO search_blocks(rowid, label, description) VALUES (NEW.rowid, NEW.label, NEW.description); END`

`checkpoint_data_chunks`

table · 0 rows

Entity Relationship Diagram

erDiagram
    checkpoint_data_chunks {
        text checkpoint_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    checkpoints ||--o{ checkpoint_data_chunks : ""

Columns
Column	Type	PK	FK
`checkpoint_id`	`TEXT`	✓	✓
`chunk_index`	`INTEGER`	✓
`offset_bytes`	`INTEGER`
`size_bytes`	`INTEGER`
`data`	`BLOB`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`checkpoint_id` → `checkpoints.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_checkpoint_data_chunks_checkpoint_offset`	`checkpoint_id, offset_bytes`
`sqlite_autoindex_checkpoint_data_chunks_1`	`checkpoint_id, chunk_index`	✓	✓

Check constraints
Constraint	Clause
	chunk_index >= 0
	offset_bytes >= 0
	size_bytes >= 0

`checkpoints`

table · 0 rows

Entity Relationship Diagram

erDiagram
    checkpoints {
        text id PK
        text parent_id
        text chain_id FK
        int version_number
        int schema_version
        int timestamp
        text description
        int is_manual_save
        int is_schema_boundary
        text user_id
        text data_checksum
        text storage_key
        int size_bytes
    }
    checkpoints ||--o{ checkpoint_data_chunks : ""
    version_chains ||--o{ checkpoints : ""
    checkpoints ||--o{ deltas : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`parent_id`	`TEXT`	✓
`chain_id`	`TEXT`			✓
`version_number`	`INTEGER`
`schema_version`	`INTEGER`
`timestamp`	`INTEGER`
`description`	`TEXT`	✓
`is_manual_save`	`INTEGER`				`0`
`is_schema_boundary`	`INTEGER`				`0`
`user_id`	`TEXT`	✓
`data_checksum`	`TEXT`	✓
`storage_key`	`TEXT`	✓
`size_bytes`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`chain_id` → `version_chains.id`
`id` ← `checkpoint_data_chunks.checkpoint_id`			cascade
`id` ← `deltas.base_checkpoint_id`

Unique constraints
Constraint	Columns
`sqlite_autoindex_checkpoints_2`	`version_number`

Indexes
Index	Columns	Unique	Primary
`idx_checkpoints_boundary`	`is_schema_boundary`
`idx_checkpoints_chain`	`chain_id, version_number`
`idx_checkpoints_parent`	`parent_id`
`idx_checkpoints_schema_version`	`schema_version, version_number`
`sqlite_autoindex_checkpoints_1`	`id`	✓	✓
`sqlite_autoindex_checkpoints_2`	`version_number`	✓

Check constraints
Constraint	Clause
	schema_version >= 1
	is_schema_boundary IN (0, 1)

`delta_changeset_chunks`

table · 0 rows

Entity Relationship Diagram

erDiagram
    delta_changeset_chunks {
        text delta_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    deltas ||--o{ delta_changeset_chunks : ""

Columns
Column	Type	PK	FK
`delta_id`	`TEXT`	✓	✓
`chunk_index`	`INTEGER`	✓
`offset_bytes`	`INTEGER`
`size_bytes`	`INTEGER`
`data`	`BLOB`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`delta_id` → `deltas.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_delta_changeset_chunks_delta_offset`	`delta_id, offset_bytes`
`sqlite_autoindex_delta_changeset_chunks_1`	`delta_id, chunk_index`	✓	✓

Check constraints
Constraint	Clause
	chunk_index >= 0
	offset_bytes >= 0
	size_bytes >= 0

`deltas`

table · 0 rows

Entity Relationship Diagram

erDiagram
    deltas {
        text id PK
        text parent_id
        text base_checkpoint_id FK
        text chain_id FK
        int delta_sequence
        int version_number
        int schema_version
        int timestamp
        text description
        int is_manual_save
        text user_id
        text changeset_checksum
        int size_bytes
    }
    deltas ||--o{ delta_changeset_chunks : ""
    checkpoints ||--o{ deltas : ""
    version_chains ||--o{ deltas : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`parent_id`	`TEXT`	✓
`base_checkpoint_id`	`TEXT`			✓
`chain_id`	`TEXT`			✓
`delta_sequence`	`INTEGER`
`version_number`	`INTEGER`
`schema_version`	`INTEGER`
`timestamp`	`INTEGER`
`description`	`TEXT`	✓
`is_manual_save`	`INTEGER`				`0`
`user_id`	`TEXT`	✓
`changeset_checksum`	`TEXT`	✓
`size_bytes`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`base_checkpoint_id` → `checkpoints.id`
`chain_id` → `version_chains.id`
`id` ← `delta_changeset_chunks.delta_id`			cascade

Unique constraints
Constraint	Columns
`sqlite_autoindex_deltas_2`	`version_number`

Indexes
Index	Columns	Unique	Primary
`idx_deltas_base_checkpoint`	`base_checkpoint_id, delta_sequence`
`idx_deltas_chain`	`chain_id, version_number`
`idx_deltas_parent`	`parent_id`
`idx_deltas_schema_version`	`schema_version, version_number`
`sqlite_autoindex_deltas_1`	`id`	✓	✓
`sqlite_autoindex_deltas_2`	`version_number`	✓

Check constraints
Constraint	Clause
	schema_version >= 1
	delta_sequence >= 1

`doc_element_referenced_files`

table · 0 rows

Entity Relationship Diagram

erDiagram
    doc_element_referenced_files {
        text element_id PK,FK
        text file_id PK
        int sort_order
    }
    element_doc ||--o{ doc_element_referenced_files : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`file_id`	`TEXT`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `element_doc.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_doc_referenced_files_file`	`file_id`
`sqlite_autoindex_doc_element_referenced_files_1`	`element_id, file_id`	✓	✓

`document_dictionary`

table · 0 rows

Entity Relationship Diagram

erDiagram
    document_dictionary {
        text key PK
        text value
    }

Columns
Column	Type	Nullable	PK	FK
`key`	`TEXT`		✓
`value`	`TEXT`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_document_dictionary_1`	`key`	✓	✓

`document_grid_config`

table · 0 rows

Entity Relationship Diagram

erDiagram
    document_grid_config {
        text element_id PK,FK
        text file_id
        int grid_columns
        float grid_gap_x
        float grid_gap_y
        int grid_first_page_alone
        float grid_scale
    }
    elements ||--|| document_grid_config : ""
    document_grid_config |o--|| element_doc : ""
    document_grid_config ||--|| element_pdf : ""
    document_grid_config ||--|| element_table : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`file_id`	`TEXT`	✓
`grid_columns`	`INTEGER`				`1`
`grid_gap_x`	`REAL`				`0.0`
`grid_gap_y`	`REAL`				`0.0`
`grid_first_page_alone`	`INTEGER`				`0`
`grid_scale`	`REAL`				`1.0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade
`element_id` ← `element_doc.element_id`			cascade
`element_id` ← `element_pdf.element_id`			cascade
`element_id` ← `element_table.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_doc_grid_config_file`	`file_id`
`sqlite_autoindex_document_grid_config_1`	`element_id`	✓	✓

`duc_charter`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter {
        int id PK
        text title
        text description
        text objective
        text phase
        text closed_reason
        int updated_at
    }

Columns
Column	Type	Nullable	PK	Default
`id`	`INTEGER`	✓	✓
`title`	`TEXT`			`''`
`description`	`TEXT`	✓
`objective`	`TEXT`			`''`
`phase`	`TEXT`			`'intent'`
`closed_reason`	`TEXT`	✓
`updated_at`	`INTEGER`			`0`

Check constraints
Constraint	Clause
	id = 1
	phase IN ('intent', 'review', 'delivery', 'closed')

`duc_charter_constraints`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_constraints {
        text id PK
        text statement
        int hard
        int sort_order
    }

Columns
Column	Type	PK	Default
`id`	`TEXT`	✓
`statement`	`TEXT`
`hard`	`INTEGER`		`1`
`sort_order`	`INTEGER`		`0`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_charter_constraints_1`	`id`	✓	✓

`duc_charter_decision_issue_ids`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_decision_issue_ids {
        text decision_id PK,FK
        text issue_id
        int sort_order PK
    }
    duc_charter_decisions ||--o{ duc_charter_decision_issue_ids : ""

Columns
Column	Type	PK	FK	Default
`decision_id`	`TEXT`	✓	✓
`issue_id`	`TEXT`
`sort_order`	`INTEGER`	✓		`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`decision_id` → `duc_charter_decisions.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_charter_decision_issue_ids_1`	`decision_id, sort_order`	✓	✓

`duc_charter_decisions`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_decisions {
        text id PK
        int accepted
        text decision
        text rationale
        int decided_at
        int sort_order
    }
    duc_charter_decisions ||--o{ duc_charter_decision_issue_ids : ""

Columns
Column	Type	PK	Default
`id`	`TEXT`	✓
`accepted`	`INTEGER`		`1`
`decision`	`TEXT`
`rationale`	`TEXT`
`decided_at`	`INTEGER`		`0`
`sort_order`	`INTEGER`		`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `duc_charter_decision_issue_ids.decision_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_charter_decisions_1`	`id`	✓	✓

`duc_charter_requirement_acceptance_criteria`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_requirement_acceptance_criteria {
        text requirement_id PK,FK
        int sort_order PK
        text criterion
    }
    duc_charter_requirements ||--o{ duc_charter_requirement_acceptance_criteria : ""

Columns
Column	Type	PK	FK	Default
`requirement_id`	`TEXT`	✓	✓
`sort_order`	`INTEGER`	✓		`0`
`criterion`	`TEXT`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`requirement_id` → `duc_charter_requirements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_charter_requirement_acceptance_criteria_1`	`requirement_id, sort_order`	✓	✓

`duc_charter_requirements`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_requirements {
        text id PK
        text statement
        int must
        int sort_order
    }
    duc_charter_requirements ||--o{ duc_charter_requirement_acceptance_criteria : ""

Columns
Column	Type	PK	Default
`id`	`TEXT`	✓
`statement`	`TEXT`
`must`	`INTEGER`		`1`
`sort_order`	`INTEGER`		`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `duc_charter_requirement_acceptance_criteria.requirement_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_charter_requirements_1`	`id`	✓	✓

`duc_charter_stakeholders`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_charter_stakeholders {
        int sort_order PK
        text actor_identifier
        text actor_name
        text role
    }

Columns
Column	Type	Nullable	PK
`sort_order`	`INTEGER`	✓	✓
`actor_identifier`	`TEXT`
`actor_name`	`TEXT`	✓
`role`	`TEXT`

`duc_document`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_document {
        text id PK
        text version
        text source
        text data_type
        bytes thumbnail
    }

Columns
Column	Type	Nullable	PK
`id`	`TEXT`		✓
`version`	`TEXT`
`source`	`TEXT`
`data_type`	`TEXT`
`thumbnail`	`BLOB`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_document_1`	`id`	✓	✓

`duc_global_state`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_global_state {
        int id PK
        text view_background_color
        text main_scope
        int scope_exponent_threshold
    }

Columns
Column	Type	Nullable	PK	Default
`id`	`INTEGER`	✓	✓
`view_background_color`	`TEXT`
`main_scope`	`TEXT`
`scope_exponent_threshold`	`INTEGER`			`3`

Check constraints
Constraint	Clause
	id = 1

`duc_issue_anchors`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issue_anchors {
        text issue_id PK,FK
        text anchor_type
        float canvas_x
        float canvas_y
        text canvas_scope
        text element_id
        float anchor_x
        float anchor_y
        float model_point_x
        float model_point_y
        float model_point_z
        float model_normal_x
        float model_normal_y
        float model_normal_z
        text topology_id
    }
    duc_issues ||--|| duc_issue_anchors : ""

Columns
Column	Type	Nullable	PK	FK
`issue_id`	`TEXT`		✓	✓
`anchor_type`	`TEXT`
`canvas_x`	`REAL`	✓
`canvas_y`	`REAL`	✓
`canvas_scope`	`TEXT`	✓
`element_id`	`TEXT`	✓
`anchor_x`	`REAL`	✓
`anchor_y`	`REAL`	✓
`model_point_x`	`REAL`	✓
`model_point_y`	`REAL`	✓
`model_point_z`	`REAL`	✓
`model_normal_x`	`REAL`	✓
`model_normal_y`	`REAL`	✓
`model_normal_z`	`REAL`	✓
`topology_id`	`TEXT`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`issue_id` → `duc_issues.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_issue_anchors_1`	`issue_id`	✓	✓

Check constraints
Constraint	Clause
	anchor_type IN ('canvas', 'element', 'model')

Triggers
Trigger	Timing	Events	Definition
`model_viewer_state_delete_issue_anchor`	AFTER	DELETE	`CREATE TRIGGER model_viewer_state_delete_issue_anchor AFTER DELETE ON duc_issue_anchors BEGIN DELETE FROM model_viewer_state WHERE owner_type = 'issue_anchor' AND owner_id = OLD.issue_id; END`

`duc_issue_assignees`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issue_assignees {
        text issue_id PK,FK
        text actor_identifier PK
        int sort_order
    }
    duc_issues ||--o{ duc_issue_assignees : ""

Columns
Column	Type	PK	FK	Default
`issue_id`	`TEXT`	✓	✓
`actor_identifier`	`TEXT`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`issue_id` → `duc_issues.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_issue_assignees_1`	`issue_id, actor_identifier`	✓	✓

`duc_issue_followers`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issue_followers {
        text issue_id PK,FK
        text actor_identifier PK
        int sort_order
    }
    duc_issues ||--o{ duc_issue_followers : ""

Columns
Column	Type	PK	FK	Default
`issue_id`	`TEXT`	✓	✓
`actor_identifier`	`TEXT`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`issue_id` → `duc_issues.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_issue_followers_1`	`issue_id, actor_identifier`	✓	✓

`duc_issue_message_reactions`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issue_message_reactions {
        text message_id PK,FK
        text emoji PK
        text actor_identifier PK
        int sort_order
    }
    duc_issue_messages ||--o{ duc_issue_message_reactions : ""

Columns
Column	Type	PK	FK	Default
`message_id`	`TEXT`	✓	✓
`emoji`	`TEXT`	✓
`actor_identifier`	`TEXT`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`message_id` → `duc_issue_messages.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_duc_issue_message_reactions_1`	`message_id, emoji, actor_identifier`	✓	✓

`duc_issue_messages`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issue_messages {
        text id PK
        text issue_id FK
        text author_identifier
        text author_name
        text content
        text reply_to_id
        int created_at
        int edited_at
        int deleted_at
        int sort_order
    }
    duc_issue_messages ||--o{ duc_issue_message_reactions : ""
    duc_issues ||--o{ duc_issue_messages : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`issue_id`	`TEXT`			✓
`author_identifier`	`TEXT`
`author_name`	`TEXT`	✓
`content`	`TEXT`
`reply_to_id`	`TEXT`	✓
`created_at`	`INTEGER`
`edited_at`	`INTEGER`	✓
`deleted_at`	`INTEGER`	✓
`sort_order`	`INTEGER`				`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`issue_id` → `duc_issues.id`			cascade
`id` ← `duc_issue_message_reactions.message_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_duc_issue_messages_issue`	`issue_id, sort_order`
`sqlite_autoindex_duc_issue_messages_1`	`id`	✓	✓

`duc_issues`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_issues {
        text id PK
        int local_id
        text title
        text status
        text dismissed_reason
        int due_date
        text author_id
        int created_at
        int updated_at
        int deleted_at
        int sort_order
    }
    duc_issues ||--|| duc_issue_anchors : ""
    duc_issues ||--o{ duc_issue_assignees : ""
    duc_issues ||--o{ duc_issue_followers : ""
    duc_issues ||--o{ duc_issue_messages : ""

Columns
Column	Type	Nullable	PK	Default
`id`	`TEXT`		✓
`local_id`	`INTEGER`
`title`	`TEXT`
`status`	`TEXT`
`dismissed_reason`	`TEXT`	✓
`due_date`	`INTEGER`	✓
`author_id`	`TEXT`
`created_at`	`INTEGER`
`updated_at`	`INTEGER`
`deleted_at`	`INTEGER`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `duc_issue_anchors.issue_id`			cascade
`id` ← `duc_issue_assignees.issue_id`			cascade
`id` ← `duc_issue_followers.issue_id`			cascade
`id` ← `duc_issue_messages.issue_id`			cascade

Indexes
Index	Columns	Unique	Primary
`idx_duc_issues_local_id`	`local_id`	✓
`idx_duc_issues_status`	`status`
`idx_duc_issues_updated`	`updated_at`
`sqlite_autoindex_duc_issues_1`	`id`	✓	✓

Check constraints
Constraint	Clause
	status IN ('open', 'closed', 'dismissed')

`duc_local_state`

table · 0 rows

Entity Relationship Diagram

erDiagram
    duc_local_state {
        int id PK
        text scope
        float scroll_x
        float scroll_y
        float zoom
        int is_binding_enabled
        float current_item_opacity
        text current_item_font_family
        float current_item_font_size
        int current_item_text_align
        float current_item_roundness
        int start_head_type
        text start_head_block_id
        float start_head_size
        int end_head_type
        text end_head_block_id
        float end_head_size
        int pen_mode
        int view_mode_enabled
        int objects_snap_mode_enabled
        int grid_mode_enabled
        int outline_mode_enabled
        int manual_save_mode
        int decimal_places
    }

Columns
Column	Type	Nullable	PK	Default
`id`	`INTEGER`	✓	✓
`scope`	`TEXT`			`'mm'`
`scroll_x`	`REAL`			`0.0`
`scroll_y`	`REAL`			`0.0`
`zoom`	`REAL`			`1.0`
`is_binding_enabled`	`INTEGER`			`1`
`current_item_opacity`	`REAL`			`1.0`
`current_item_font_family`	`TEXT`			`'Roboto Mono'`
`current_item_font_size`	`REAL`			`20.0`
`current_item_text_align`	`INTEGER`			`10`
`current_item_roundness`	`REAL`			`0.0`
`start_head_type`	`INTEGER`	✓
`start_head_block_id`	`TEXT`	✓
`start_head_size`	`REAL`	✓
`end_head_type`	`INTEGER`	✓
`end_head_block_id`	`TEXT`	✓
`end_head_size`	`REAL`	✓
`pen_mode`	`INTEGER`			`0`
`view_mode_enabled`	`INTEGER`			`0`
`objects_snap_mode_enabled`	`INTEGER`			`1`
`grid_mode_enabled`	`INTEGER`			`1`
`outline_mode_enabled`	`INTEGER`			`0`
`manual_save_mode`	`INTEGER`			`0`
`decimal_places`	`INTEGER`			`2`

Check constraints
Constraint	Clause
	id = 1

`element_block_memberships`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_block_memberships {
        text element_id PK,FK
        text block_id PK,FK
        int sort_order
    }
    blocks ||--o{ element_block_memberships : ""
    elements ||--o{ element_block_memberships : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`block_id`	`TEXT`	✓	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`block_id` → `blocks.id`
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_elem_blocks_block`	`block_id`
`sqlite_autoindex_element_block_memberships_1`	`element_id, block_id`	✓	✓

`element_bound_elements`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_bound_elements {
        text element_id PK,FK
        text bound_element_id PK
        text bound_type
        int sort_order
    }
    elements ||--o{ element_bound_elements : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`bound_element_id`	`TEXT`	✓
`bound_type`	`TEXT`
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_bound_elements_bound`	`bound_element_id`
`sqlite_autoindex_element_bound_elements_1`	`element_id, bound_element_id`	✓	✓

`element_doc`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_doc {
        text element_id PK,FK
        text text
    }
    element_doc ||--o{ doc_element_referenced_files : ""
    document_grid_config |o--|| element_doc : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`	✓	✓	✓
`text`	`TEXT`				`''`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `document_grid_config.element_id`			cascade
`element_id` ← `doc_element_referenced_files.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_doc_1`	`element_id`	✓	✓

Triggers
Trigger	Timing	Events	Definition
`trg_element_doc_ad`	AFTER	DELETE	`CREATE TRIGGER trg_element_doc_ad AFTER DELETE ON element_doc BEGIN INSERT INTO search_element_doc(search_element_doc, rowid, text) VALUES ('delete', OLD.rowid, OLD.text); END`
`trg_element_doc_ai`	AFTER	INSERT	`CREATE TRIGGER trg_element_doc_ai AFTER INSERT ON element_doc BEGIN INSERT INTO search_element_doc(rowid, text) VALUES (NEW.rowid, NEW.text); END`
`trg_element_doc_au`	AFTER	UPDATE	`CREATE TRIGGER trg_element_doc_au AFTER UPDATE OF text ON element_doc BEGIN INSERT INTO search_element_doc(search_element_doc, rowid, text) VALUES ('delete', OLD.rowid, OLD.text); INSERT INTO search_element_doc(rowid, text) VALUES (NEW.rowid, NEW.text); END`

`element_ellipse`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_ellipse {
        text element_id PK,FK
        float ratio
        float start_angle
        float end_angle
        int show_aux_crosshair
    }
    elements ||--|| element_ellipse : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`ratio`	`REAL`			`1.0`
`start_angle`	`REAL`			`0.0`
`end_angle`	`REAL`			`6.283185307`
`show_aux_crosshair`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_ellipse_1`	`element_id`	✓	✓

`element_embeddable`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_embeddable {
        text element_id PK,FK
    }
    elements ||--|| element_embeddable : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_embeddable_1`	`element_id`	✓	✓

`element_frame`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_frame {
        text element_id PK,FK
    }
    element_stack_properties ||--|| element_frame : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `element_stack_properties.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_frame_1`	`element_id`	✓	✓

`element_freedraw`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_freedraw {
        text element_id PK,FK
        float size
        float thinning
        float smoothing
        float streamline
        text easing
        int start_cap
        float start_taper
        text start_easing
        int end_cap
        float end_taper
        text end_easing
        bytes pressures
        int simulate_pressure
        float last_committed_point_x
        float last_committed_point_y
        int last_committed_point_mirror
        text svg_path
    }
    elements ||--|| element_freedraw : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`size`	`REAL`				`2.0`
`thinning`	`REAL`				`0.6`
`smoothing`	`REAL`				`0.5`
`streamline`	`REAL`				`0.5`
`easing`	`TEXT`				`'easeOutSine'`
`start_cap`	`INTEGER`	✓
`start_taper`	`REAL`	✓
`start_easing`	`TEXT`	✓
`end_cap`	`INTEGER`	✓
`end_taper`	`REAL`	✓
`end_easing`	`TEXT`	✓
`pressures`	`BLOB`	✓
`simulate_pressure`	`INTEGER`				`1`
`last_committed_point_x`	`REAL`	✓
`last_committed_point_y`	`REAL`	✓
`last_committed_point_mirror`	`INTEGER`	✓
`svg_path`	`TEXT`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_freedraw_1`	`element_id`	✓	✓

`element_group_memberships`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_group_memberships {
        text element_id PK,FK
        text group_id PK,FK
        int sort_order
    }
    elements ||--o{ element_group_memberships : ""
    groups ||--o{ element_group_memberships : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`group_id`	`TEXT`	✓	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade
`group_id` → `groups.id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_elem_groups_group`	`group_id`
`sqlite_autoindex_element_group_memberships_1`	`element_id, group_id`	✓	✓

`element_image`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_image {
        text element_id PK,FK
        text file_id
        int status
        float scale_x
        float scale_y
        float crop_x
        float crop_y
        float crop_width
        float crop_height
        float crop_natural_width
        float crop_natural_height
        float filter_brightness
        float filter_contrast
    }
    elements ||--|| element_image : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`file_id`	`TEXT`	✓
`status`	`INTEGER`				`10`
`scale_x`	`REAL`				`1.0`
`scale_y`	`REAL`				`1.0`
`crop_x`	`REAL`	✓
`crop_y`	`REAL`	✓
`crop_width`	`REAL`	✓
`crop_height`	`REAL`	✓
`crop_natural_width`	`REAL`	✓
`crop_natural_height`	`REAL`	✓
`filter_brightness`	`REAL`	✓
`filter_contrast`	`REAL`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary
`idx_element_image_file`	`file_id`
`idx_element_image_status`	`status`
`sqlite_autoindex_element_image_1`	`element_id`	✓	✓

`element_linear`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_linear {
        text element_id PK,FK
        float last_committed_point_x
        float last_committed_point_y
        int last_committed_point_mirror
        text start_binding_element_id
        float start_binding_focus
        float start_binding_gap
        float start_binding_fixed_point_x
        float start_binding_fixed_point_y
        int start_binding_point_index
        float start_binding_point_offset
        int start_binding_head_type
        text start_binding_head_block_id
        float start_binding_head_size
        text end_binding_element_id
        float end_binding_focus
        float end_binding_gap
        float end_binding_fixed_point_x
        float end_binding_fixed_point_y
        int end_binding_point_index
        float end_binding_point_offset
        int end_binding_head_type
        text end_binding_head_block_id
        float end_binding_head_size
        int wipeout_below
        int elbowed
    }
    elements ||--|| element_linear : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`last_committed_point_x`	`REAL`	✓
`last_committed_point_y`	`REAL`	✓
`last_committed_point_mirror`	`INTEGER`	✓
`start_binding_element_id`	`TEXT`	✓
`start_binding_focus`	`REAL`	✓
`start_binding_gap`	`REAL`	✓
`start_binding_fixed_point_x`	`REAL`	✓
`start_binding_fixed_point_y`	`REAL`	✓
`start_binding_point_index`	`INTEGER`	✓
`start_binding_point_offset`	`REAL`	✓
`start_binding_head_type`	`INTEGER`	✓
`start_binding_head_block_id`	`TEXT`	✓
`start_binding_head_size`	`REAL`	✓
`end_binding_element_id`	`TEXT`	✓
`end_binding_focus`	`REAL`	✓
`end_binding_gap`	`REAL`	✓
`end_binding_fixed_point_x`	`REAL`	✓
`end_binding_fixed_point_y`	`REAL`	✓
`end_binding_point_index`	`INTEGER`	✓
`end_binding_point_offset`	`REAL`	✓
`end_binding_head_type`	`INTEGER`	✓
`end_binding_head_block_id`	`TEXT`	✓
`end_binding_head_size`	`REAL`	✓
`wipeout_below`	`INTEGER`				`0`
`elbowed`	`INTEGER`				`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary
`idx_linear_end_binding`	`end_binding_element_id`
`idx_linear_start_binding`	`start_binding_element_id`
`sqlite_autoindex_element_linear_1`	`element_id`	✓	✓

`element_model`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_model {
        text element_id PK,FK
        text model_type
        text code
        bytes thumbnail
    }
    elements |o--|| element_model : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`	✓	✓	✓
`model_type`	`TEXT`	✓
`code`	`TEXT`	✓
`thumbnail`	`BLOB`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_element_model_type`	`model_type`
`sqlite_autoindex_element_model_1`	`element_id`	✓	✓

Triggers
Trigger	Timing	Events	Definition
`trg_element_model_ad`	AFTER	DELETE	`CREATE TRIGGER trg_element_model_ad AFTER DELETE ON element_model BEGIN INSERT INTO search_element_model(search_element_model, rowid, code) VALUES ('delete', OLD.rowid, OLD.code); END`
`trg_element_model_ai`	AFTER	INSERT	`CREATE TRIGGER trg_element_model_ai AFTER INSERT ON element_model BEGIN INSERT INTO search_element_model(rowid, code) VALUES (NEW.rowid, NEW.code); END`
`trg_element_model_au`	AFTER	UPDATE	`CREATE TRIGGER trg_element_model_au AFTER UPDATE OF code ON element_model BEGIN INSERT INTO search_element_model(search_element_model, rowid, code) VALUES ('delete', OLD.rowid, OLD.code); INSERT INTO search_element_model(rowid, code) VALUES (NEW.rowid, NEW.code); END`

`element_pdf`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_pdf {
        text element_id PK,FK
    }
    document_grid_config ||--|| element_pdf : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `document_grid_config.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_pdf_1`	`element_id`	✓	✓

`element_plot`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_plot {
        text element_id PK,FK
        float margin_top
        float margin_right
        float margin_bottom
        float margin_left
    }
    element_stack_properties ||--|| element_plot : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`margin_top`	`REAL`			`0.0`
`margin_right`	`REAL`			`0.0`
`margin_bottom`	`REAL`			`0.0`
`margin_left`	`REAL`			`0.0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `element_stack_properties.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_plot_1`	`element_id`	✓	✓

`element_polygon`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_polygon {
        text element_id PK,FK
        int sides
    }
    elements ||--|| element_polygon : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`sides`	`INTEGER`				`5`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_polygon_1`	`element_id`	✓	✓

`element_region_memberships`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_region_memberships {
        text element_id PK,FK
        text region_id PK,FK
        int sort_order
    }
    elements ||--o{ element_region_memberships : ""
    regions ||--o{ element_region_memberships : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`region_id`	`TEXT`	✓	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade
`region_id` → `regions.id`

Indexes
Index	Columns	Unique	Primary	Type
`idx_elem_regions_region`	`region_id`
`sqlite_autoindex_element_region_memberships_1`	`element_id, region_id`	✓	✓

`element_stack_properties`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_stack_properties {
        text element_id PK,FK
        text label
        text description
        int is_collapsed
        int is_plot
        int is_visible
        int locked
        float opacity
        int clip
        int label_visible
    }
    element_stack_properties ||--|| element_frame : ""
    element_stack_properties ||--|| element_plot : ""
    elements ||--|| element_stack_properties : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`		✓	✓
`label`	`TEXT`				`''`
`description`	`TEXT`	✓
`is_collapsed`	`INTEGER`				`0`
`is_plot`	`INTEGER`				`1`
`is_visible`	`INTEGER`				`1`
`locked`	`INTEGER`				`0`
`opacity`	`REAL`				`1.0`
`clip`	`INTEGER`				`0`
`label_visible`	`INTEGER`				`1`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade
`element_id` ← `element_frame.element_id`			cascade
`element_id` ← `element_plot.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_stack_properties_1`	`element_id`	✓	✓

`element_table`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_table {
        text element_id PK,FK
    }
    document_grid_config ||--|| element_table : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `document_grid_config.element_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_element_table_1`	`element_id`	✓	✓

`element_text`

table · 0 rows

Entity Relationship Diagram

erDiagram
    element_text {
        text element_id PK,FK
        text text
        text original_text
        int auto_resize
        text container_id
        int is_ltr
        text font_family
        text big_font_family
        int text_align
        int vertical_align
        float line_height
        float line_spacing_value
        int line_spacing_type
        float oblique_angle
        float font_size
        float width_factor
        int is_upside_down
        int is_backwards
    }
    elements |o--|| element_text : ""

Columns
Column	Type	Nullable	PK	FK	Default
`element_id`	`TEXT`	✓	✓	✓
`text`	`TEXT`				`''`
`original_text`	`TEXT`				`''`
`auto_resize`	`INTEGER`				`1`
`container_id`	`TEXT`	✓
`is_ltr`	`INTEGER`				`1`
`font_family`	`TEXT`				`'Roboto Mono'`
`big_font_family`	`TEXT`				`'sans-serif'`
`text_align`	`INTEGER`				`10`
`vertical_align`	`INTEGER`				`10`
`line_height`	`REAL`				`1.2`
`line_spacing_value`	`REAL`				`1.2`
`line_spacing_type`	`INTEGER`	✓
`oblique_angle`	`REAL`				`0.0`
`font_size`	`REAL`				`20.0`
`width_factor`	`REAL`				`1.0`
`is_upside_down`	`INTEGER`				`0`
`is_backwards`	`INTEGER`				`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary
`idx_element_text_container`	`container_id`
`idx_element_text_font_family`	`font_family`
`sqlite_autoindex_element_text_1`	`element_id`	✓	✓

Triggers
Trigger	Timing	Events	Definition
`trg_element_text_ad`	AFTER	DELETE	`CREATE TRIGGER trg_element_text_ad AFTER DELETE ON element_text BEGIN INSERT INTO search_element_text(search_element_text, rowid, text, original_text) VALUES ('delete', OLD.rowid, OLD.text, OLD.original_text); END`
`trg_element_text_ai`	AFTER	INSERT	`CREATE TRIGGER trg_element_text_ai AFTER INSERT ON element_text BEGIN INSERT INTO search_element_text(rowid, text, original_text) VALUES (NEW.rowid, NEW.text, NEW.original_text); END`
`trg_element_text_au`	AFTER	UPDATE	`CREATE TRIGGER trg_element_text_au AFTER UPDATE OF text, original_text ON element_text BEGIN INSERT INTO search_element_text(search_element_text, rowid, text, original_text) VALUES ('delete', OLD.rowid, OLD.text, OLD.original_text); INSERT INTO search_element_text(rowid, text, original_text) VALUES (NEW.rowid, NEW.text, NEW.original_text); END`

`elements`

table · 0 rows

Entity Relationship Diagram

erDiagram
    elements {
        text id PK
        text element_type
        float x
        float y
        float width
        float height
        float angle
        text scope
        text label
        text description
        int is_visible
        int seed
        int version
        int version_nonce
        int updated
        text index
        int is_plot
        int is_deleted
        float roundness
        int blending
        float opacity
        text instance_id FK
        text layer_id FK
        text frame_id
        float z_index
        text link
        int locked
        unknown custom_data
    }
    elements ||--|| document_grid_config : ""
    elements ||--o{ element_block_memberships : ""
    elements ||--o{ element_bound_elements : ""
    elements ||--|| element_ellipse : ""
    elements ||--|| element_embeddable : ""
    elements ||--|| element_freedraw : ""
    elements ||--o{ element_group_memberships : ""
    elements ||--|| element_image : ""
    elements ||--|| element_linear : ""
    elements |o--|| element_model : ""
    elements ||--|| element_polygon : ""
    elements ||--o{ element_region_memberships : ""
    elements ||--|| element_stack_properties : ""
    elements |o--|| element_text : ""
    block_instances |o--o{ elements : ""
    layers |o--o{ elements : ""
    elements ||--o{ freedraw_element_points : ""
    elements ||--o{ linear_element_lines : ""
    elements ||--o{ linear_element_points : ""
    elements ||--o{ linear_path_overrides : ""
    elements ||--o{ model_element_files : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`	✓	✓
`element_type`	`TEXT`
`x`	`REAL`				`0.0`
`y`	`REAL`				`0.0`
`width`	`REAL`				`0.0`
`height`	`REAL`				`0.0`
`angle`	`REAL`				`0.0`
`scope`	`TEXT`				`'mm'`
`label`	`TEXT`				`''`
`description`	`TEXT`	✓
`is_visible`	`INTEGER`				`1`
`seed`	`INTEGER`				`0`
`version`	`INTEGER`				`1`
`version_nonce`	`INTEGER`				`0`
`updated`	`INTEGER`				`0`
`index`	`TEXT`	✓
`is_plot`	`INTEGER`				`1`
`is_deleted`	`INTEGER`				`0`
`roundness`	`REAL`				`0.0`
`blending`	`INTEGER`	✓
`opacity`	`REAL`				`1.0`
`instance_id`	`TEXT`	✓		✓
`layer_id`	`TEXT`	✓		✓
`frame_id`	`TEXT`	✓
`z_index`	`REAL`				`0.0`
`link`	`TEXT`	✓
`locked`	`INTEGER`				`0`
`custom_data`	`JSONB`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`instance_id` → `block_instances.id`
`layer_id` → `layers.id`
`id` ← `document_grid_config.element_id`			cascade
`id` ← `element_block_memberships.element_id`			cascade
`id` ← `element_bound_elements.element_id`			cascade
`id` ← `element_ellipse.element_id`			cascade
`id` ← `element_embeddable.element_id`			cascade
`id` ← `element_freedraw.element_id`			cascade
`id` ← `element_group_memberships.element_id`			cascade
`id` ← `element_image.element_id`			cascade
`id` ← `element_linear.element_id`			cascade
`id` ← `element_model.element_id`			cascade
`id` ← `element_polygon.element_id`			cascade
`id` ← `element_region_memberships.element_id`			cascade
`id` ← `element_stack_properties.element_id`			cascade
`id` ← `element_text.element_id`			cascade
`id` ← `freedraw_element_points.element_id`			cascade
`id` ← `linear_element_lines.element_id`			cascade
`id` ← `linear_element_points.element_id`			cascade
`id` ← `linear_path_overrides.element_id`			cascade
`id` ← `model_element_files.element_id`			cascade

Indexes
Index	Columns	Unique	Primary
`idx_elements_deleted`	`is_deleted`
`idx_elements_frame`	`frame_id`
`idx_elements_instance`	`instance_id`
`idx_elements_label`	`label`
`idx_elements_layer`	`layer_id`
`idx_elements_scope`	`scope`
`idx_elements_spatial`	`x, y, width, height`
`idx_elements_type`	`element_type`
`idx_elements_updated`	`updated`
`idx_elements_z_index`	`z_index`
`sqlite_autoindex_elements_1`	`id`	✓	✓

Triggers
Trigger	Timing	Events	Definition
`model_viewer_state_delete_element`	AFTER	DELETE	`CREATE TRIGGER model_viewer_state_delete_element AFTER DELETE ON elements BEGIN DELETE FROM model_viewer_state WHERE owner_type = 'element' AND owner_id = OLD.id; END`
`trg_elements_ad`	AFTER	DELETE	`CREATE TRIGGER trg_elements_ad AFTER DELETE ON elements BEGIN INSERT INTO search_elements(search_elements, rowid, label, description) VALUES ('delete', OLD.rowid, OLD.label, OLD.description); END`
`trg_elements_ai`	AFTER	INSERT	`CREATE TRIGGER trg_elements_ai AFTER INSERT ON elements BEGIN INSERT INTO search_elements(rowid, label, description) VALUES (NEW.rowid, NEW.label, NEW.description); END`
`trg_elements_au`	AFTER	UPDATE	`CREATE TRIGGER trg_elements_au AFTER UPDATE OF label, description ON elements BEGIN INSERT INTO search_elements(search_elements, rowid, label, description) VALUES ('delete', OLD.rowid, OLD.label, OLD.description); INSERT INTO search_elements(rowid, label, description) VALUES (NEW.rowid, NEW.label, NEW.description); END`

`external_file_revision_chunks`

table · 0 rows

Entity Relationship Diagram

erDiagram
    external_file_revision_chunks {
        text revision_id PK,FK
        int chunk_index PK
        int offset_bytes
        int size_bytes
        bytes data
    }
    external_file_revisions ||--o{ external_file_revision_chunks : ""

Columns
Column	Type	PK	FK
`revision_id`	`TEXT`	✓	✓
`chunk_index`	`INTEGER`	✓
`offset_bytes`	`INTEGER`
`size_bytes`	`INTEGER`
`data`	`BLOB`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`revision_id` → `external_file_revisions.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_external_file_revision_chunks_revision_offset`	`revision_id, offset_bytes`
`sqlite_autoindex_external_file_revision_chunks_1`	`revision_id, chunk_index`	✓	✓

Check constraints
Constraint	Clause
	chunk_index >= 0
	offset_bytes >= 0
	size_bytes >= 0

`external_file_revisions`

table · 0 rows

Entity Relationship Diagram

erDiagram
    external_file_revisions {
        text id PK
        text file_id FK
        int size_bytes
        text checksum
        text source_name
        text mime_type
        text message
        int created
        int last_retrieved
    }
    external_file_revisions ||--o{ external_file_revision_chunks : ""
    external_files ||--o{ external_file_revisions : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓
`file_id`	`TEXT`			✓
`size_bytes`	`INTEGER`				`0`
`checksum`	`TEXT`	✓
`source_name`	`TEXT`	✓
`mime_type`	`TEXT`
`message`	`TEXT`	✓
`created`	`INTEGER`
`last_retrieved`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`file_id` → `external_files.id`			cascade
`id` ← `external_file_revision_chunks.revision_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_external_file_revisions_file`	`file_id`
`sqlite_autoindex_external_file_revisions_1`	`id`	✓	✓

`external_file_text_index`

table · 0 rows

Entity Relationship Diagram

erDiagram
    external_file_text_index {
        int id PK
        text file_id
        text revision_id
        text mime_type
        text extracted_text
        int has_ocr
        int updated
    }

Columns
Column	Type	Nullable	PK	Auto	Default
`id`	`INTEGER`	✓	✓	auto_inc
`file_id`	`TEXT`
`revision_id`	`TEXT`
`mime_type`	`TEXT`
`extracted_text`	`TEXT`				`''`
`has_ocr`	`INTEGER`				`0`
`updated`	`INTEGER`

Unique constraints
Constraint	Columns
`sqlite_autoindex_external_file_text_index_1`	`file_id, revision_id`

Indexes
Index	Columns	Unique
`idx_external_file_text_index_file_id`	`file_id`
`idx_external_file_text_index_revision_id`	`revision_id`
`sqlite_autoindex_external_file_text_index_1`	`file_id, revision_id`	✓

Triggers
Trigger	Timing	Events	Definition
`trg_external_file_text_index_ad`	AFTER	DELETE	`CREATE TRIGGER trg_external_file_text_index_ad AFTER DELETE ON external_file_text_index BEGIN INSERT INTO search_external_file_text(search_external_file_text, rowid, extracted_text) VALUES ('delete', OLD.id, OLD.extracted_text); END`
`trg_external_file_text_index_ai`	AFTER	INSERT	`CREATE TRIGGER trg_external_file_text_index_ai AFTER INSERT ON external_file_text_index BEGIN INSERT INTO search_external_file_text(rowid, extracted_text) VALUES (NEW.id, NEW.extracted_text); END`
`trg_external_file_text_index_au`	AFTER	UPDATE	`CREATE TRIGGER trg_external_file_text_index_au AFTER UPDATE OF extracted_text ON external_file_text_index BEGIN INSERT INTO search_external_file_text(search_external_file_text, rowid, extracted_text) VALUES ('delete', OLD.id, OLD.extracted_text); INSERT INTO search_external_file_text(rowid, extracted_text) VALUES (NEW.id, NEW.extracted_text); END`

`external_files`

table · 0 rows

Entity Relationship Diagram

erDiagram
    external_files {
        text id PK
        text active_revision_id
        int updated
        int version
    }
    external_files ||--o{ external_file_revisions : ""

Columns
Column	Type	Nullable	PK
`id`	`TEXT`		✓
`active_revision_id`	`TEXT`
`updated`	`INTEGER`
`version`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `external_file_revisions.file_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_external_files_active`	`active_revision_id`
`sqlite_autoindex_external_files_1`	`id`	✓	✓

`freedraw_element_points`

table · 0 rows

Entity Relationship Diagram

erDiagram
    freedraw_element_points {
        text element_id PK,FK
        int sort_order PK
        float x
        float y
        int mirroring
    }
    elements ||--o{ freedraw_element_points : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓
`sort_order`	`INTEGER`		✓
`x`	`REAL`
`y`	`REAL`
`mirroring`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_freedraw_element_points_1`	`element_id, sort_order`	✓	✓

`groups`

table · 0 rows

Entity Relationship Diagram

erDiagram
    groups {
        text id PK,FK
    }
    groups ||--o{ element_group_memberships : ""
    stack_properties ||--|| groups : ""

Columns
Column	Type	Nullable	PK	FK
`id`	`TEXT`		✓	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` → `stack_properties.id`			cascade
`id` ← `element_group_memberships.group_id`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_groups_1`	`id`	✓	✓

`hatch_pattern_lines`

table · 0 rows

Entity Relationship Diagram

erDiagram
    hatch_pattern_lines {
        int id PK
        text owner_type
        int owner_id
        int sort_order
        float angle
        float origin_x
        float origin_y
        int origin_mirroring
        float offset_x
        float offset_y
        bytes dash_pattern
    }

Columns
Column	Type	Nullable	PK	Auto	Default
`id`	`INTEGER`	✓	✓	auto_inc
`owner_type`	`TEXT`
`owner_id`	`INTEGER`
`sort_order`	`INTEGER`				`0`
`angle`	`REAL`				`0.0`
`origin_x`	`REAL`				`0.0`
`origin_y`	`REAL`				`0.0`
`origin_mirroring`	`INTEGER`	✓
`offset_x`	`REAL`				`0.0`
`offset_y`	`REAL`				`0.0`
`dash_pattern`	`BLOB`	✓

Indexes
Index	Columns	Unique	Primary	Type
`idx_hatch_lines_owner`	`owner_type, owner_id`

`layers`

table · 0 rows

Entity Relationship Diagram

erDiagram
    layers {
        text id PK,FK
        int readonly
    }
    layers |o--o{ elements : ""
    stack_properties ||--|| layers : ""

Columns
Column	Type	Nullable	PK	FK	Default
`id`	`TEXT`		✓	✓
`readonly`	`INTEGER`				`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` → `stack_properties.id`			cascade
`id` ← `elements.layer_id`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_layers_1`	`id`	✓	✓

`linear_element_lines`

table · 0 rows

Entity Relationship Diagram

erDiagram
    linear_element_lines {
        text element_id PK,FK
        int sort_order PK
        int start_index
        float start_handle_x
        float start_handle_y
        int end_index
        float end_handle_x
        float end_handle_y
    }
    elements ||--o{ linear_element_lines : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓
`sort_order`	`INTEGER`		✓
`start_index`	`INTEGER`
`start_handle_x`	`REAL`	✓
`start_handle_y`	`REAL`	✓
`end_index`	`INTEGER`
`end_handle_x`	`REAL`	✓
`end_handle_y`	`REAL`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_linear_element_lines_1`	`element_id, sort_order`	✓	✓

`linear_element_points`

table · 0 rows

Entity Relationship Diagram

erDiagram
    linear_element_points {
        text element_id PK,FK
        int sort_order PK
        float x
        float y
        int mirroring
    }
    elements ||--o{ linear_element_points : ""

Columns
Column	Type	Nullable	PK	FK
`element_id`	`TEXT`		✓	✓
`sort_order`	`INTEGER`		✓
`x`	`REAL`
`y`	`REAL`
`mirroring`	`INTEGER`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_linear_element_points_1`	`element_id, sort_order`	✓	✓

`linear_path_override_indices`

table · 0 rows

Entity Relationship Diagram

erDiagram
    linear_path_override_indices {
        int path_override_id PK,FK
        int sort_order PK
        int line_index
    }
    linear_path_overrides ||--o{ linear_path_override_indices : ""

Columns
Column	Type	PK	FK
`path_override_id`	`INTEGER`	✓	✓
`sort_order`	`INTEGER`	✓
`line_index`	`INTEGER`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`path_override_id` → `linear_path_overrides.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_linear_path_override_indices_1`	`path_override_id, sort_order`	✓	✓

`linear_path_overrides`

table · 0 rows

Entity Relationship Diagram

erDiagram
    linear_path_overrides {
        int id PK
        text element_id FK
        int sort_order
    }
    linear_path_overrides ||--o{ linear_path_override_indices : ""
    elements ||--o{ linear_path_overrides : ""

Columns
Column	Type	Nullable	PK	FK	Auto
`id`	`INTEGER`	✓	✓		auto_inc
`element_id`	`TEXT`			✓
`sort_order`	`INTEGER`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade
`id` ← `linear_path_override_indices.path_override_id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_path_overrides_element`	`element_id`

`model_element_files`

table · 0 rows

Entity Relationship Diagram

erDiagram
    model_element_files {
        text element_id PK,FK
        text file_id PK
        int sort_order
    }
    elements ||--o{ model_element_files : ""

Columns
Column	Type	PK	FK	Default
`element_id`	`TEXT`	✓	✓
`file_id`	`TEXT`	✓
`sort_order`	`INTEGER`			`0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`element_id` → `elements.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_model_files_file`	`file_id`
`sqlite_autoindex_model_element_files_1`	`element_id, file_id`	✓	✓

`model_viewer_state`

table · 0 rows

Entity Relationship Diagram

erDiagram
    model_viewer_state {
        text owner_type PK
        text owner_id PK
        text camera_control
        int camera_ortho
        text camera_up
        float camera_position_x
        float camera_position_y
        float camera_position_z
        float camera_quaternion_x
        float camera_quaternion_y
        float camera_quaternion_z
        float camera_quaternion_w
        float camera_target_x
        float camera_target_y
        float camera_target_z
        float camera_zoom
        float camera_pan_speed
        float camera_rotate_speed
        float camera_zoom_speed
        int camera_holroyd
        int display_wireframe
        int display_transparent
        int display_black_edges
        int display_grid_uniform
        int display_grid_xy
        int display_grid_xz
        int display_grid_yz
        int display_axes_visible
        int display_axes_at_origin
        float material_metalness
        float material_roughness
        float material_default_opacity
        int material_edge_color
        float material_ambient_intensity
        float material_direct_intensity
        int clip_x_enabled
        float clip_x_value
        float clip_x_normal_x
        float clip_x_normal_y
        float clip_x_normal_z
        int clip_y_enabled
        float clip_y_value
        float clip_y_normal_x
        float clip_y_normal_y
        float clip_y_normal_z
        int clip_z_enabled
        float clip_z_value
        float clip_z_normal_x
        float clip_z_normal_y
        float clip_z_normal_z
        int clip_intersection
        int clip_show_planes
        int clip_object_color_caps
        int explode_active
        float explode_value
        int zebra_active
        int zebra_stripe_count
        float zebra_stripe_direction
        text zebra_color_scheme
        float zebra_opacity
        text zebra_mapping_mode
    }

Columns
Column	Type	Nullable	PK	Default
`owner_type`	`TEXT`		✓
`owner_id`	`TEXT`		✓
`camera_control`	`TEXT`			`'orbit'`
`camera_ortho`	`INTEGER`			`0`
`camera_up`	`TEXT`			`'Z'`
`camera_position_x`	`REAL`			`0.0`
`camera_position_y`	`REAL`			`0.0`
`camera_position_z`	`REAL`			`0.0`
`camera_quaternion_x`	`REAL`			`0.0`
`camera_quaternion_y`	`REAL`			`0.0`
`camera_quaternion_z`	`REAL`			`0.0`
`camera_quaternion_w`	`REAL`			`1.0`
`camera_target_x`	`REAL`			`0.0`
`camera_target_y`	`REAL`			`0.0`
`camera_target_z`	`REAL`			`0.0`
`camera_zoom`	`REAL`			`1.0`
`camera_pan_speed`	`REAL`			`1.0`
`camera_rotate_speed`	`REAL`			`1.0`
`camera_zoom_speed`	`REAL`			`1.0`
`camera_holroyd`	`INTEGER`			`0`
`display_wireframe`	`INTEGER`			`0`
`display_transparent`	`INTEGER`			`0`
`display_black_edges`	`INTEGER`			`0`
`display_grid_uniform`	`INTEGER`	✓
`display_grid_xy`	`INTEGER`			`0`
`display_grid_xz`	`INTEGER`			`0`
`display_grid_yz`	`INTEGER`			`0`
`display_axes_visible`	`INTEGER`			`0`
`display_axes_at_origin`	`INTEGER`			`0`
`material_metalness`	`REAL`			`0.0`
`material_roughness`	`REAL`			`0.5`
`material_default_opacity`	`REAL`			`1.0`
`material_edge_color`	`INTEGER`			`0`
`material_ambient_intensity`	`REAL`			`0.5`
`material_direct_intensity`	`REAL`			`0.5`
`clip_x_enabled`	`INTEGER`			`0`
`clip_x_value`	`REAL`			`0.0`
`clip_x_normal_x`	`REAL`	✓
`clip_x_normal_y`	`REAL`	✓
`clip_x_normal_z`	`REAL`	✓
`clip_y_enabled`	`INTEGER`			`0`
`clip_y_value`	`REAL`			`0.0`
`clip_y_normal_x`	`REAL`	✓
`clip_y_normal_y`	`REAL`	✓
`clip_y_normal_z`	`REAL`	✓
`clip_z_enabled`	`INTEGER`			`0`
`clip_z_value`	`REAL`			`0.0`
`clip_z_normal_x`	`REAL`	✓
`clip_z_normal_y`	`REAL`	✓
`clip_z_normal_z`	`REAL`	✓
`clip_intersection`	`INTEGER`			`0`
`clip_show_planes`	`INTEGER`			`0`
`clip_object_color_caps`	`INTEGER`			`0`
`explode_active`	`INTEGER`			`0`
`explode_value`	`REAL`			`0.0`
`zebra_active`	`INTEGER`			`0`
`zebra_stripe_count`	`INTEGER`			`10`
`zebra_stripe_direction`	`REAL`			`0.0`
`zebra_color_scheme`	`TEXT`			`'blackwhite'`
`zebra_opacity`	`REAL`			`1.0`
`zebra_mapping_mode`	`TEXT`			`'reflection'`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_model_viewer_state_1`	`owner_type, owner_id`	✓	✓

Check constraints
Constraint	Clause
	owner_type IN ('element', 'issue_anchor')

`regions`

table · 0 rows

Entity Relationship Diagram

erDiagram
    regions {
        text id PK,FK
        int boolean_operation
    }
    regions ||--o{ element_region_memberships : ""
    stack_properties ||--|| regions : ""

Columns
Column	Type	Nullable	PK	FK
`id`	`TEXT`		✓	✓
`boolean_operation`	`INTEGER`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` → `stack_properties.id`			cascade
`id` ← `element_region_memberships.region_id`

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_regions_1`	`id`	✓	✓

`schema_migrations`

table · 0 rows

Entity Relationship Diagram

erDiagram
    schema_migrations {
        int id PK
        int from_schema_version
        int to_schema_version
        text migration_name
        text migration_sql
        text reverse_migration_sql
        text migration_checksum
        int applied_at
        text boundary_checkpoint_id
    }
    schema_migrations |o--o{ version_chains : ""

Columns
Column	Type	Nullable	PK	Auto
`id`	`INTEGER`	✓	✓	auto_inc
`from_schema_version`	`INTEGER`
`to_schema_version`	`INTEGER`
`migration_name`	`TEXT`
`migration_sql`	`TEXT`	✓
`reverse_migration_sql`	`TEXT`	✓
`migration_checksum`	`TEXT`	✓
`applied_at`	`INTEGER`
`boundary_checkpoint_id`	`TEXT`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `version_chains.migration_id`

Unique constraints
Constraint	Columns
`sqlite_autoindex_schema_migrations_1`	`from_schema_version, to_schema_version`

Indexes
Index	Columns	Unique	Primary	Type
`idx_schema_migrations_to_version`	`to_schema_version`
`sqlite_autoindex_schema_migrations_1`	`from_schema_version, to_schema_version`	✓

Check constraints
Constraint	Clause
	to_schema_version > from_schema_version

`search_blocks_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_blocks_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_blocks_config_1`	`k`	✓	✓

`search_blocks_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_blocks_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_blocks_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_blocks_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_blocks_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_blocks_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_blocks_idx_1`	`segid, term`	✓	✓

`search_element_doc_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_element_doc_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_doc_config_1`	`k`	✓	✓

`search_element_doc_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_element_doc_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_element_doc_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_doc_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_element_doc_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_doc_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_doc_idx_1`	`segid, term`	✓	✓

`search_element_model_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_element_model_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_model_config_1`	`k`	✓	✓

`search_element_model_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_element_model_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_element_model_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_model_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_element_model_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_model_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_model_idx_1`	`segid, term`	✓	✓

`search_element_text_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_element_text_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_text_config_1`	`k`	✓	✓

`search_element_text_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_element_text_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_element_text_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_text_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_element_text_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_text_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_element_text_idx_1`	`segid, term`	✓	✓

`search_elements_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_elements_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_elements_config_1`	`k`	✓	✓

`search_elements_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_elements_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_elements_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_elements_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_elements_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_elements_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_elements_idx_1`	`segid, term`	✓	✓

`search_external_file_text_config`

table · 1 rows

Entity Relationship Diagram

erDiagram
    search_external_file_text_config {
        text k PK
        int v
    }

Columns
Column	Type	Nullable	PK	FK
`k`	`text`		✓
`v`	`integer`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_external_file_text_config_1`	`k`	✓	✓

`search_external_file_text_data`

table · 2 rows

Entity Relationship Diagram

erDiagram
    search_external_file_text_data {
        int id PK
        bytes block
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`block`	`BLOB`	✓

`search_external_file_text_docsize`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_external_file_text_docsize {
        int id PK
        bytes sz
    }

Columns
Column	Type	Nullable	PK	FK
`id`	`INTEGER`	✓	✓
`sz`	`BLOB`	✓

`search_external_file_text_idx`

table · 0 rows

Entity Relationship Diagram

erDiagram
    search_external_file_text_idx {
        bytes segid PK
        bytes term PK
        bytes pgno
    }

Columns
Column	Nullable	PK
`segid`		✓
`term`		✓
`pgno`	✓

Indexes
Index	Columns	Unique	Primary	Type
`sqlite_autoindex_search_external_file_text_idx_1`	`segid, term`	✓	✓

`stack_properties`

table · 0 rows

Entity Relationship Diagram

erDiagram
    stack_properties {
        text id PK
        text label
        text description
        int is_collapsed
        int is_plot
        int is_visible
        int locked
        float opacity
    }
    stack_properties ||--|| groups : ""
    stack_properties ||--|| layers : ""
    stack_properties ||--|| regions : ""

Columns
Column	Type	Nullable	PK	Default
`id`	`TEXT`		✓
`label`	`TEXT`			`''`
`description`	`TEXT`	✓
`is_collapsed`	`INTEGER`			`0`
`is_plot`	`INTEGER`			`0`
`is_visible`	`INTEGER`			`1`
`locked`	`INTEGER`			`0`
`opacity`	`REAL`			`1.0`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`id` ← `groups.id`			cascade
`id` ← `layers.id`			cascade
`id` ← `regions.id`			cascade

Indexes
Index	Columns	Unique	Primary	Type
`idx_stack_properties_label`	`label`
`sqlite_autoindex_stack_properties_1`	`id`	✓	✓

`strokes`

table · 0 rows

Entity Relationship Diagram

erDiagram
    strokes {
        int id PK
        text owner_type
        text owner_id
        int sort_order
        int preference
        text src
        int visible
        float opacity
        float tiling_size_in_percent
        float tiling_angle
        float tiling_spacing
        float tiling_offset_x
        float tiling_offset_y
        int hatch_style
        text hatch_pattern_name
        float hatch_pattern_scale
        float hatch_pattern_angle
        float hatch_pattern_origin_x
        float hatch_pattern_origin_y
        int hatch_pattern_origin_mirror
        int hatch_pattern_double
        text hatch_custom_pattern_name
        text hatch_custom_pattern_desc
        float image_filter_brightness
        float image_filter_contrast
        float width
        int style_preference
        int style_cap
        int style_join
        bytes style_dash
        text style_dash_line_override
        int style_dash_cap
        float style_miter_limit
        int placement
        int sides_preference
        bytes sides_values
    }

Columns
Column	Type	Nullable	PK	Auto	Default
`id`	`INTEGER`	✓	✓	auto_inc
`owner_type`	`TEXT`
`owner_id`	`TEXT`
`sort_order`	`INTEGER`				`0`
`preference`	`INTEGER`	✓
`src`	`TEXT`				`''`
`visible`	`INTEGER`				`1`
`opacity`	`REAL`				`1.0`
`tiling_size_in_percent`	`REAL`	✓
`tiling_angle`	`REAL`	✓
`tiling_spacing`	`REAL`	✓
`tiling_offset_x`	`REAL`	✓
`tiling_offset_y`	`REAL`	✓
`hatch_style`	`INTEGER`	✓
`hatch_pattern_name`	`TEXT`	✓
`hatch_pattern_scale`	`REAL`	✓
`hatch_pattern_angle`	`REAL`	✓
`hatch_pattern_origin_x`	`REAL`	✓
`hatch_pattern_origin_y`	`REAL`	✓
`hatch_pattern_origin_mirror`	`INTEGER`	✓
`hatch_pattern_double`	`INTEGER`	✓
`hatch_custom_pattern_name`	`TEXT`	✓
`hatch_custom_pattern_desc`	`TEXT`	✓
`image_filter_brightness`	`REAL`	✓
`image_filter_contrast`	`REAL`	✓
`width`	`REAL`				`1.0`
`style_preference`	`INTEGER`	✓
`style_cap`	`INTEGER`	✓
`style_join`	`INTEGER`	✓
`style_dash`	`BLOB`	✓
`style_dash_line_override`	`TEXT`	✓
`style_dash_cap`	`INTEGER`	✓
`style_miter_limit`	`REAL`	✓
`placement`	`INTEGER`	✓
`sides_preference`	`INTEGER`	✓
`sides_values`	`BLOB`	✓

Indexes
Index	Columns	Unique	Primary	Type
`idx_strokes_owner`	`owner_type, owner_id`
`idx_strokes_src`	`src`

`version_chains`

table · 0 rows

Entity Relationship Diagram

erDiagram
    version_chains {
        text id PK
        int schema_version
        int start_version
        int end_version
        int migration_id FK
        text root_checkpoint_id
    }
    version_chains ||--o{ checkpoints : ""
    version_chains ||--o{ deltas : ""
    schema_migrations |o--o{ version_chains : ""

Columns
Column	Type	Nullable	PK	FK
`id`	`TEXT`		✓
`schema_version`	`INTEGER`
`start_version`	`INTEGER`
`end_version`	`INTEGER`	✓
`migration_id`	`INTEGER`	✓		✓
`root_checkpoint_id`	`TEXT`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`migration_id` → `schema_migrations.id`
`id` ← `checkpoints.chain_id`
`id` ← `deltas.chain_id`

Unique constraints
Constraint	Columns
`sqlite_autoindex_version_chains_2`	`schema_version, start_version`

Indexes
Index	Columns	Unique	Primary
`idx_version_chains_schema_version`	`schema_version, start_version`
`sqlite_autoindex_version_chains_1`	`id`	✓	✓
`sqlite_autoindex_version_chains_2`	`schema_version, start_version`	✓

Check constraints
Constraint	Clause
	schema_version >= 1
	end_version IS NULL OR end_version >= start_version

`version_graph`

table · 1 rows

Entity Relationship Diagram

erDiagram
    version_graph {
        int id PK
        int current_version
        int current_schema_version
        text user_checkpoint_version_id
        text latest_version_id
        int chain_count
        int total_size
    }

Columns
Column	Type	Nullable	PK	Default
`id`	`INTEGER`	✓	✓
`current_version`	`INTEGER`			`0`
`current_schema_version`	`INTEGER`			`1`
`user_checkpoint_version_id`	`TEXT`	✓
`latest_version_id`	`TEXT`	✓
`chain_count`	`INTEGER`			`1`
`total_size`	`INTEGER`	✓

Check constraints
Constraint	Clause
	id = 1
	current_schema_version >= 1
	chain_count >= 1

`search_blocks`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_blocks {
        bytes label
        bytes description
    }

Columns
Column	Type	Nullable	PK	FK
`label`		✓
`description`		✓

`search_element_doc`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_doc {
        bytes text
    }

Columns
Column	Type	Nullable	PK	FK
`text`		✓

`search_element_model`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_model {
        bytes code
    }

Columns
Column	Type	Nullable	PK	FK
`code`		✓

`search_element_text`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_element_text {
        bytes text
        bytes original_text
    }

Columns
Column	Type	Nullable	PK	FK
`text`		✓
`original_text`		✓

`search_elements`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_elements {
        bytes label
        bytes description
    }

Columns
Column	Type	Nullable	PK	FK
`label`		✓
`description`		✓

`search_external_file_text`

virtual · 0 rows

Entity Relationship Diagram

erDiagram
    search_external_file_text {
        bytes extracted_text
    }

Columns
Column	Type	Nullable	PK	FK
`extracted_text`		✓