power designer中数据类型——MySQL数据库类型转化

希愿。

已于 2023-06-05 15:10:09 修改

阅读量903

点赞数 2

分类专栏：数据库文章标签：数据库 mysql

于 2023-06-05 14:35:34 首次发布

本文链接：https://blog.csdn.net/m0_73530657/article/details/131047513

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

create table datatype
(
   "Binary (64000)"                   blob,
   "Bitmap"                           longblob,
   "Bitmap (64000)"                   longblob,
   Boolean                            bool,
   "Byte"                             tinyint,
   "Byte (8)"                         tinyint,
   "Characters (256)"                 char(256),
   Date                               date,
   "Date & Time"                      datetime,
   "Decimal"                          decimal,
   "Decimal (8)"                      decimal(8),
   "Decimal (8,2)"                    decimal(8,2),
   "Float"                            float,
   "Float (8)"                        float(8),
   Image                              longblob,
   "Image (64000)"                    longblob,
   Integer                            int,
   "Long binary"                      longblob,
   "Long binary (64000)"              longblob,
   "Long characters"                  longtext,
   "Long characters (1024)"           longtext,
   "Long float"                       double,
   "Long integer"                     bigint,
   "Long variable characters"         longtext,
   "Long variable characters (1024)"  longtext,
   Money                              float(8,2),
   "Money (8)"                        float(8,0),
   "Money (8,2)"                      float(8,2),
   "Multibyte"                        national char(1),
   "Multibyte (256)"                  national char(256),
   Number                             numeric(8,0),
   "Number (8)"                       numeric(8,0),
   "Number (8,2)"                     numeric(8,2),
   "OLE"                              longblob,
   "OLE (64000)"                      longblob,
   "Short float"                      real,
   "Short integer"                    smallint,
   Text                               text,
   "Text (256)"                       text,
   Time                               time,
   Timestamp                          timestamp,
   "Variable binary"                  VBIN,
   "Variable binary (64000)"          VBIN64000,
   "Variable characters (1024)"       varchar(1024),
   "Variable multibyte"               national varchar(255),
   "Variable multibyte (1024)"        national varchar(1024)
);

前一列是power designer中的数据类型的名字，后一列是power designer中数据对应类型转化为MySQL中的数据类型。

也可以看下面这张图片，前一列是CDM中的数据类型，后一列是PDM中的数据类型。