Changes between Version 15 and Version 16 of WikiStart/DB

Timestamp:

08/24/25 21:34:22 (20 hours ago)

Author:

203206

Comment:

mk2

WikiStart/DB

@@ -2 +2 @@
 
 * '''account''' (id, username, e-mail, password, balance)
-* '''transaction''' (id, amount, type, timestamp, account_id*)
+* '''transaction''' (id, amount, type, timestamp, a_id*)
 * '''transfer''' (id, s_id*, r_id*)
 * '''withdraw''' (id, a_id*, withdraw_amount, withdraw_timestamp)
@@ -24 +24 @@
     type varchar(50) not null,
     timestamp timestamp default current_timestamp,
-    account_id int not null,
-    foreign key (account_id) references account(id)
+    a_id int not null,
+    foreign key (a_id) references account(id)
 );
 
@@ -56 +56 @@
 create table transferred_money(
     id serial primary key, 
-    s_account_id int not null, 
-    r_account_id int not null, 
+    s_id int not null, 
+    r_id int not null, 
     t_id int not null, 
     currency varchar(50) not null, 
-    foreign key (s_account_id) references account(id),
-    foreign key (r_account_id) references account(id),
+    foreign key (s_id) references account(id),
+    foreign key (r_id) references account(id),
     foreign key (t_id) references transaction(id)
 );