SELECT C.TABLE_SCHEMA, T.TABLE_NAME AS tableName, C.COLUMN_NAME AS fieldName, C.COLUMN_COMMENT AS fieldNameCn, C.ORDINAL_POSITION AS fieldOrder
, C.COLUMN_DEFAULT AS defaultValue, C.IS_NULLABLE AS fieldConstraint, C.DATA_TYPE AS fieldType, C.CHARACTER_MAXIMUM_LENGTH AS dataLength, C.NUMERIC_PRECISION AS dataPrecision
, C.NUMERIC_SCALE AS dataScale
FROM INFORMATION_SCHEMA.`TABLES` T
LEFT JOIN information_schema.`COLUMNS` C
ON T.TABLE_NAME = C.TABLE_NAME
AND T.TABLE_SCHEMA = C.TABLE_SCHEMA
WHERE T.TABLE_SCHEMA = (
SELECT DATABASE()
)
AND T.TABLE_NAME = 'app_cdt_fund_wy_business_promotion_push_total'
