Changeset f6ed6e4 for petify-backend/sql

Timestamp:

08/22/26 19:00:38 (10 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

Location:

petify-backend/sql

Files:

• ddl.sql (modified) (3 diffs)
• dml.sql (modified) (1 diff)

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')
+                              )
 );
 

petify-backend/sql/dml.sql

@@ -116 +116 @@
 VALUES (1, (SELECT clinic_id FROM vet_clinics WHERE name='Happy Paws Clinic'));
 
-INSERT INTO user_reviews (review_id, target_user_id) VALUES
-                                                         (2, (SELECT user_id FROM users WHERE username='client.igor')),
-                                                         (3, (SELECT user_id FROM users WHERE username='client.mila'));
+INSERT INTO user_reviews (review_id, target_user_id, interaction_type) VALUES
+                                                         (2, (SELECT user_id FROM users WHERE username='client.igor'), 'PERSONAL_INTERACTION'),
+                                                         (3, (SELECT user_id FROM users WHERE username='client.mila'), 'ONLINE');
 
 INSERT INTO health_records (animal_id, appointment_id, type, description, date) VALUES