Changeset 8615885 for db-scripts/ddl.sql
- Timestamp:
- 02/09/26 22:17:45 (5 months ago)
- Branches:
- master
- Children:
- 5c20c64
- Parents:
- 3ebe47c
- File:
-
- 1 edited
-
db-scripts/ddl.sql (modified) (7 diffs)
Legend:
- Unmodified
- Added
- Removed
-
db-scripts/ddl.sql
r3ebe47c r8615885 37 37 38 38 CREATE TABLE INCOMES ( 39 income_id BIGINT PRIMARY KEY,39 income_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 40 40 user_id BIGINT 41 41 REFERENCES FINANCE_USERS(user_id) ON DELETE CASCADE, … … 62 62 63 63 CREATE TABLE DAILY_INTAKES ( 64 daily_intake_id BIGINT PRIMARY KEY,64 daily_intake_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 65 65 user_id BIGINT 66 66 REFERENCES WEIGHT_USERS(user_id) ON DELETE CASCADE, … … 70 70 71 71 CREATE TABLE TRAINING_SESSIONS ( 72 training_id BIGINT PRIMARY KEY,72 training_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 73 73 training_user_id BIGINT 74 74 REFERENCES TRAINING_USERS(user_id) ON DELETE CASCADE, … … 89 89 90 90 CREATE TABLE CUSTOM_TRACKING_CATEGORIES ( 91 custom_tracking_id BIGINT PRIMARY KEY,91 custom_tracking_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 92 92 user_id BIGINT 93 93 REFERENCES USERS(user_id) ON DELETE CASCADE, … … 98 98 99 99 CREATE TABLE TASKS ( 100 task_id BIGINT PRIMARY KEY,100 task_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 101 101 name TEXT NOT NULL, 102 102 is_finished BOOLEAN NOT NULL DEFAULT FALSE, … … 118 118 119 119 CREATE TABLE DAILY_COMPLETION ( 120 daily_completion_id BIGINT PRIMARY KEY,120 daily_completion_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 121 121 user_id BIGINT 122 122 REFERENCES USERS(user_id) ON DELETE CASCADE, … … 141 141 142 142 CREATE TABLE ASSETS ( 143 asset_id BIGINT PRIMARY KEY,143 asset_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 144 144 user_id BIGINT 145 145 REFERENCES INVESTOR_USERS(user_id) ON DELETE CASCADE,
Note:
See TracChangeset
for help on using the changeset viewer.
