Chapter 4. Physical modeling in the UML

Table of Contents

Entities
Columns
Primary keys
Foreign Keys
Primitive types
User-defined types
Structured types
Column names
Mandatory columns
CHECK
DEFAULT
Relationships
1:1
1:N
Composition
M:N
Associative relationship
N-ary associations
Generalisation
Deployment parameters

PSQL defines modeling rules for Class Association Diagrams to support ER modeling using UML.

These rules concerns esspecially associations.

Entities

Tables are represented by classes. These classes do not have any stereotype typedef. Classes having stereotype typedef are used as synonyms for database types or as complex types (or structured types) - eg. address containing street, town and ZIP code.

Class name is used as a table name. If class has defined abbreviation (XMI contains tagged value abbrev), then this abbreviation is used as a table name.