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;