Index: src/main/resources/db/migration/V1__init_ddl.sql
===================================================================
--- src/main/resources/db/migration/V1__init_ddl.sql	(revision e9c6c437326875fd2e8dc81ac0274eb6cda2b727)
+++ src/main/resources/db/migration/V1__init_ddl.sql	(revision f38cc6c379438c1d95406dfcfec1aeaaa4540415)
@@ -184,5 +184,4 @@
 CREATE TABLE project_request
 (
-    id          SERIAL PRIMARY KEY,
     description VARCHAR(200),
     status      varchar(32)                NOT NULL DEFAULT 'PENDING',
@@ -190,5 +189,6 @@
     project_id  INT REFERENCES thread (id) ON DELETE CASCADE NOT NULL,
     created_at timestamp default now() not null,
-    submission_id int references submission(id) ON DELETE CASCADE
+    submission_id int references submission(id) ON DELETE CASCADE,
+    PRIMARY KEY (submission_id)
 );
 
@@ -204,5 +204,4 @@
 CREATE TABLE report
 (
-    id          SERIAL,
     created_at  TIMESTAMP default now() not null,
     description VARCHAR(200) NOT NULL,
@@ -212,5 +211,5 @@
     by_user_id  INT REFERENCES users (id) on delete cascade,
     submission_id int references submission(id) on delete cascade,
-    PRIMARY KEY (id, thread_id, for_user_id, by_user_id)
+    PRIMARY KEY (submission_id)
 );
 CREATE TABLE channel