There are 18 kind of different scenarios for basefield:
- non-translatable and non-revisionable entity with basefield with cardnality 1. One DB table: base Field column(s) in base table
- non-translatable and non-revisionable entity with basefield with cardnality greater than 1. Two DB tables: base, field table Field column(s) in field table
- translatable and non-revisionable entity with basefield with cardnality 1. Two DB tables: base, data Field column(s) in data table
- non-translatable basefield.
- translatable basefield.
- translatable and non-revisionable entity with basefield with cardnality greater than 1. Three DB tables: base, data, field table Field column(s) in field table
- non-translatable basefield.
- translatable basefield.
- non-translatable and revisionable entity with basefield with cardnality 1. Two DB tables: base, revision
- non-revisionable basefield. Field column(s) in base table
- revisionable basefield. Field column(s) in base table and revision table
- non-translatable and revisionable entity with basefield with cardnality greater than 1.
- non-revisionable basefield. Threes DB tables: base, revision, field table Field column(s) in field table
- revisionable basefield. Four DB tables: base, revision, field table, field revision table Field column(s) in field table and field revision table
- translatable and revisionable entity with basefield with cardnality 1. Four DB tables: base, data, revision, data revision
- non-translatable and non-revisionable basefield Field column(s) in data table
- translatable and non-revisionable basefield Field column(s) in data table
- non-translatable and revisionable basefield Field column(s) in data table and revision table
- translatable and revisionable basefield Field column(s) in data table and revision table
- translatable and revisionable entity with basefield with cardnality greater than 1.
- non-translatable and non-revisionable basefield Five DB tables: base, data, revision, data revision, field table Field column(s) in field table
- translatable and non-revisionable basefield Five DB tables: base, data, revision, data revision, field table Field column(s) in field table
- non-translatable and revisionable basefield Six DB tables: base, data, revision, data revision, field table, field revision table Field column(s) in field table and field revision table
- translatable and revisionable basefield Six DB tables: base, data, revision, data revision, field table, field revision table Field column(s) in field table and field revision table
And now multiply 18 with 3 because we support three databases driver in core.
This is not it a basefield can also have more then one DB column as well.