Use PowerDesigner 15 to design a database. The data type design of each field is really big. You need to carefully study which type is most suitable Based on the meaning of the field. Add several data type tables to favorites. ^_^
Numeric data types
| Standard ype |
DBMS-specific physical data type |
Content |
Length |
| Integer |
Int/INTEGER |
32-BitInteger |
- |
| Short Integer |
Smallint/SMALLINT |
16-BitInteger |
- |
| Long Integer |
Int/INTEGER |
32-BitInteger |
- |
| Byte |
Tinyint/SMALLINT |
256 values |
- |
| Number |
Numeric/NUMBER |
Numbers with a fixed decimal point |
Fixed |
| Decimal |
Decimal/NUMBER |
Numbers with a fixed decimal point |
Fixed |
| Float |
Float/FLOAT |
32-BitFloating point numbers |
Fixed |
| Short Float |
Real/FLOAT |
Less than 32-BitPoint decimal number |
- |
| Long Float |
Double precision/BINARY DOUBLE |
64-BitFloating point numbers |
- |
| Money |
Money/NUMBER |
Numbers with a fixed decimal point |
Fixed |
| Serial |
Numeric/NUMBER |
Automatically incremented numbers |
Fixed |
| Boolean |
Bit/SMALLINT |
Two opposing values (true/false; yes/no; 1/0) |
- |
Character data types
The following character data types are available:
| 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 |
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 |
- |
Other data types
The following other data types are available:
| 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. |
- |