pocket

Tables (4)

tbl_item (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • price (Field2) — varchar

tbl_order (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • poketId (Key2) — int — Foreign key → tbl_pocket.userId — NOT NULL
  • item (Key3) — int — Foreign key → tbl_item.id — NOT NULL
  • count (Field3) — varchar

tbl_pocket (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key2) — varchar — Foreign key → tbl_user.userId — NOT NULL

tbl_user (Untitled2)

  • userId (Key) — varchar — Primary key — NOT NULL
  • password (Field) — varchar
  • adminCk (Field2) — int