PowerDesigner简单使用教程
1、首先建立物理数据模型(CDM)
概念模型(CDM Conceptual Data Model)
物理模型(PDM,Physical Data Model)
面向对象的模型(OOM Objcet Oriented Model)
业务模型(BPM Business Process Model)
选择自己使用的数据库(MySQL)
2、选中右边框中Entity(实体)这个功能,即可出现下面这个方框,(需要注意的是书写name的时候,code自行补全,name可以是英文的也可以是中文的,但是code必须是英文的。)
3、双击自己创建的表,General可修改名字,Attributes可设置名字(name)、字段名(code)、数据类型、长度等
(名字和字段名一般一致)
4、选择数据类型时,要与数据库数据类型相对应
(1)numeric data types (数值型)
(2)Character data types 字符型
Standard data type | DBMS-specific physical data type | Content | Length |
---|---|---|---|
Characters | char / CHAR | Character strings | Fixed |
Variable Characters | varchar / VARCHAR2 | Character strings | Maximum |
Long Characters | varchar / CLOB | Character strings | Maximum |
Long Var Characters | text / CLOB | Character strings | Maximum |
Text | text / CLOB | Character strings | Maximum |
Multibyte | nchar / NCHAR | Multibyte character strings | Fixed |
Variable Multibyte | nvarchar / NVARCHAR2 | Multibyte character strings | Maximum |
(3)Time data types
Standard data type | DBMS-specific physical data type | Content | Length |
---|---|---|---|
Date | date / DATE | Day, month, year | — |
Time | time / DATE | Hour, minute, and second | — |
Date & Time | datetime / DATE | Date and time | — |
Timestamp | timestamp / TIMESTAMP | System date and time | — |
(4)Other data types
Standard data type | DBMS-specific physical data type | Content | Length |
---|---|---|---|
Binary | binary / RAW | Binary strings | Maximum |
Long Binary | image / BLOB | Binary strings | Maximum |
Bitmap | image / BLOB | Images in bitmap format (BMP) | Maximum |
Image | image / BLOB | Images | Maximum |
OLE | image / BLOB | OLE links | Maximum |
Other | — | User-defined data type | — |
Undefined | undefined | Undefined. Replaced by the default data type at generation. | — |