search

Karyum / delivery-connect

1 stars 0 forks source link

db structure #2

Open Karyum opened 4 years ago

Karyum commented 4 years ago

Everything here is open for change 😄

deliveryUsers

id name phone password mobile?

We need a better name for delivery users, delivery person and delivery guys/gals. so please if you have a better name or code name suggest it 😭

deliveryUsersSessions

id startTime endTime deliveryUserId

a session is where the delivery person clocks in and is open to take orders

businessUsers

id email password lat lng name

typically it would be a restaurant owner/worker

deliveryHistory

id deliveryUserId businessUsersId created_at

once an ordered has been delivered it would be added to the history

signupInvites

id expiresAt code wasUsed

authorize users who has received the invite to be able to sign up to the app.

Karyum commented 4 years ago

probably going to make all of this in firebase for consistency

Karyum commented 4 years ago

nope changed my mind, going to use good old sql and sockets

Karyum commented 4 years ago

important

removed deliveryUsers and businessUsers table

users

id phone password created_at role deviceId email