1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
| create table t_note(
id integer primary key autoincrement,
content text
);
insert into t_note(content) values (
'http://www.databaseanswers.org/data_models/restaurant_bookings/index.htm'
);
create table t_customer (
id integer primary key,
firstname text,
surname text not null,
phone_number text,
mobile_number text,
email text,
other_details text
);
create table t_booking (
id integer primary key,
date_of_booking text not null,
number_in_party int not null,
customer_id int not null
constraint t_booking_customer_id_fk references t_customer(id),
table_id int
constraint t_table_table_id_fk references t_table(id)
);
create table t_table (
id integer primary key,
table_number int,
table_details text
);
drop table t_order;
create table t_order (
id integer primary key,
order_data_time text not null,
table_id integer
constraint t_order_table_id_fk references t_table(id),
staff_id integer
constraint t_order_staff_id_fk references t_staff(id)
);
create table t_staff (
id integer primary key,
first_name text,
last_name text not null,
staff_code text
constraint t_staff_staff_code_fk references t_staff_role(code)
);
create table t_staff_role (
code text primary key,
description text
);
create table t_order_in_menuitem (
id integer primary key,
qualntity int not null,
comments text,
order_id integer constraint t_order_in_menuitem_order_id_fk references t_order(id)
);
create table t_menuitem (
id integer primary key,
price int,
description text,
menu_id integer not null constraint t_menuitem_menu_id_fk references t_menu(id)
);
create table t_menu (
id integer primary key,
menu_date text
);
create table t_ingredient_in_menuitem (
id integer primary key,
quantity int not null,
menuitem_id integer not null constraint t_menuitem_menuitem_id_fk references t_menuitem(id),
ingredients_id integer not null constraint t_ingredient_in_menuitem_ingredients_id_fk references t_ingredients(id)
);
create table t_ingredients (
id integer primary key,
name text not null,
ingredienttype_code integer not null constraint t_ingredient_ingredienttype_id_fk references t_ingredienttype(code)
);
create table t_ingredienttype (
code text primary key,
description text
);
|