Data Model | | Table Model |
Association | Cardinality | | |
One To One Unidirectional on Primary Key | 1..1 | | Primary Key | |
One To One Unidirectional on Foreign Key | 1..1 | | Foreign Key | |
One To One Unidirectional on Join Table | 1..1 | | Join Table | Foreign primary keys of the Unique join table |
One To One Bidirectional on Primary Key | 1..1 | | Primary Key | |
One To One Bidirectional on Foreign Key | 1..1 | | Foreign Key | Unique foreign keys |
One To One Bidirectional on Join Table | 1..1 | | Join Table | Foreign primary keys of the Unique join table |
One To Many Unidirectional on Foreign Key | 1..* | | Foreign Key | |
One To Many Unidirectional on Join Table | 1..* | | Join Table | A foreign primary key of the Unique join table |
Many To One Unidirectional on Foreign Key | *..1 | | Foreign Key | |
Many To One Unidirectional on Join Table | *..1 | | Join Table | Foreign primary keys of the Unique join table |
Many To One Bidirectional on Foreign Key | 1..* | | Foreign Key | |
Many To One Bidirectional on Join Table | 1..* | | Join Table | Foreign primary keys of the Unique join table |
Many To Many Unidirectional | *..* | | Join Table | |
Many To Many Bidirectional | *..* | | Join Table | |