Chapter 12 Generating Other Models from a PDM
PowerDesigner supports both physical and conceptual data types. The following table lists the physical data types to which PowerDesigner assigns translations:
| Translation example for SQL Anywhere | Code in DBMS |
What it stores |
Conceptual data type |
|---|---|---|---|
| integer | I | 32-bit integer | Integer |
| smallint | SI | 16-bit integer | Short Integer |
| integer | LI | 32-bit integer | Long Integer |
| smallint | BT | 256 values | Byte |
| numeric | N | Numbers with a fixed decimal point | Number |
| decimal | DC | Numbers with a fixed decimal point | Decimal |
| float | F | 32-bit floating decimal numbers | Float |
| real | SF | Less than 32-bit floating decimal number | Short Float |
| double | LF | 64-bit floating decimal numbers | Long Float |
| numeric | MN | Numbers with a fixed decimal point | Money |
| numeric | NO | Automatically incremented numbers | Serial |
| numeric(1) | BL | Two opposing values (true/false; yes/no; 1/0) | Boolean |
| Translation example for SQL Anywhere | DBMS |
What it stores |
Conceptual data type |
|---|---|---|---|
| char | A | Character strings | Characters |
| varchar | VA | Character strings | Variable Characters |
| varchar | LA | Character strings | Long Characters |
| long varchar | LVA | Character strings | Long Var Characters |
| long varchar | TXT | Character strings | Text |
| char | MB | Multibyte character strings | Multibyte |
| varchar | VMB | Multibyte character strings | Variable Multibyte |
| Translation example for SQL Anywhere | DBMS |
What it stores |
Conceptual data type |
|---|---|---|---|
| Date | D | Day, month, year | date |
| Time | T | Hour, minute, and second | time |
| Date & Time | DT | Date and time | timestamp |
| Timestamp | TS | System date and time | timestamp |
| Translation example for SQL Anywhere | DBMS |
What it stores |
Conceptual data type |
|---|---|---|---|
| binary | BIN | Binary strings | Binary |
| long binary | LBIN | Binary strings | Long Binary |
| long binary | PIC | Images | Image |
| long binary | BMP | Images in bitmap format (BMP) | Bitmap |
| long binary | OLE | OLE links | OLE |
| char(10) | * | User-defined data type | Other |
| <undefined> | <UNDEF> | Not yet defined data type | Undefined |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |