Skip to content

Latest commit

 

History

History
78 lines (46 loc) · 975 Bytes

README.md

File metadata and controls

78 lines (46 loc) · 975 Bytes
Raw

02-Office-Queue

Database

Counter

  • Id (primary key)

Service

  • Id (primary key)
  • Name
  • AverageTime (in minutes)

Ticket

  • Id (primary key)
  • Code
  • ServiceId (foreign key)
  • StatusId (foreign key)
  • CounterId (foreign key)

DailySetting

  • Id (primary key)
  • CounterId (foreign key)
  • ServiceId (foreign key)

History

  • Id (primary key)
  • ID (primary)
  • CounterId (foreign key)
  • ServiceId (foreign key)
  • Date

Tickt Status

  • Id (primary key)
  • status

API Stories

Get Ticket APIs

  • POST ticket

  • GET ticket

Next Customer

  • POST history

  • UPDATE Next Customer (Waiting -> Serving)

Call Customer

  • GET queue

See Stats

  • GET service type customer number

  • GET customer served by each counter

Config Counters

  • GET counters service types

  • POST counters service types

Get Estimated Time

  • GET estimated time with formula

Notify Customer Served

  • UPDATE Current Customer (Serving -> Served)