v11n Lab

建表语句

考虑到目前 vue-data-board 这个项目的后端部分仍然比较简单，一些同学有针对自己项目的进行自定义二次开发的需要，所以导出了一份建表语句，供大家参考。

另外也希望使用Python开发的同学可以多多给配套的后端项目 py_vislib 提提 pr 或者 issue。


--
-- Create model Chart
--
CREATE TABLE `vislib_chart` (`chart_id` varchar(64) NOT NULL PRIMARY KEY, `chart_name` varchar(128) NOT NULL, `desc` varchar(512) NULL, `content` longtext NOT NULL, `is_private` bool NOT NULL, `status` integer NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `creator_id` integer NOT NULL);
--
-- Create model Dashboard
--
CREATE TABLE `vislib_dashboard` (`dashboard_id` varchar(64) NOT NULL PRIMARY KEY, `name` varchar(128) NOT NULL, `desc` varchar(512) NULL, `content` longtext NOT NULL, `is_private` bool NOT NULL, `status` integer NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `creator_id` integer NOT NULL);
--
-- Create model ChartBoardMap
--
CREATE TABLE `vislib_chartboardmap` (`id` varchar(64) NOT NULL PRIMARY KEY, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `chart_id` varchar(64) NOT NULL, `dashboard_id` varchar(64) NOT NULL);
--
-- Create model BoardOrder
--
CREATE TABLE `vislib_boardorder` (`order` longtext NOT NULL, `id` varchar(64) NOT NULL PRIMARY KEY, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `creator_id` integer NOT NULL);
ALTER TABLE `vislib_chart` ADD CONSTRAINT `vislib_chart_creator_id_2aba2c88_fk_auth_user_id` FOREIGN KEY (`creator_id`) REFERENCES `auth_user` (`id`);
CREATE INDEX `vislib_chart_created_at_53431df4` ON `vislib_chart` (`created_at`);
CREATE INDEX `vislib_chart_updated_at_22cbab4c` ON `vislib_chart` (`updated_at`);
ALTER TABLE `vislib_dashboard` ADD CONSTRAINT `vislib_dashboard_creator_id_dbda3628_fk_auth_user_id` FOREIGN KEY (`creator_id`) REFERENCES `auth_user` (`id`);
CREATE INDEX `vislib_dashboard_created_at_0140aa36` ON `vislib_dashboard` (`created_at`);
CREATE INDEX `vislib_dashboard_updated_at_5dace1a5` ON `vislib_dashboard` (`updated_at`);
ALTER TABLE `vislib_chartboardmap` ADD CONSTRAINT `vislib_chartboardmap_chart_id_9d2402dc_fk_vislib_chart_chart_id` FOREIGN KEY (`chart_id`) REFERENCES `vislib_chart` (`chart_id`);
ALTER TABLE `vislib_chartboardmap` ADD CONSTRAINT `vislib_chartboardmap_dashboard_id_1049cafe_fk_vislib_da` FOREIGN KEY (`dashboard_id`) REFERENCES `vislib_dashboard` (`dashboard_id`);
CREATE INDEX `vislib_chartboardmap_created_at_c959a8b6` ON `vislib_chartboardmap` (`created_at`);
CREATE INDEX `vislib_chartboardmap_updated_at_6379131b` ON `vislib_chartboardmap` (`updated_at`);
ALTER TABLE `vislib_boardorder` ADD CONSTRAINT `vislib_boardorder_creator_id_bb750d1e_fk_auth_user_id` FOREIGN KEY (`creator_id`) REFERENCES `auth_user` (`id`);
CREATE INDEX `vislib_boardorder_created_at_d9ebcc25` ON `vislib_boardorder` (`created_at`);
CREATE INDEX `vislib_boardorder_updated_at_5ba36351` ON `vislib_boardorder` (`updated_at`);


```

←