GD

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