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