LLD

1. Project layout

2. Database schema — SQL DDL

  • employees
  • messages
  • tags
  • employee_tag
  • data_sources

3. API Contracts

  • GET/employee/{id}
  • GET/employee
  • POST/message/bulk_ingest
  • POST/tag
  • GET/tag
  • GET/tag/{id}
  • POST/employee_tag
  • GET/employee_tag/{employee_id}
  • POST/data_source
  • GET/data_source
  • GET/data_source/{id}
  • POST/chatbot/query
  • GET/admin/overview
0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9