search

KarthikElumalai / ETokenSln

E-Token is an online queue management system which reduces waiting time on queue, by providing live update about queue status in electronic gadgets.
https://docs.google.com/document/d/17VGdqFPdmcJriHd8aXy-ymutrQ4LejnVDnfiH8N8hms/edit
10 stars 6 forks source link

Queue Management Entity Creation Part 1 #25

Closed nilanjansen closed 5 years ago

nilanjansen commented 5 years ago

API specific Entities Queue-> Queue Id(Unique) BusinessBranchCategoryId(fk) Queue Name "Hair Cut" Int resource(2 hairstylist per queue) WaitTime NoOfTokens IsClose

Token-> TokenId, TokenValue,IsExpired

STATUS-> StatusId StatusName

TokenStatus-> TokenID StatusId

QueueToken-> QueueTokenId QueueId TokenId

BusinessQueue-> BusinessQueueId(key) BranchCategoryId(composite key (fk)) QueueId(fk)

Branch-> BranchId Business Id BranchName IsClose

BusinessBranchCategory-> BusinessBranchCategoryID, Business Id, BranchId CategoryId

nilanjansen commented 5 years ago

1 BUSINESS belongs to a specific BUSINESS CATEGORY 1Business can have multiple BRANCH 1 BRANCH can have multiple CATEGORIES e.g. hoslital has different speciality 1 category can have 1 or n QUEUE 1 queue will have n TOKEN

nilanjansen commented 5 years ago

Duplicate Issue