PowerDesigner类型与MySQL对应关系

以mysql为例:
PD标准数据类型 关系型数据库-数据类型 容量 长度
Integer int/INTEGER 32-bit integer
Short Integer smallint/SMALLINT 16-bit integer
Long Integer int/INTEGER 32-bit integer
Byte tinyint/SMALLINT 256 values
Number numeric/NUMBER Numbers with a fixed decimal point 固定长度
Decimal decimal/NUMBER Numbers with a fixed decimal point 固定长度
Float float/FLOAT 32-bit floating point numbers 固定长度
Short Float real/FLOAT Less than 32-bit point decimal number
Long Float double
precision/BINARY DOUBLE
64-bit floating point numbers
Money money/NUMBER Numbers with a fixed decimal point 固定长度
Serial numeric/NUMBER Automatically incremented numbers 固定长度
Boolean bit/SMALLINT Two opposing values (true/false; yes/no; 1/0)