Changes between Version 1 and Version 2 of OtherTopics

Timestamp:

09/24/26 00:41:04 (4 hours ago)

Author:

236021

Comment:

--

OtherTopics

@@ -203 +203 @@
 
 {{{
+
 WITH record_ids AS (
     SELECT array_agg(record_id) AS ids FROM medical_records
+),
+admin_ids AS (
+    SELECT array_agg(admin_id) AS ids FROM admin
 ),
 base AS (
@@ -213 +217 @@
     FROM generate_series(1, 1000000) gs
 )
-INSERT INTO billing (bill_id, record_id, total_cost, payment_status, payment_date, created_at)
+INSERT INTO billing (bill_id, record_id, admin_id, total_cost, payment_status, payment_date, created_at)
 SELECT
     (SELECT COALESCE(MAX(bill_id), 0) FROM billing) + gs,
     (SELECT ids[floor(random()*array_length(ids,1))+1] FROM record_ids),
+    (SELECT ids[floor(random()*array_length(ids,1))+1] FROM admin_ids),
     (random() * 2000 + 20)::numeric(12,2),
     status,