Changes between Version 1 and Version 2 of ddlScript.sql

Timestamp:

12/13/24 00:00:54 (5 weeks ago)

Author:

211101

Comment:

--

ddlScript.sql

@@ -7 +7 @@
 DROP TABLE IF EXISTS tag CASCADE;
 DROP TABLE IF EXISTS "user" CASCADE;
+DROP TABLE IF EXISTS tag_assigned_to_transaction CASCADE;
 
 -- Create USER table
@@ -48 +49 @@
     earned_amount DECIMAL(10, 2)
 );
+
+-- Create TAG_ASSIGNED_TO_TRANSACTION table
+CREATE TABLE tag_assigned_to_transaction (
+    tag_assigned_to_transaction_id SERIAL PRIMARY KEY,
+    tag_id INT REFERENCES tag(tag_id),
+    transaction_id INT REFERENCES transaction(transaction_id)
+);
 }}}