Debian Codegraph @

share/database-schema/postgresql-create.sql

raw
1 CREATE TABLE IF NOT EXISTS attean_version (
2 attean_version VARCHAR(16),
3 store_version VARCHAR(16),
4 created TIMESTAMP DEFAULT NOW(),
5 updated TIMESTAMP DEFAULT NOW()
6 );
7
8 CREATE TYPE TERM_TYPE AS ENUM ('iri', 'literal', 'blank');
9 CREATE TABLE IF NOT EXISTS term (
10 term_id SERIAL PRIMARY KEY,
11 type TERM_TYPE,
12 datatype_id BIGINT REFERENCES term(term_id),
13 value TEXT NOT NULL,
14 language TEXT,
15 UNIQUE (datatype_id, value, language)
16 );
17
18 CREATE TABLE IF NOT EXISTS quad (
19 subject BIGINT NOT NULL REFERENCES term,
20 predicate BIGINT NOT NULL REFERENCES term,
21 object BIGINT NOT NULL REFERENCES term,
22 graph BIGINT NOT NULL REFERENCES term,
23 PRIMARY KEY (subject, predicate, object, graph)
24 );
25
26 CREATE INDEX IF NOT EXISTS quad_graph_idx ON quad (graph);
27 CREATE INDEX IF NOT EXISTS quad_pogs_idx ON quad (predicate,object,graph,subject);