PowerDesigner中CDM和PDM数据类型的mapping

Conceptual data typeDBMS-specific physical data typeContentLengthIntegerint / INTEGER32-bit integer Short Integersmallint / SMALLINT16-bit integer Long Integerint / INTEGER32-bit integer Bytetinyint / SMALLINT256 values Numbernumeric / NUMBERNumbers with a fixed decimal pointFixedDecimaldecimal / NUMBERNumbers with a fixed decimal pointFixedFloatfloat / FLOAT32-bit floating point numbersFixedShort Floatreal / FLOATLess than 32-bit point decimal number Long Floatdouble precision / BINARY DOUBLE64-bit floating point numbers Moneymoney / NUMBERNumbers with a fixed decimal pointFixedSerialnumeric / NUMBERAutomatically incremented numbersFixedBooleanbit / SMALLINTTwo opposing values (true/false; yes/no; 1/0) Characterschar / CHARCharacter stringsFixedVariable Charactersvarchar / VARCHAR2Character stringsMaximumLong Charactersvarchar / CLOBCharacter stringsMaximumLong Var Characterstext / CLOBCharacter stringsMaximumTexttext / CLOBCharacter stringsMaximumMultibytenchar / NCHARMultibyte character stringsFixedVariable Multibytenvarchar / NVARCHAR2Multibyte character stringsMaximumDatedate / DATEDay, month, year Timetime / DATEHour, minute, and second Date & Timedatetime / DATEDate and time Timestamptimestamp / TIMESTAMPSystem date and time Binarybinary / RAWBinary stringsMaximumLong Binaryimage / BLOBBinary stringsMaximumBitmapimage / BLOBImages in bitmap format (BMP)MaximumImageimage / BLOBImagesMaximumOLEimage / BLOBOLE linksMaximumOther User-defined data type UndefinedundefinedNot yet defined data type