SuzukiTakamasa / Casaparo

0 stars 0 forks source link

completed_hosueholdにtotal_amount、billing_amountカラムを追加する #30

Closed SuzukiTakamasa closed 4 months ago

SuzukiTakamasa commented 4 months ago
DROP TABLE IF EXISTS completed_households;
CREATE TABLE completed_households (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    year INTEGER NOT NULL,
    month INTEGER NOT NULL
    total_amount INTEGER NOT NULL
    billing_amount INTEGER NOT NULL
);

#[derive(Serialize, Deserialize, Debug)]
pub struct CompletedHouseholds {
    pub id: Option<u32>,
    pub year: u16,
    pub month: u8,
    pub total_amount: u32
    pub billing_amount: u32
}
SuzukiTakamasa commented 4 months ago

対応済み