Please enable JavaScript to view this site.

Altova UModel 2020 Professional Edition

The table below shows the one-to-one correspondence between:

 

UModel elements and database elements, when outputting model to code

Database elements and UModel model elements, when inputting code into model

 

Database

UModel

Database

connection

connection

Component

Database

name

name

Package <<namespace>> <<Database>>

Schema

name

name

Package <<namespace>> <<Schema>>

Table

name

name

Class

<<Table>>

Column

name

name

Property

Data Type

type

Not Null

<<not_null>>

Null

<<nullable>>

Length

Multiplicity

Precision

Scale

Default

default

Autoincrement

<<autoincrement>>

Part of Primary Key

<<PK>>

Part of Foreign Key

<<FK>>

Part of Unique Key

<<unique>>

Primary Key

name

name

Class

<<PrimaryKey>>

Column

name

name

Property

Foreign Key

name

name

Class

<<ForeignKey>>

Column

name

name

Property

Foreign Column

name

name

Property

foreign table

type

Unique Key

name

name

Class

<<UniqueKey>>

Column

name

name

Property

Index

name

name

Class

<<Index>>

Column

name


Property

order: ascending

<<ascending>>

order: ascending

<<descending>>

CheckConstraint

name

name

Class

<<CheckConstraint>>

definition


definition


View

name

name

Class

<<View>>

definition

definition

Column

name

name

Property

Data Type

type

Not Null

<<not_null>>

Null

<<nullable>>

Length

Multiplicity

Precision

Scale

Default

default

Autoincrement

<<autoincrement>>

Stored

Procedure

name

name

Operation

<<StoredProcedure>>

Class

<<StoredProcedures>>

definition

definition

Parameter

name

name

Parameter

direction mode

direction

data type

type

Function

name

name

Operation

<<Function>>

Class

<<Functions>>

definition

definition

Parameter

name

name

Parameter

direction mode

direction

data type

type

Trigger

name

name

Class

<<Trigger>>

definition

definition

© 2019 Altova GmbH