test

Tables (3)

history (Untitled3)

  • h_id (pk) — Primary key — NOT NULL
  • u_id (fk) — Foreign key → user.u_id — NOT NULL
  • s_id (fk2) — Foreign key → store.s_id — NOT NULL
  • time (Field3)
  • star_rate (Field4)

store (Untitled2)

  • s_id (pk) — Primary key — NOT NULL
  • name (Field2) — char
  • menu (Field3) — tuple
  • star_rate (Field4) — float
  • location (Field5) — tuple

user (Untitled)

  • u_id (pk) — Primary key — NOT NULL
  • name (Field) — char
  • age (Field2) — int
  • sex (Field3) — bool