Index: db-scripts/ddl.sql
===================================================================
--- db-scripts/ddl.sql	(revision 3ebe47cce61b3bfc1dee2566f7475e378374591e)
+++ db-scripts/ddl.sql	(revision 6fa5831b8e2ae83049ad95bf899fba2f0a35fbf4)
@@ -37,5 +37,5 @@
 
 CREATE TABLE INCOMES (
-    income_id BIGINT PRIMARY KEY,
+    income_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     user_id BIGINT
         REFERENCES FINANCE_USERS(user_id) ON DELETE CASCADE,
@@ -62,5 +62,5 @@
 
 CREATE TABLE DAILY_INTAKES (
-    daily_intake_id BIGINT PRIMARY KEY,
+    daily_intake_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     user_id BIGINT
         REFERENCES WEIGHT_USERS(user_id) ON DELETE CASCADE,
@@ -70,5 +70,5 @@
 
 CREATE TABLE TRAINING_SESSIONS (
-    training_id BIGINT PRIMARY KEY,
+    training_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     training_user_id BIGINT
         REFERENCES TRAINING_USERS(user_id) ON DELETE CASCADE,
@@ -89,5 +89,5 @@
 
 CREATE TABLE CUSTOM_TRACKING_CATEGORIES (
-    custom_tracking_id BIGINT PRIMARY KEY,
+    custom_tracking_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     user_id BIGINT
         REFERENCES USERS(user_id) ON DELETE CASCADE,
@@ -98,5 +98,5 @@
 
 CREATE TABLE TASKS (
-    task_id BIGINT PRIMARY KEY,
+    task_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     name TEXT NOT NULL,
     is_finished BOOLEAN NOT NULL DEFAULT FALSE,
@@ -118,5 +118,5 @@
 
 CREATE TABLE DAILY_COMPLETION (
-    daily_completion_id BIGINT PRIMARY KEY,
+    daily_completion_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     user_id BIGINT
         REFERENCES USERS(user_id) ON DELETE CASCADE,
@@ -141,5 +141,5 @@
 
 CREATE TABLE ASSETS (
-    asset_id BIGINT PRIMARY KEY,
+    asset_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     user_id BIGINT
         REFERENCES INVESTOR_USERS(user_id) ON DELETE CASCADE,