Requirement N:M object relational mapping:
N:M relations in models shall be properly mapped to SQL tables. If here is an N:M relation between
class
A and
B a link table
ABlink shall be used that has four columns -
AOid,
AKey,
BOid and
BKey.
These four columns are automatically updated any time
an
A or
B item is
- created
- read
- updated
- deleted
The table creation command for the mapping table is automatically generated.