... | ... | @@ -35,10 +35,11 @@ The priority (From high to low) |
|
|
E > F > B > I > J > A > D > G > H > C
|
|
|
|
|
|
|
|
|
| customer table | | | | | |
|
|
|
| -------------- | --- | ----| ----- | ---- | ----- |
|
|
|
| customer table | | | | | | |
|
|
|
| -------------- | --- | ----| ----- | ---- | ----- | ---- |
|
|
|
|| customer_id | in_store | name | location | time | order_id |
|
|
|
|| (integer) number | (boolean) T/F | (string)customer name | (string)where seat | (string) time | (integer) number |
|
|
|
||(integer)| (boolean)| (string) | (string) | (string) | (integer)|
|
|
|
|| number | T/F | customer name | where seat | time | number(link to order table) |
|
|
|
| order table | | | |
|
|
|
|| order_id | location | time |
|
|
|
|| (integer) number| (string) where seat| (double) time | |