pineapple

Tables (3)

basket

  • id (Key) — long — Primary key — NOT NULL
  • id (Key2) — long — Foreign key → member.id — NOT NULL
  • product_classification (Field) — string
  • productName (Field2) — string
  • cost (Field3) — int
  • image (Field4) — string
  • count (Field5) — int

member

  • id (Key) — long — Primary key — NOT NULL
  • memeberName (Field) — string
  • password (Field2) — string
  • Field3

product

  • id (Key) — long — Primary key — NOT NULL
  • product_classification (Field) — string
  • productName (Field2) — string
  • cost (Field3) — int
  • image (Field4) — string
  • count (Field5) — int