Changes between Version 1 and Version 2 of WikiStart/Optimization/vtora_verzija

Timestamp:

04/01/25 21:56:18 (2 months ago)

Author:

203206

Comment:

mk1

WikiStart/Optimization/vtora_verzija

@@ -35 +35 @@
     id serial primary key,
     account_id int not null,
+    transaction_id int not null,
     amount decimal(15,2) not null,
-    timestamp timestamp default current_timestamp,
-    foreign key(account_id) references account(id)
+    foreign key(account_id) references account(id),
+    foreign key(transaction_id) references transaction(id)
 );
 
@@ -43 +44 @@
     id serial primary key,
     account_id int not null,
+    transaction_id int not null,
     amount decimal(15,2) not null,
-    timestamp timestamp default current_timestamp,
-    foreign key(account_id) references account(id)
+    foreign key(account_id) references account(id),
+    foreign key(transaction_id) references transaction(id)
 );