Schema - adamnew123456/426project GitHub Wiki

CREATE TABLE Bill(
    id integer primary key auto_increment not null,
    title varchar(512) not null,
    summary varchar(1024) not null,
    cbo_url varchar(256) not null,
    pdf_url varchar(256) not null
);

CREATE TABLE Finances(
    id integer primary key auto_increment not null,
    bill integer not null,
    timespan integer not null,
    amount double not null,

    foreign key (bill) references Bill(id)
);