oxidized_builder/data/
schema.rs

1use chrono::NaiveDateTime;
2use sqlx::FromRow;
3
4#[derive(Debug, FromRow)]
5pub struct TransactionRecord {
6    pub id: i64,
7    pub tx_hash: String,
8    pub chain_id: i64,
9    pub block_number: Option<i64>,
10    pub from_address: String,
11    pub to_address: Option<String>,
12    pub value_wei: String,
13    pub gas_used: Option<i64>,
14    pub gas_price_wei: Option<String>,
15    pub status: Option<bool>,
16    pub strategy: Option<String>,
17    pub timestamp: NaiveDateTime,
18    pub execution_time_ms: Option<f64>,
19}
20
21#[derive(Debug, FromRow)]
22pub struct ProfitRecord {
23    pub id: i64,
24    pub tx_hash: String,
25    pub chain_id: i64,
26    pub strategy: String,
27    pub profit_eth: f64,
28    pub gas_cost_eth: f64,
29    pub net_profit_eth: f64,
30    pub timestamp: NaiveDateTime,
31}