Changes between Version 1 and Version 2 of AdvancedDatabaseDevelopment

Timestamp:

08/30/26 00:27:31 (12 days ago)

Author:

236021

Comment:

--

AdvancedDatabaseDevelopment

@@ -458 +458 @@
 
 {{{
--- one shared trigger function, reused for both billing_procedures and billing_lab_tests
--- (both tables have a bill_id column, so NEW.bill_id / OLD.bill_id works either way)
+
 CREATE OR REPLACE FUNCTION t1_billing_line_item_changed()
 RETURNS TRIGGER
@@ -563 +562 @@
 ALTER TABLE lab_tests ALTER COLUMN cost TYPE non_negative_cost USING cost::non_negative_cost;
 ALTER TABLE billing ALTER COLUMN total_cost TYPE non_negative_cost USING total_cost::non_negative_cost;
-
--- run these BEFORE altering embg / email / phone columns — every one of these
--- should return ZERO rows, otherwise the corresponding ALTER will fail:
---   SELECT patient_id, embg FROM patients WHERE embg !~ '^\d{13}$';
---   SELECT doctor_id, email_address FROM doctors WHERE email_address !~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$';
---   SELECT patient_id, email_address FROM patients WHERE email_address IS NOT NULL AND email_address !~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$';
---   SELECT patient_id, phone_number FROM patients WHERE phone_number IS NOT NULL AND phone_number !~ '^\+?[\d\s\-().]{7,20}$';
 }}}