| 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 |
|
|
|