Changeset f6ed6e4 for petify-backend/sql/ddl.sql

Timestamp:

08/22/26 19:00:38 (8 hours ago)

Author:

veronika-ils <ilioskaveronika@…>

Branches:

master

Parents:

ae83647

Message:

feat: The app is consistent with the changes made in phase 1 and phase 2

File:

• petify-backend/sql/ddl.sql (modified) (3 diffs)

petify-backend/sql/ddl.sql

@@ -107 +107 @@
                              city      VARCHAR(80)  NOT NULL,
                              address   VARCHAR(200) NOT NULL,
+                             work_days VARCHAR(120),
+                             start_time TIME,
+                             end_time   TIME,
                              user_id   BIGINT       UNIQUE,
                              application_id BIGINT UNIQUE,
@@ -227 +230 @@
                               review_id      BIGINT,
                               target_user_id BIGINT NOT NULL,
+                              interaction_type VARCHAR(40) NOT NULL,
 
                               CONSTRAINT user_reviews_PK PRIMARY KEY (review_id),
@@ -234 +238 @@
                               CONSTRAINT user_reviews_target_FK FOREIGN KEY (target_user_id)
                                   REFERENCES users(user_id)
-                                  ON DELETE RESTRICT
+                                  ON DELETE RESTRICT,
+                              CONSTRAINT user_reviews_interaction_type_CHK CHECK (
+                                  interaction_type IN ('EVENT', 'PERSONAL_INTERACTION', 'ONLINE', 'PHONE_CALL', 'OTHER')
+                              )
 );