CREATE TABLE `transactions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `business_id` int(11) NOT NULL,
    `date_of_sale` date NOT NULL,
    `sale_amount` decimal(10,2) NOT NULL,
    `purchaser_name` varchar(255) NOT NULL,
    `notes` text NOT NULL,
    PRIMARY KEY (`id`),
    FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`)
);
