Changes between Version 13 and Version 14 of WikiStart/DB
- Timestamp:
- 08/24/25 21:23:00 (21 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WikiStart/DB
v13 v14 4 4 * '''transaction''' (id, amount, type, timestamp, account_id*) 5 5 * '''transfer''' (id, s_id*, r_id*) 6 * '''withdraw''' (id, a_id*, amount,timestamp)7 * '''deposit''' (id, a_id*, amount,timestamp)6 * '''withdraw''' (id, a_id*, withdraw_amount, withdraw_timestamp) 7 * '''deposit''' (id, a_id*, deposit_amount, deposit_timestamp) 8 8 * '''transferred_money''' (id, s_id*, r_id*, t_id*, currency) 9 9 … … 41 41 id serial primary key, 42 42 account_id int not null, 43 amount decimal(15,2) not null,44 timestamp timestamp default current_timestamp,43 deposit_amount decimal(15,2) not null, 44 deposit_timestamp timestamp default current_timestamp, 45 45 foreign key(account_id) references account(id) 46 46 ); … … 49 49 id serial primary key, 50 50 account_id int not null, 51 amount decimal(15,2) not null,52 timestamp timestamp default current_timestamp,51 withdraw_amount decimal(15,2) not null, 52 withdraw_timestamp timestamp default current_timestamp, 53 53 foreign key(account_id) references account(id) 54 54 );