2020-01-25 22:16:08 +01:00
|
|
|
This is just a description of the database schema. It's not generated automatically, nor is it used
|
2020-01-26 02:39:58 +01:00
|
|
|
to automatically generate anything. For the latest version, check the files in app/models/
|
2020-01-25 22:16:08 +01:00
|
|
|
|
|
|
|
|
|
|
|
|
|
user
|
2020-02-29 17:23:20 +01:00
|
|
|
username
|
|
|
|
|
is_admin
|
|
|
|
|
bias
|
2020-01-25 22:16:08 +01:00
|
|
|
|
|
|
|
|
order
|
2020-02-29 17:23:20 +01:00
|
|
|
id
|
|
|
|
|
courier_id
|
|
|
|
|
location_id HLDS identifier
|
|
|
|
|
location_name this allows historical orders to keep the same location name
|
|
|
|
|
starttime
|
|
|
|
|
stoptime
|
|
|
|
|
public
|
2020-01-25 22:16:08 +01:00
|
|
|
|
|
|
|
|
order_item
|
2020-02-29 17:23:20 +01:00
|
|
|
id
|
|
|
|
|
order_id
|
|
|
|
|
user_id
|
|
|
|
|
user_name for users who are not logged in
|
|
|
|
|
dish_id HLDS identifier
|
|
|
|
|
dish_name ) this allows historical orders to keep their correct name and price
|
|
|
|
|
price )
|
|
|
|
|
paid
|
|
|
|
|
comment
|
|
|
|
|
hlds_data_version Git commit hash to identify HLDS data version
|
2020-01-25 22:16:08 +01:00
|
|
|
|
|
|
|
|
order_item_choice
|
2020-02-29 17:23:20 +01:00
|
|
|
id
|
|
|
|
|
order_item_id
|
|
|
|
|
choice_id HLDS identifier
|
|
|
|
|
kind single_choice/multi_choice
|
|
|
|
|
name
|
|
|
|
|
value just a textual description of the chosen values
|
