Draft Data model¶
products¶
id int (pk)
name varchar
variety varchar (optional)
alt_name varchar (optional)
description text
origin varchar? (optional)
season varchar (string describing season?)
available bool (optional, is or is not available now?)
market_price varchar
link url (optional, link to industry info site)
image_id int (optional, image foreign key)
stories_id int (optional, image foreign key)
created datetime
modified datetime (auto-update on modification)
vendors¶
id int (pk)
name varchar
status bool (optional, in or out)
description text
lat float
long float
street varchar
city varchar
state varchar
zip varchar
location_description text (optional)
contact_name varchar
phone varchar (optional)
website url (optional)
email email (optional)
stories_id int (optional, story foreign key)
created datetime
updated datetime (auto-update on modification)
stories¶
id int (pk)
name varchar
history text
facts text
buying text
preparing text
products text
season text
created datetime
updated datetime (auto-update on modification)
images¶
id int (pk)
image image (file)
caption text (optional)
name text
created datetime
updated datetime (auto-update on modification)
videos¶
id int (pk)
video url
name text
caption text (optional)
created datetime
updated datetime (auto-update on modification)
preparations¶
id int (pk)
name varchar
description text (optional)
additional_info text (optional)
products_preparations¶
product_id int (foreign key to product)
preparation_id int (foreign key to preparation)
vendors_products¶
vendors_id int (vendors foreign key)
products_id int (products foreign key)
preparation_id int (preparation foreign key)
vendor_price varchar (optional)
available bool (optional, has this product right now?)