uniform_resource_edge

Column Type PK Required Default
graph_name TEXT No Yes
nature TEXT No Yes
node_id TEXT No Yes
uniform_resource_id TEXT 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
graph_name uniform_resource_edge_graph_name_nature_node_id_uniform_resource_id_unique
nature uniform_resource_edge_graph_name_nature_node_id_uniform_resource_id_unique
node_id uniform_resource_edge_graph_name_nature_node_id_uniform_resource_id_unique
uniform_resource_id uniform_resource_edge_graph_name_nature_node_id_uniform_resource_id_unique
uniform_resource_id idx_uniform_resource_edge__uniform_resource_id

SQL DDL

CREATE TABLE `uniform_resource_edge` (
	`graph_name` text NOT NULL,
	`nature` text NOT NULL,
	`node_id` text NOT NULL,
	`uniform_resource_id` text NOT NULL,
	`elaboration` text,
	FOREIGN KEY (`graph_name`) REFERENCES `uniform_resource_graph`(`name`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`uniform_resource_id`) REFERENCES `uniform_resource`(`uniform_resource_id`) ON UPDATE no action ON DELETE no action
)