CREATE TABLE dashboard_user(
    id SERIAL PRIMARY KEY,
    name VARCHAR(128) NOT NULL,
    created_date DATE NOT NULL DEFAULT now(),
    updated_date DATE
);

CREATE TABLE budget(
    id SERIAL PRIMARY KEY,
    name VARCHAR(128) NOT NULL,
    amount INT NOT NULL,
    dashboard_user_id INT NOT NULL,
    business_type_id INT NOT NULL,
    created_date DATE NOT NULL DEFAULT now(),
    updated_date DATE,
    FOREIGN KEY (dashboard_user_id) REFERENCES dashboard_user(id),
    FOREIGN KEY (business_type_id) REFERENCES business_type(id)
);

ALTER TABLE account
ADD COLUMN dashboard_user_id INT;

ALTER TABLE account
ADD CONSTRAINT account_user FOREIGN KEY (dashboard_user_id) REFERENCES dashboard_user(id);

ALTER TABLE transaction
ADD COLUMN dashboard_user_id INT;

ALTER TABLE transaction
ADD CONSTRAINT transaction_user FOREIGN KEY (dashboard_user_id) REFERENCES dashboard_user(id);