Changes between Initial Version and Version 1 of dmlScriptVer1.sql

Timestamp:

11/20/24 17:35:56 (3 days ago)

Author:

211101

Comment:

--

dmlScriptVer1.sql

@@ +1 @@
+{{{#!sql
+INSERT INTO USER (user_name, email, password) VALUES
+('John Doe', 'john@example.com', 'password123'),
+('Jane Smith', 'jane@example.com', 'securepass'),
+('Alice Johnson', 'alice@example.com', 'alicepwd');
+
+INSERT INTO YEAR (year_name) VALUES
+(2023),
+(2024),
+(2025);
+
+INSERT INTO MONTH (year_id, month_name) VALUES
+(1, 'January'),
+(1, 'February'),
+(1, 'March'),
+(2, 'January'),
+(2, 'February');
+
+INSERT INTO DAY (month_id, day_number, day_name) VALUES
+(1, 1, 'Sunday'),
+(1, 2, 'Monday'),
+(1, 3, 'Tuesday'),
+(2, 1, 'Wednesday'),
+(2, 2, 'Thursday');
+
+INSERT INTO TAG (tag_name) VALUES
+('Food'),
+('Work'),
+('Groceries'),
+('Entertainment'),
+('Bills');
+
+INSERT INTO TRANSACTION_ACCOUNT (account_name, balance, user_id) VALUES
+('Cash', 5000.00, 1),
+('Bank Account', 20000.00, 1),
+('Credit Card', -1000.00, 2),
+('Savings', 15000.00, 2),
+('Foreign Currency', 300.00, 3);
+
+INSERT INTO TRANSACTION (transaction_name, amount, net_amount, day_id, tag_id) VALUES
+('Bought groceries', 1000.00, 800.00, 1, 1),
+('Paid rent', 15000.00, 15000.00, 2, 5),
+('Dinner with friends', 2500.00, 1500.00, 3, 2),
+('Movie tickets', 600.00, 600.00, 4, 4),
+('Electricity bill', 1200.00, 1200.00, 5, 5);
+
+INSERT INTO TRANSACTION_BREAKDOWN (transaction_id, transaction_account_id, spent_amount, earned_amount) VALUES
+(1, 1, 1000.00, 200.00),  -- Spent 1000 on Cash, earned back 200
+(1, 2, 0.00, 800.00),     -- Earned back 800 on Bank Account
+(2, 2, 15000.00, 0.00),   -- Spent 15000 on Bank Account for rent
+(3, 1, 2500.00, 1000.00), -- Spent 2500 on Cash, earned back 1000
+(4, 3, 600.00, 0.00);     -- Spent 600 on Credit Card for movie
+}}}