shoppingmall
Tables (16)
Cart (장바구니)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- Key (Key3) — Foreign key → Item.Key — NOT NULL
- created_at (Field)
Category (Untitled5)
- Key2 — Primary key — NOT NULL
- categoryName (Field)
Coupon (Untitled9)
- Key — Primary key — NOT NULL
- name (Field)
- end_time (Field2)
Credentials (Untitled4)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- IdentityProvider (Field)
- password (Field2)
Delivery (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- Key (Key3) — Foreign key → Item.Key — NOT NULL
- created_at (Field)
Item (상품)
- Key — Primary key — NOT NULL
- name (Field)
- price (Field2)
- size (Field3)
- information (Field4)
- color (Field5)
- created_at (Field6)
- shippingPrice (Field7)
- salePrice (Field8)
ItemCategory (Untitled12)
- Key — Primary key — NOT NULL
- Key2 — Foreign key → Category.Key2 — NOT NULL
- Key (Key3) — Foreign key → Item.Key — NOT NULL
ItemPicture (Untitled11)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Item.Key — NOT NULL
- url (Field)
Like (Untitled)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- Key (Key3) — Foreign key → Item.Key — NOT NULL
Payment (Untitled2)
- Key — Primary key — NOT NULL
QnA (Untitled6)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Item.Key — NOT NULL
- Key (Key3) — Foreign key → member.Key — NOT NULL
- question (Field)
- created_at (Field2)
- answer (Field3)
Review (Untitled7)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Item.Key — NOT NULL
- Key (Key3) — Foreign key → member.Key — NOT NULL
- content (Field)
- created_at (Field2)
ReviewComment (Untitled8)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Review.Key — NOT NULL
- content (Field)
- created_at (Field2)
ReviewPicture (Untitled13)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Review.Key — NOT NULL
- url (Field)
member (멤버)
- Key — Primary key — NOT NULL
- nickname (Field)
- email (Field2)
- phoneNumber (Field4)
- role (Field3)
- createdAt (Field5)
- point (Field6)
member_coupon (Untitled10)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- Key (Key3) — Foreign key → Coupon.Key — NOT NULL
- created_at (Field)