1 |
36318
|
claudio.at
|
-- createdb dnet_dedup
|
2 |
|
|
-- manage db with dbService
|
3 |
36049
|
claudio.at
|
|
4 |
36318
|
claudio.at
|
CREATE TABLE entities (
|
5 |
|
|
id character varying(255) NOT NULL,
|
6 |
|
|
entitytype character varying(255) NOT NULL,
|
7 |
|
|
_dnet_resource_identifier_ character varying(2048) DEFAULT ((('temp_'::text || md5((clock_timestamp())::text)) || '_'::text) || md5((random())::text)),
|
8 |
|
|
PRIMARY KEY(id)
|
9 |
|
|
);
|
10 |
|
|
|
11 |
36049
|
claudio.at
|
CREATE TABLE groups (
|
12 |
|
|
id character varying(255) NOT NULL,
|
13 |
|
|
entitytype character varying(255) NOT NULL,
|
14 |
36623
|
claudio.at
|
actionsetid character varying(255) NOT NULL,
|
15 |
36049
|
claudio.at
|
date timestamp without time zone default now(),
|
16 |
|
|
_dnet_resource_identifier_ character varying(2048) DEFAULT ((('temp_'::text || md5((clock_timestamp())::text)) || '_'::text) || md5((random())::text)),
|
17 |
|
|
PRIMARY KEY(id)
|
18 |
|
|
);
|
19 |
|
|
|
20 |
|
|
CREATE TABLE similarity_groups (
|
21 |
|
|
groupid character varying(255) NOT NULL REFERENCES groups(id) ON DELETE CASCADE,
|
22 |
|
|
objidentifier character varying(255) NOT NULL REFERENCES entities(id) ON DELETE CASCADE,
|
23 |
|
|
_dnet_resource_identifier_ character varying(2048) DEFAULT ((('temp_'::text || md5((clock_timestamp())::text)) || '_'::text) || md5((random())::text)),
|
24 |
|
|
PRIMARY KEY(groupid, objidentifier)
|
25 |
|
|
);
|
26 |
|
|
|
27 |
|
|
CREATE TABLE dissimilarities (
|
28 |
|
|
id1 character varying(255) NOT NULL REFERENCES entities(id) ON DELETE CASCADE,
|
29 |
|
|
id2 character varying(255) NOT NULL REFERENCES entities(id) ON DELETE CASCADE,
|
30 |
37173
|
claudio.at
|
actionsetid character varying(255) NOT NULL,
|
31 |
36049
|
claudio.at
|
_dnet_resource_identifier_ character varying(2048) DEFAULT ((('temp_'::text || md5((clock_timestamp())::text)) || '_'::text) || md5((random())::text)),
|
32 |
37415
|
claudio.at
|
PRIMARY KEY(id1, id2, actionsetid)
|
33 |
36049
|
claudio.at
|
);
|
34 |
|
|
|
35 |
|
|
|
36 |
|
|
|
37 |
|
|
|
38 |
|
|
|
39 |
|
|
|
40 |
|
|
|
41 |
|
|
|
42 |
|
|
|