1 drop sequence SEQ_GEN_SEQUENCE;
2 create sequence SEQ_GEN_SEQUENCE INCREMENT BY 50;
6 DROP TABLE attribute_group CASCADE;
7 CREATE TABLE attribute_group (
8 id bigint NOT NULL PRIMARY KEY
11 DROP TABLE attribute CASCADE;
12 CREATE TABLE attribute (
13 id bigint NOT NULL PRIMARY KEY,
17 attribute_group_id bigint REFERENCES attribute_group (id),
23 DROP TABLE gde_file CASCADE;
24 CREATE TABLE gde_file (
25 id bigint NOT NULL PRIMARY KEY,
28 checksum varchar(255),
29 creation_date timestamp,
30 update_date timestamp,
33 deletion_date timestamp,
34 attribute_group_id bigint REFERENCES attribute_group (id)
37 DROP TABLE chunk CASCADE;
39 id bigint NOT NULL PRIMARY KEY,
40 file_id bigint NOT NULL REFERENCES gde_file (id),
42 checksum varchar(255),
49 DROP TABLE study CASCADE;
51 id bigint NOT NULL PRIMARY KEY,
53 creation_date timestamp,
54 update_date timestamp,
57 deletion_date timestamp,
58 attribute_group_id bigint REFERENCES attribute_group (id)
63 DROP TABLE profile CASCADE;
64 CREATE TABLE profile (
65 id bigint NOT NULL PRIMARY KEY,
69 DROP TABLE profile_attribute CASCADE;
70 CREATE TABLE profile_attribute (
71 id bigint NOT NULL PRIMARY KEY,
75 profile_id bigint REFERENCES profile (id)