How to properly test adding entries to the directory?

Question

SQL

Hello comrades, tell me what you need to test adding / editing / deleting entries in the directory, for those who do not code?
I suppose the following checks:
- Checking the operation of the functional (so that everything is edited, added, deleted)
- Checking the validity of the fields to be filled
What else?

Answer 1

A little off topic:
The ability to delete entries from the directory is not very obvious.
After all, other records in this system can refer to this record.
Even if they are not referenced in this system, then there may be an integration of reference data with other systems (mdm, storage, etc.)
IMHO, it is better to put some kind of "inactivity" flag when trying to delete a record. Do not show entries with this flag in the interface and do not allow them to be used (up to trigger control,
if
necessary ) what we ordered, we check).
If we are talking about the so-called smoke tests, then I would additionally check the possibility of distributing access rights, audit. But it all depends on the core of the system and its capabilities.