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