展示表结构 show create table + 表名
展示ddl
CREATE TABLE `crm_dictionary` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`code` int(16) NOT NULL,
`value` varchar(256) NOT NULL,
`type` varchar(32) NOT NULL,
`remark` varchar(64) DEFAULT NULL,
`enable` tinyint(4) NOT NULL DEFAULT '1' COMMENT '配置开关(0:关闭|1:开启)',
PRIMARY KEY (`id`),
KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8 COMMENT='crm 系统字典表'