Apache-ShenYu网关-permission table - MySQL数据库表结构设计

-- 数据库大全：Apache-ShenYu网关-permission table
-- 来源：YesApi.cn
CREATE TABLE `yesapi_resource` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` varchar(128) NOT NULL COMMENT 'resource parent primary key id',
    `title` varchar(128) NOT NULL COMMENT 'title',
    `yesapi_resource_name` varchar(32) NOT NULL COMMENT 'route name',
    `url` varchar(32) NOT NULL COMMENT 'route url',
    `component` varchar(32) NOT NULL COMMENT 'component',
    `resource_type` int(11) NOT NULL COMMENT 'resource type eg 0:main menu 1:child menu 2:function button',
    `yesapi_resource_sort` int(11) NOT NULL COMMENT 'sort',
    `icon` varchar(32) NOT NULL COMMENT 'icon',
    `is_leaf` tinyint(1) NOT NULL COMMENT 'leaf node 0:no 1:yes',
    `is_route` int(11) NOT NULL COMMENT 'route 1:yes 0:no',
    `perms` varchar(64) NOT NULL COMMENT 'button permission description sys:user:add(add)/sys:user:edit(edit)',
    `yesapi_resource_status` int(11) NOT NULL COMMENT 'status 1:enable 0:disable',
    `date_created` timestamp(3) NOT NULL COMMENT 'create time',
    `date_updated` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'update time',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'Apache-ShenYu网关-permission table';