CREATE TABLE Dish
(
    id             INTEGER
            primary key,
    name           TEXT,
    description    TEXT,
    menus_appeared INTEGER,
    times_appeared INTEGER,
    first_appeared INTEGER,
    last_appeared  INTEGER,
    lowest_price   REAL,
    highest_price  REAL
);
Dish
CREATE TABLE Menu
(
    id                   INTEGER
            primary key,
    name                 TEXT,
    sponsor              TEXT,
    event                TEXT,
    venue                TEXT,
    place                TEXT,
    physical_description TEXT,
    occasion             TEXT,
    notes                TEXT,
    call_number          TEXT,
    keywords             TEXT,
    language             TEXT,
    date                 DATE,
    location             TEXT,
    location_type        TEXT,
    currency             TEXT,
    currency_symbol      TEXT,
    status               TEXT,
    page_count           INTEGER,
    dish_count           INTEGER
);
Menu
CREATE TABLE MenuPage
(
    id          INTEGER
            primary key,
    menu_id     INTEGER,
    page_number INTEGER,
    image_id    REAL,
    full_height INTEGER,
    full_width  INTEGER,
    uuid        TEXT,
    foreign key (menu_id) references Menu(id)
);
MenuPage
CREATE TABLE MenuItem
(
    id           INTEGER
            primary key,
    menu_page_id INTEGER,
    price        REAL,
    high_price   REAL,
    dish_id      INTEGER,
    created_at   TEXT,
    updated_at   TEXT,
    xpos         REAL,
    ypos         REAL,
    foreign key (dish_id) references Dish(id),
    foreign key (menu_page_id) references MenuPage(id)
);
MenuItem
original_column_name,column_name,column_description,data_format,value_description
id,,unique id number indicating the dishes,integer,
name,,the name of the dish,text,
description,,description of the dish ,text,(no value)
menus_appeared,menus appeared,how many menus have this dish ,integer,
times_appeared,times appeared,how many times this dish appears in the menu,integer,"commonsense evidence:
if times_appeared > menus_appeard: this dish appeared in a menu more than once"
first_appeared,first appeared,the year that this dish appears first,integer,"commonsense evidence:
1.	the year outside of [1851, 2012], it means this data is not correct 
2.	if this dish lasts longer (last_appeared - first_appeard), it means its history is long or historical / classical"
last_appeared,last appeared,the year that this dish appears the last time,integer,"commonsense evidence:
1.	the year outside of [1851, 2012], it means this data is not correct
2.	if this dish lasts longer (last_appeared - first_appeard), it means its history is long or historical / classical"
lowest_price,lowest price,the lowest price of the dish,real,"commonsense evidence:
0: for free"
highest_price,highest price,the highest price of the dish,real,
Dish
original_column_name,column_name,column_description,data_format,value_description
id,,the unique id representing the menu item,integer,
menu_page_id,menu_page_id,the id of menu page,integer,
price,,the price of this dish (menu item),real,
high_price,high price,high price of this dish,real,
dish_id,dish_id,the id of the dish,integer,
created_at,created at,the dates when the item was created,text,
updated_at,updated at,the dates when the item was updated,text,
xpos,x position,x-axis position of the dish in this menu page,real,
ypos,y position,y-axis position of the dish in this menu page,real,
MenuItem
original_column_name,column_name,column_description,data_format,value_description
id,,the unique id number indentifying the menupage,integer,
menu_id,menu id,the id of the menu,integer,
page_number,page number,the page number ,integer,
image_id,image id,the id of the image ,real,
full_height,full height,full height of the menu page,integer,(mm)
full_width,full width,full width of the menu page,integer,(mm)
uuid,,,text,
MenuPage
original_column_name,column_name,column_description,data_format,value_description
id,,the unique number identifying the menu,integer,
name,,the name of the menu,text,"commonsense evidence:

if the value is not null or empty, it means this menu has special dishes.

otherwise, this menu is general and nothing special"
sponsor,,the sponsor of this menu,text,"commonsense evidence:

if the value is null or empyt, it means this meanu is DIY by the restaurant."
event,,the event that the menu was created for,text,
venue,,the venue that the menu was created for,text,
place,,the location that the menu was used,text, the location that the menu was used
physical_description,physical description,physical description of the menu,text,
occasion,,occasion of the menu,text,
notes,,notes,text,
call_number,,call number,text,"commonsense evidence:
if null: not support for taking out or booking in advance"
keywords,,keywords,text,not useful
language,,language,text,not useful
date,,the date that this menu was created,date,
location,,the location that the menu was used,text,
location_type,,,text,not useful
currency,,the currency that the menu was used,text,
currency_symbol,,the currency symbol,text,
status,,status of the menu,text,
page_count,page count,the number of pages of this menu,integer,
dish_count,dish count,the number of dishes of this menu,integer,
Menu