eurekaclinical / eureka

RETIRED - Clinical phenotyping and ETL system
http://www.eurekaclinical.org/docs/analytics/
Apache License 2.0
2 stars 11 forks source link

Eureka-services USERS table needs UPDATED and DELETED columns #112

Open arpost opened 8 years ago

arpost commented 8 years ago

User records with a non-null DELETED column should be considered deleted. This should be populated with the current timestamp when a DELETE REST call is made on a user record. User should be subsequently unable to login.

There should be an easy way in Eureka to filter out user records with a non-null DELETED column.

UPDATED should be when any column other than LASTLOGIN is changed.

Consider a trigger for the implementation.