indradb-postgres 0.1.0

A postgres-backed datastore for IndraDB
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

pub const SCHEMA: &'static str = "
/* Vertices */
CREATE TABLE vertices (
    id UUID NOT NULL,
    type VARCHAR(1000) NOT NULL
);

ALTER TABLE vertices
    ADD CONSTRAINT vertices_pkey PRIMARY KEY (id);

/* Edges */
CREATE TABLE edges (
    id UUID NOT NULL,
    outbound_id UUID NOT NULL,
    type VARCHAR(1000) NOT NULL,
    inbound_id UUID NOT NULL,
    update_timestamp TIMESTAMP WITH TIME ZONE NOT NULL
);

ALTER TABLE edges
    ADD CONSTRAINT edges_pkey PRIMARY KEY (id),
    ADD CONSTRAINT edges_outbound_id_type_inbound_id_ukey UNIQUE (outbound_id, type, inbound_id),
    ADD CONSTRAINT edges_outbound_id_fkey FOREIGN KEY (outbound_id) REFERENCES vertices (id) ON DELETE CASCADE,
    ADD CONSTRAINT edges_inbound_id_fkey FOREIGN KEY (inbound_id) REFERENCES vertices (id) ON DELETE CASCADE;

CREATE INDEX ix_edges_update_timestamp ON edges USING btree (update_timestamp);
CREATE INDEX ix_edges_inbound_id ON edges USING btree (inbound_id);

/* Vertex metadata */
CREATE TABLE vertex_metadata (
    owner_id UUID NOT NULL,
    name VARCHAR(1024) NOT NULL,
    value JSONB NOT NULL
);

ALTER TABLE vertex_metadata
    ADD CONSTRAINT vertex_metadata_pkey PRIMARY KEY (owner_id, name),
    ADD CONSTRAINT vertex_metadata_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES vertices (id) ON DELETE CASCADE;

/* Metadata */
CREATE TABLE edge_metadata (
    owner_id UUID NOT NULL,
    name VARCHAR(1024) NOT NULL,
    value JSONB NOT NULL
);

ALTER TABLE edge_metadata
    ADD CONSTRAINT edge_metadata_pkey PRIMARY KEY (owner_id, name),
    ADD CONSTRAINT edge_metadata_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES edges (id) ON DELETE CASCADE;

";