ERStudio/データ型対応表

ERStudioの論理モデルと物理モデルのデータ型の対応表

• 論理モデルデータ型順

  論理モデル	物理モデル
  	Oracle10g
  BIGINT	NUMBER
  BINARY	RAW
  BIT	NUMBER(1, 0)
  CHAR	CHAR
  COUNTER	NUMBER
  DATE	DATE
  DATETIME	TIMESTAMP(6)
  DATETIMN	DATE
  DECIMAL	NUMBER
  DECIMALN	NUMBER
  DOUBLE PRECISION	BINARY_DOUBLE
  FLOAT	BINARY_FLOAT
  FLOATN	BINARY_FLOAT
  IMAGE/LONG BINARY	LONG RAW
  INTEGER	NUMBER(38, 0)
  INTERVAL	INTERVAL DAY (2) TO SECOND (0)
  INTN	NUMBER
  LONG VARCHAR	LONG
  MLSLABEL/VARCHAR	MLSLABEL
  MONEY	NUMBER
  MONEYN	NUMBER(19, 2)
  NCHAR	NCHAR
  NTEXT/LONG NVARCHAR	NCLOB
  NUMERIC	NUMBER
  NUMERICN	NUMBER
  NVARCHAR	NVARCHAR2
  PICTURE	BLOB
  REAL/SMALLFLOAT	DOUBLE PRECISION
  ROWID/VARCHAR	ROWID
  SERIAL/INTEGER	NUMBER(38, 0)
  SMALLDATETIME	DATE
  SMALLINT	NUMBER(5, 0)
  SMALLMONEY	NUMBER(7, 2)
  TEXT	CLOB
  TIME/DATETIME	DATE
  TIMESTAMP/DATE	TIMESTAMP(6)
  TINYINT	NUMBER(3, 0)
  UNIQUEID	RAW(16)
  VARBINARY/BLOB	BLOB
  VARCHAR	VARCHAR2(10)
  VARIANT	RAW(20)

   
• 論理モデルデータ型順

  論理モデル	物理モデル
  	Oracle10g
  DOUBLE_PRECISION	BINARY_DOUBLE
  FLOAT	BINARY_FLOAT
  FLOATN
  PICTURE	BLOB
  VARBINARY_BLOB
  CHAR	CHAR
  TEXT	CLOB
  DATE	DATE
  DATETIMN
  SMALLDATETIME
  TIME/DATETIME
  REAL/SMALLFLOAT	DOUBLE PRECISION
  INTERVAL	INTERVAL DAY (2) TO SECOND (0)
  LONG VARCHAR	LONG
  IMAGE/LONG BINARY	LONG RAW
  MLSLABEL/VARCHAR	MLSLABEL
  NCHAR	NCHAR
  NTEXT/LONG NVARCHAR	NCLOB
  BIGINT	NUMBER
  COUNTER
  DECIMAL
  DECIMALN
  INTN
  MONEY
  NUMERIC
  NUMERICN
  BIT	NUMBER(1, 0)
  TINYINT	NUMBER(3, 0)
  SMALLINT	NUMBER(5, 0)
  SMALLMONEY	NUMBER(7, 2)
  MONEYN	NUMBER(19, 2)
  INTEGER	NUMBER(38, 0)
  SERIAL/INTEGER
  NVARCHAR	NVARCHAR2
  BINARY	RAW
  UNIQUEID	RAW(16)
  VARIANT	RAW(20)
  ROWID/VARCHAR	ROWID
  DATETIME	TIMESTAMP(6)
  TIMESTAMP/DATE
  VARCHAR	VARCHAR2