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),
26 DROP TABLE IF EXISTS gde_file CASCADE;
27 CREATE TABLE gde_file (
28 id bigint NOT NULL PRIMARY KEY,
31 checksum varchar(255),
32 creation_date timestamp,
33 update_date timestamp,
36 deletion_date timestamp,
37 attribute_group_id bigint REFERENCES attribute_group (id)
40 DROP TABLE IF EXISTS chunk CASCADE;
42 id bigint NOT NULL PRIMARY KEY,
43 file_id bigint NOT NULL REFERENCES gde_file (id),
45 checksum varchar(255),
52 DROP TABLE IF EXISTS study CASCADE;
54 id bigint NOT NULL PRIMARY KEY,
56 creation_date timestamp,
57 update_date timestamp,
60 deletion_date timestamp,
61 attribute_group_id bigint REFERENCES attribute_group (id)
66 DROP TABLE IF EXISTS profile CASCADE;
67 CREATE TABLE profile (
68 id bigint NOT NULL PRIMARY KEY,
72 DROP TABLE IF EXISTS profile_attribute CASCADE;
73 CREATE TABLE profile_attribute (
74 id bigint NOT NULL PRIMARY KEY,
78 profile_id bigint REFERENCES profile (id)