uniform_resource_edge

Column Type PK Required Default
graph_name VARCHAR No Yes
nature TEXT No Yes
node_id TEXT No Yes
uniform_resource_id VARCHAR No Yes
elaboration TEXT No No

Foreign Keys

Column Name Foreign Key
uniform_resource_id uniform_resource_id references uniform_resource.uniform_resource_id
graph_name graph_name references uniform_resource_graph.name

Indexes

Column Name Index Name
uniform_resource_id idx_uniform_resource_edge__uniform_resource_id
graph_name sqlite_autoindex_uniform_resource_edge_1
nature sqlite_autoindex_uniform_resource_edge_1
node_id sqlite_autoindex_uniform_resource_edge_1
uniform_resource_id sqlite_autoindex_uniform_resource_edge_1

SQL DDL

CREATE TABLE "uniform_resource_edge" (
    "graph_name" VARCHAR NOT NULL,
    "nature" TEXT NOT NULL,
    "node_id" TEXT NOT NULL,
    "uniform_resource_id" VARCHAR NOT NULL,
    "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
    FOREIGN KEY("graph_name") REFERENCES "uniform_resource_graph"("name"),
    FOREIGN KEY("uniform_resource_id") REFERENCES "uniform_resource"("uniform_resource_id"),
    UNIQUE("graph_name", "nature", "node_id", "uniform_resource_id")
)