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

-- 数据库大全：Apache-ShenYu网关-api
-- 来源：YesApi.cn
CREATE TABLE `yesapi_api` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `context_path` varchar(255) NOT NULL COMMENT 'the context_path',
    `api_path` varchar(255) NOT NULL COMMENT 'the api_path',
    `http_method` int(11) NOT NULL COMMENT '0-get,1-head,2-post,3-put,4-patch,5-delete,6-options,7-trace',
    `consume` varchar(255) NOT NULL COMMENT 'consume content-type',
    `produce` varchar(255) NOT NULL COMMENT 'produce content-type',
    `version` varchar(255) NOT NULL COMMENT 'api version,for example V0.01',
    `rpc_type` varchar(64) NOT NULL COMMENT 'http,dubbo,sofa,tars,websocket,grpc',
    `state` tinyint(4) NOT NULL COMMENT '0-unpublished,1-published,2-offline',
    `ext` varchar(1024) NOT NULL COMMENT 'extended fields',
    `api_owner` varchar(255) NOT NULL COMMENT 'api_owner',
    `api_desc` varchar(1024) NOT NULL COMMENT 'the api description',
    `api_source` int(11) NOT NULL COMMENT '0-swagger,1-annotation generation,2-create manually,3-import swagger,4-import yapi',
    `document` text NOT NULL COMMENT 'complete documentation of the api, including request parameters and response parameters',
    `document_md5` char(32) NOT NULL COMMENT 'document_md5',
    `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网关-api';