seatlock

Tables (4)

RENT (Untitled3)

  • userID — varchar(20) — Primary key — NOT NULL
  • qrcode — varchar(20)

RESERVATION (Untitled)

  • userID — varchar(20)
  • city — varchar(20)
  • address — varchar(20)
  • seatNo — varchar(20)
  • redate — varchar(20)
  • retime — varchar(20)

SEATNUM (Untitled2)

  • seatnum — varchar(20) — Primary key — NOT NULL

USER

  • userID — varchar(20) — Primary key — NOT NULL
  • userPassword — varchar(20)
  • userName — varchar(20)
  • userPhone — varchar(20)