When you create an user, an entry gets created in the table EXTERNAL_ENTITIES in the database. The entitytype is com.atlassian.jira.user.OfbizExternalEntityStore.

Also, the entries in the table PROPERTYENTRY associated with that external entity are not deleted.

When the user is deleted, the entry in this table is not removed.

SQL changes:

Currently, EXTERNAL_ENTITIES ID is no longer associate with Entry ID. You might need to modify your SQL query to use the association below without EXTERNAL_ENTITIES to get user properties:

Tables:

app_user
propertyentry

Relationship:

app_user.ID = propertyentry.entity_id
app_user.lower_user_name = cwd_user.lower_user_name