g
Tables (5)
city
- cityname — VARCHAR(20) — Primary key — NOT NULL
- selection — VARCHAR(20) — NOT NULL
local
- localname — VARCHAR(20) — Primary key — NOT NULL
- cityname — VARCHAR(20) — Foreign key → city.cityname — NOT NULL
- selection — VARCHAR(20) — NOT NULL
reservation
- phone — VARCHAR(11) — Foreign key → user.phone — NOT NULL
- seatnumber — INT — NOT NULL
- date — VARCHAR(10) — NOT NULL
- starttime — VARCHAR(40) — NOT NULL
- storename — VARCHAR(20) — Foreign key → store.storename — NOT NULL
- localname — VARCHAR(20) — Foreign key → store.localname — NOT NULL
- cityname — VARCHAR(20) — Foreign key → store.cityname — NOT NULL
store
- storename — VARCHAR(20) — Primary key — NOT NULL
- localname — VARCHAR(20) — Foreign key → local.localname — NOT NULL
- cityname — VARCHAR(20) — Foreign key → local.cityname — NOT NULL
- selection — VARCHAR(20) — NOT NULL
user
- phone — VARCHAR(11) — Primary key — NOT NULL
- password — VARCHAR(20) — NOT NULL