polewearShop

Tables (3)

member (.)

  • id (Key) — N — Primary key — NOT NULL
  • loginId (Key2) — N — Primary key — NOT NULL
  • loginId (Field2) — N
  • password (Field3) — N
  • name (Field4) — N
  • phoneNumber (Field5) — N
  • email (Field6) — N
  • address (Field7) — Y
  • sex (Field8) — N
  • birth (Field9) — N
  • mileage (Field10) — N
  • createdAt (Field11) — Y
  • updatedAt (Field12) — Y

nonMember (Untitled)

  • id (Key) — N — Primary key — NOT NULL
  • name (Field) — N
  • orderNumber (Field2) — N
  • phoneNumber (Field3) — N
  • email (Field4) — N
  • basketNumber (Field5) — N
  • createdAt (Field6) — Y
  • updatedAt (Field7) — Y

order (Untitled2)

  • id (Key) — N — Primary key — NOT NULL
  • type (Field) — N
  • orderUserId (Field2) — N
  • deliveryFee (Field3) — N
  • deliveredAddress (Field4) — N
  • deliveredPhoneNumber (Field5) — N
  • deliveredComment (Field6) — Y
  • deliveredName (Field7) — N
  • createdAt (Field8) — Y
  • id (Key2) — N — Foreign key → member.id — NOT NULL
  • loginId (Key22) — N — Foreign key → member.loginId — NOT NULL