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