qwe

Tables (3)

Member (Untitled2)

  • memberNo (Key) — Int — Primary key — NOT NULL
  • memberId (Field) — varchar
  • memberPwd (Field2) — varchar
  • memberName (Field3) — varchar
  • memberPhone (Field4) — varchar
  • memberStatus (Field5) — varchar"
  • Field6

Order (Untitled)

  • orederNo (Key) — Int — Primary key — NOT NULL
  • memberNo (Key2) — Int — Foreign key → Member.memberNo — NOT NULL
  • productNo (Key3) — Int — Foreign key → Product.productNo — NOT NULL
  • orderDate (Field2) — varchar
  • orderStatus (Field4) — Int

Product (Untitled3)

  • productNo (Key) — Int — Primary key — NOT NULL
  • productName (Field) — varchar
  • productPrice (Field2) — Int