sdsd

Tables (3)

local

  • localname — varchar(20) — Primary key — NOT NULL
  • cityname — varchar(20) — Primary key — NOT NULL
  • selection — varchar(20) — NOT NULL

store

  • localname — varchar(20) — Foreign key → store.localname — NOT NULL
  • cityname — varchar(20) — Foreign key → store.cityname — NOT NULL
  • storename — varchar(20) — Foreign key → store.storename — NOT NULL
  • selection — varchar(20) — NOT NULL
  • seatnumber — int(11) — NOT NULL
  • date — varchar(10) — NOT NULL
  • starttime — varchar(40) — NOT NULL
  • storename — varchar(20) — NOT NULL
  • localname — varchar(20) — NOT NULL
  • cityname — varchar(20) — NOT NULL

user

  • phone — varchar(11) — Primary key — NOT NULL
  • password — varchar(20) — NOT NULL
  • selection — varchar(20) — NOT NULL