search

buerokratt / Buerokratt-Chatbot

1 stars 14 forks source link

Database refactoring for Chatbot #411

Open turnerrainer opened 5 months ago

turnerrainer commented 5 months ago

AS AN Architect I WANT Chatbot Postgres databases and their tables to be refactored SO THAT they would be compliant with best practices

Acceptance Criteria

1AhmedYasser commented 5 months ago

Changes proposed to db

  1. allowed_status: No Changes
  2. authority: No Changes
  3. chat: - feedback rating to int, - remove external id
  4. chat_history_comments: No Changes
  5. configuration: No Changes
  6. customer_support_agent_activity: - active to boolean
  7. establishment: is this table needed ?
  8. message: - rating to int
  9. message_preview: No Changes
  10. scheduled_reports: No Changes
  11. user: - status to enum
  12. user_authority: No Changes
  13. user_overview_metric_preference: No Changes
  14. user_profile_settings: No Changes