The following items should definitely be checked:
Check that tables have the proper columns.
Check foreign keys.
Provide ability to perform custom logic for specific tables (i.e. Check Web Content for missing DL links).
Check for missing database indexes (especially indexes required for upgrades).
Liferay users should be able to add their own checks for all of the above.