sdsdsd
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
- seatnumber — int(11) — 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
- userID (Field)
- userPassword (Field2)
- Field3
- Field4