github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/demo/tables.sql (about) 1 2 CREATE TABLE `biz_project` ( 3 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 4 `created_at` datetime(3) DEFAULT NULL, 5 `name` varchar, 6 `user-name` varchar, 7 `tel_phone` varchar, 8 `desc` longtext, 9 `is_default` longtext, 10 `disabled` tinyint(1) DEFAULT NULL, 11 `disabled_at` datetime(3) DEFAULT NULL, 12 `path` longtext, 13 PRIMARY KEY (`id`) 14 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; 15 16 CREATE TABLE `biz_task` ( 17 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 18 `created_at` datetime(3) DEFAULT NULL, 19 `updated_at` datetime(3) DEFAULT NULL, 20 `deleted_at` datetime(3) DEFAULT NULL, 21 `disabled` tinyint(1) DEFAULT '0', 22 `name` longtext, 23 `project_id` bigint(20) unsigned NOT NULL, 24 `project_name` longtext, 25 `disabled_at` datetime(3) DEFAULT NULL, 26 PRIMARY KEY (`id`), 27 KEY `fk_project_id_idx` (`project_id`), 28 CONSTRAINT `fk_project_id` FOREIGN KEY (`project_id`) REFERENCES `biz_project` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION 29 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;