테이블 수정본

테이블 (6)

prod_img

  • ImageNum — Number(20) — 기본 키 — NOT NULL
  • ProdNum — Number(20) — 외래 키 → shop_product.ProdNum — NOT NULL
  • ImageName — varchar2(50)
  • ImageRegId — varchar2(20)

shop_cart

  • CartNum — Number(20) — 기본 키
  • UserId — varchar2(20) — 외래 키 → shop_user.UserId — NOT NULL

shop_cart_item

  • CartNum — Number(20) — 외래 키 → shop_cart.CartNum
  • UserId — varchar2(20) — 외래 키 → shop_cart.UserId — NOT NULL
  • ProdNum — Number(20) — 외래 키 → shop_product.ProdNum — NOT NULL
  • count — Number(5)

shop_order

  • OrderNum — Number(20) — 기본 키 — NOT NULL
  • ProdNum — Number(20) — NOT NULL
  • OrderStatus — varchar2(20)
  • OrderCreateTimestamp — Date
  • OrderUpdateTimestamp — Date
  • OrderCount — Number(5)
  • OrderAddress — varchar2(50)
  • OrderPayType — varchar2(20)
  • OrderUserPhone — varchar2(20)
  • OrderProdImageUrl — varchar2(100)
  • ProdNum (ProdNum2) — Number(20) — 외래 키 → shop_product.ProdNum — NOT NULL
  • UserId — varchar2(20) — 외래 키 → shop_user.UserId — NOT NULL

shop_product

  • ProdNum — Number(20) — 기본 키 — NOT NULL
  • UserId — varchar2(20) — 외래 키 → shop_user.UserId — NOT NULL
  • ProdName — varchar2(20)
  • ProdPrice — Number(20)
  • ProdDescription — varchar2(2000)
  • ProdImageUrl — varchar2(100)
  • ProdSalePrice — Number(20)
  • ProdBrand — varchar2(50)
  • ProdCreateTimestamp — Date
  • ProdUpdateTimestamp — Date
  • ProdDeliveryPrice — Number(20)
  • ProdDeliveryDate — Date

shop_user

  • UserId — varchar2(20) — 기본 키 — NOT NULL
  • UserPwd — varchar2(20)
  • UserName — varchar2(50)
  • UserEmail — varchar2(50)
  • UserPhone — varchar2(20)
  • UserAddress — varchar2(50)
  • UserBirth — Date
  • UserRegDate — Date