数据库表设计

SELECT
UPPER(COLUMN_NAME) 字段名称,
UPPER(DATA_TYPE) 字段类型,
CHARACTER_MAXIMUM_LENGTH 长度,
COLUMN_COMMENT 备注,
'否' as 主键,
'否' as 外键,
-- COLUMN_TYPE 数据类型,
CASE when IS_NULLABLE='YES' then '是' else '否' END 是否为空 ,
COLUMN_DEFAULT 默认值
FROM
INFORMATION_SCHEMA.COLUMNS
where
-- table_schema ='jeecgboot' AND
table_name = 'sys_user'