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