CREATE TABLE `liabilities` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint unsigned NOT NULL,
    `type` varchar(255) DEFAULT NULL,
    `amount` decimal(15,2) DEFAULT NULL,
    `description` text DEFAULT NULL,
    `liability_type` varchar(255) DEFAULT NULL,
    `creditor` varchar(255) DEFAULT NULL,
    `interest_rate` decimal(5,2) DEFAULT NULL,
    `monthly_payment` decimal(10,2) DEFAULT NULL,
    `maturity_date` date DEFAULT NULL,
    `status` varchar(255) DEFAULT NULL,
    `account_number` varchar(255) DEFAULT NULL,
    `co_borrower` varchar(255) DEFAULT NULL,
    `start_date` date DEFAULT NULL,
    `collateral` text DEFAULT NULL,
    `notes` text DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `liabilities_client_id_foreign` (`client_id`),
    CONSTRAINT `liabilities_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;