obsidian-publisher schema

CREATE TABLE markdown_nodes (
    id                 UUID PRIMARY KEY,
    raw_markdown       TEXT,
    rendered_markdown  TEXT,
    full_file_path     VARCHAR(1024),
    title              VARCHAR(1024),
    yaml_json          JSON,
    metadata           JSON
);
CREATE TABLE markdown_edges (
    link_id              UUID PRIMARY_KEY,
    label                VARCHAR,
    title                VARCHAR,
    from_node_id         UUID,
    from_node_metadata   JSON,
    link_mtadata         JSON,
    to_node_id           UUID,
    to_node_metadata     JSON
);
CREATE TABLE markdown_key_values (
    id         UUID PRIMARY_KEY,
    note_id    UUID,
    tag        VARCHAR(1024),
    raw_value  TEXT,
    json_value JSON
);
CREATE TABLE markdown_syntax_trees (
    id               UUID PRIMARY KEY,
    markdown_id      TEXT,
    syntax_tree      JSON,
    metadata         JSON
);
CREATE TABLE html_rendered_from_markdown (
    id               UUID PRIMARY KEY,
    markdown_id      UUID,
    html_content     TEXT,
    metadata         JSON
);
CREATE TABLE urls_extracted_from_nodes (
    markdown_node_id UUID,
  url              TEXT,
  domain           TEXT
);