powerdesign的使用记录

短命女 2022-04-24 08:20 231阅读 0赞

### **数据类型对照表：** ###

（来源于网络）The following numeric data types are available:

<table> 
 <tbody> 
  <tr> 
   <th>Standard data type</th> 
   <th>DBMS-specific physical data type</th> 
   <th>Content</th> 
   <th>Length</th> 
  </tr> 
  <tr> 
   <td>Integer</td> 
   <td>int / INTEGER</td> 
   <td>32-bit integer</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Short Integer</td> 
   <td>smallint / SMALLINT</td> 
   <td>16-bit integer</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Long Integer</td> 
   <td>int / INTEGER</td> 
   <td>32-bit integer</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Byte</td> 
   <td>tinyint / SMALLINT</td> 
   <td>256 values</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Number</td> 
   <td>numeric / NUMBER</td> 
   <td>Numbers with a fixed decimal point</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Decimal</td> 
   <td>decimal / NUMBER</td> 
   <td>Numbers with a fixed decimal point</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Float</td> 
   <td>float / FLOAT</td> 
   <td>32-bit floating point numbers</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Short Float</td> 
   <td>real / FLOAT</td> 
   <td>Less than 32-bit point decimal number</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Long Float</td> 
   <td>double precision / BINARY DOUBLE</td> 
   <td>64-bit floating point numbers</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Money</td> 
   <td>money / NUMBER</td> 
   <td>Numbers with a fixed decimal point</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Serial</td> 
   <td>numeric / NUMBER</td> 
   <td>Automatically incremented numbers</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Boolean</td> 
   <td>bit / SMALLINT</td> 
   <td>Two opposing values (true/false; yes/no; 1/0)</td> 
   <td>—</td> 
  </tr> 
 </tbody> 
</table>

Character data types

The following character data types are available:

<table> 
 <tbody> 
  <tr> 
   <th>Standard data type</th> 
   <th>DBMS-specific physical data type</th> 
   <th>Content</th> 
   <th>Length</th> 
  </tr> 
  <tr> 
   <td>Characters</td> 
   <td>char / CHAR</td> 
   <td>Character strings</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Variable Characters</td> 
   <td>varchar / VARCHAR2</td> 
   <td>Character strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Long Characters</td> 
   <td>varchar / CLOB</td> 
   <td>Character strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Long Var Characters</td> 
   <td>text / CLOB</td> 
   <td>Character strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Text</td> 
   <td>text / CLOB</td> 
   <td>Character strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Multibyte</td> 
   <td>nchar / NCHAR</td> 
   <td>Multibyte character strings</td> 
   <td>Fixed</td> 
  </tr> 
  <tr> 
   <td>Variable Multibyte</td> 
   <td>nvarchar / NVARCHAR2</td> 
   <td>Multibyte character strings</td> 
   <td>Maximum</td> 
  </tr> 
 </tbody> 
</table>

Time data types

The following time data types are available:

<table> 
 <tbody> 
  <tr> 
   <th>Standard data type</th> 
   <th>DBMS-specific physical data type</th> 
   <th>Content</th> 
   <th>Length</th> 
  </tr> 
  <tr> 
   <td>Date</td> 
   <td>date / DATE</td> 
   <td>Day, month, year</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Time</td> 
   <td>time / DATE</td> 
   <td>Hour, minute, and second</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Date &amp; Time</td> 
   <td>datetime / DATE</td> 
   <td>Date and time</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Timestamp</td> 
   <td>timestamp / TIMESTAMP</td> 
   <td>System date and time</td> 
   <td>—</td> 
  </tr> 
 </tbody> 
</table>

Other data types

The following other data types are available:

<table> 
 <tbody> 
  <tr> 
   <th>Standard data type</th> 
   <th>DBMS-specific physical data type</th> 
   <th>Content</th> 
   <th>Length</th> 
  </tr> 
  <tr> 
   <td>Binary</td> 
   <td>binary / RAW</td> 
   <td>Binary strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Long Binary</td> 
   <td>image / BLOB</td> 
   <td>Binary strings</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Bitmap</td> 
   <td>image / BLOB</td> 
   <td>Images in bitmap format (BMP)</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Image</td> 
   <td>image / BLOB</td> 
   <td>Images</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>OLE</td> 
   <td>image / BLOB</td> 
   <td>OLE links</td> 
   <td>Maximum</td> 
  </tr> 
  <tr> 
   <td>Other</td> 
   <td>—</td> 
   <td>User-defined data type</td> 
   <td>—</td> 
  </tr> 
  <tr> 
   <td>Undefined</td> 
   <td>undefined</td> 
   <td>Undefined. Replaced by the default data type at generation.</td> 
   <td>—</td> 
  </tr> 
 </tbody> 
</table>

一、 导出已经建好的模型图/关系图：

1.首先全选或者选择你要保存的元素【Ctrl+A】

2.Edit---->Export  Image

[https://blog.csdn.net/xjy9266/article/details/80947727][https_blog.csdn.net_xjy9266_article_details_80947727]

二、导出数据库word文档表：

1.点击Report-->Reports templates  进入Report模版页面

2.点击最右边的 文件夹图标,进入选择页面,找到我们的模版文件,选好以后点击'确定',然后再点击'close'关闭

3.点击Report-->Generate Reports 进入导出页面

4.依照图片选择(备注:Generate html导出的是一个html格式的),还有就是不要忘记设置为简体中文

[https://jingyan.baidu.com/article/295430f1c385970c7f005056.html][https_jingyan.baidu.com_article_295430f1c385970c7f005056.html]

三、设计行的时候加注释：ctrl + u 勾选 comment

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjA1MzI4_size_16_color_FFFFFF_t_70][]

[https_blog.csdn.net_xjy9266_article_details_80947727]: https://blog.csdn.net/xjy9266/article/details/80947727
[https_jingyan.baidu.com_article_295430f1c385970c7f005056.html]: https://jingyan.baidu.com/article/295430f1c385970c7f005056.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjA1MzI4_size_16_color_FFFFFF_t_70]: /images/20220217/63b693ec6d044efca71062f38d34a691.png