Changes between Version 14 and Version 15 of WikiStart/DB

Timestamp:

08/24/25 21:31:53 (20 hours ago)

Author:

203206

Comment:

db2

WikiStart/DB

@@ -40 +40 @@
 create table deposit(
     id serial primary key,
-    account_id int not null,
+    a_id int not null,
     deposit_amount decimal(15,2) not null,
     deposit_timestamp timestamp default current_timestamp,
-    foreign key(account_id) references account(id)
+    foreign key(a_id) references account(id)
 );
 
 create table withdraw(
     id serial primary key,
-    account_id int not null,
+    a_id int not null,
     withdraw_amount decimal(15,2) not null,
     withdraw_timestamp timestamp default current_timestamp,
-    foreign key(account_id) references account(id)
+    foreign key(a_id) references account(id)
 );