This best practice sounds scary but it just means that you either use an id
and/or guid
column instead of just a natural primary key.
id
s have smaller storage size than e.g. an IBAN. Each foreign key for the given IBAN would also store the full IBAN data.In our exercises you will also find that we apply an id
column for m:n relationship tables: