2 drop sequence SEQ_GEN_SEQUENCE;
3 create sequence SEQ_GEN_SEQUENCE INCREMENT BY 50;
8 DROP TABLE IF EXISTS attribute_group CASCADE;
9 CREATE TABLE attribute_group (
10 id bigint NOT NULL PRIMARY KEY
13 DROP TABLE IF EXISTS attribute CASCADE;
14 CREATE TABLE attribute (
15 id bigint NOT NULL PRIMARY KEY,
19 attribute_group_id bigint REFERENCES attribute_group (id),
25 DROP TABLE IF EXISTS gde_file CASCADE;
26 CREATE TABLE gde_file (
27 id bigint NOT NULL PRIMARY KEY,
30 checksum varchar(255),
31 creation_date timestamp,
32 update_date timestamp,
35 deletion_date timestamp,
36 attribute_group_id bigint REFERENCES attribute_group (id)
39 DROP TABLE IF EXISTS chunk CASCADE;
41 id bigint NOT NULL PRIMARY KEY,
42 file_id bigint NOT NULL REFERENCES gde_file (id),
44 checksum varchar(255),
51 DROP TABLE IF EXISTS study CASCADE;
53 id bigint NOT NULL PRIMARY KEY,
55 creation_date timestamp,
56 update_date timestamp,
59 deletion_date timestamp,
60 attribute_group_id bigint REFERENCES attribute_group (id)
65 DROP TABLE IF EXISTS profile CASCADE;
66 CREATE TABLE profile (
67 id bigint NOT NULL PRIMARY KEY,
71 DROP TABLE IF EXISTS profile_attribute CASCADE;
72 CREATE TABLE profile_attribute (
73 id bigint NOT NULL PRIMARY KEY,
77 profile_id bigint REFERENCES profile (id)