foodmap
Tables (5)
coordinates
- id — int(11) — Primary key — NOT NULL
- storeId — int(11) — Foreign key → store.id — NOT NULL
- Lat — int(11) — NOT NULL
- Lng — int(11) — NOT NULL
feedback
- id — int(11) — Primary key — NOT NULL
- content — char(255) — NOT NULL
- timestamp — int(11) — NOT NULL
images
- id — int(11) — Primary key — NOT NULL
- storeId — int(11) — Foreign key → store.id — NOT NULL
- url — text — NOT NULL
menu
- id — int(11) — Primary key — NOT NULL
- storeId — int(11) — Foreign key → store.id — NOT NULL
- name — char(255) — NOT NULL
- price — int(11) — NOT NULL
store
- id — int(11) — Primary key — NOT NULL
- name — char(255) — NOT NULL
- description — text — NOT NULL
- season — int(11) — NOT NULL
- characteristic — char(255) — NOT NULL
- foodKind — char(255) — NOT NULL
- address — char(255) — NOT NULL
- phone — char(255) — NOT NULL