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)