Data Type of PowerDesigner

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.	-