Data integrity

Data integrity is very important in maintaining how tables and data relationships are defined and protected. There are four types of integrity: user defined, referential, entity, and domain.

The mastering of data manipulation, database design, development, and administration is key to ensure that applications built using SQLite perform well, and are kept free from data crashes, data corruptions, and security issues.

When a column's datatype is set, it is a form of data integrity. Data integrity can be enhanced by only allowing certain values.

When a mechanism is designed to maintain the primary keys in a table by a unique tuple or row identifier, it is known as entity integrity.

Referential integrity occurs when, for example, two tables are linked by a common column datatype and no new data can be added to one table without being added to the second. Referential integrity ensures that data is cleaned and linked properly.