shoppingMall

Tables (9)

CART (Untitled8)

  • id (CART_ID) — Long — Primary key — NOT NULL
  • 담은 시간 (cart_date)

CART_ITEM (Untitled9)

  • Id (CART_ITEM_ID) — Long — Primary key — NOT NULL
  • Id (CART_ID) — Long
  • Id (ITEM_ID) — Long
  • 수량 (cart_count)
  • 총 가격 (cart_price)

CATEGORY (Untitled7)

  • Id (CATEGORY_ID) — Long — Primary key — NOT NULL
  • parent (PARENT_ID) — Long
  • 카테고리명 (name)

CATEGORY_ITEM (Untitled6)

  • Id (CATEGORY_ITEM_ID) — Long — Primary key — NOT NULL
  • Id (CATEGORY_ID) — Long — Foreign key → CATEGORY.Id — NOT NULL
  • Id (ITEM_ID) — Long — Foreign key → ITEM.Id — NOT NULL

DELIVERY (Untitled3)

  • Id (DELIVERY_ID) — Long — Primary key — NOT NULL
  • 배송 상태 (STATUS)
  • 도시 (city)
  • 길 (street)
  • 우편번호 (zipcode)

ITEM (Untitled5)

  • Id (ITEM_ID) — Long — Primary key — NOT NULL
  • 상품명 (name) — varchar(100)
  • 가격 (price) — int
  • 재고 (stock_quantity) — int
  • 타입 (DTYPE)
  • 저자 (author)
  • isbn
  • 예술가 (artist)
  • ETC
  • 배우 (actor)
  • 감독 (director)

MEMBER (Untitled)

  • Id (MEMBER_ID) — Long — Primary key — NOT NULL
  • 이름 (username) — VARCHAR(20)
  • 보유금액 (money) — INT
  • 나이 (age) — int
  • 도시 (city) — VARCHAR(30)
  • 길 (street) — VARCHAR(50)
  • 우편번호 (zipcode) — VARCHAR(5)

ORDER (Untitled2)

  • Id (ORDER_ID) — Long — Primary key — NOT NULL
  • 회원 (MEMBER_ID2) — Long — Foreign key → MEMBER.Id — NOT NULL
  • 배송지 (DELIVERY_ID) — Long — Foreign key → DELIVERY.Id — NOT NULL
  • 주문 일 (ORDERDATE)
  • 주문상태 (STATUS)

ORDER_ITEM (Untitled4)

  • Id (ORDER_ITEM_ID) — Long — Primary key — NOT NULL
  • Id (ORDER_ID) — Long — Foreign key → ORDER.Id — NOT NULL
  • Id (ITEM_ID) — Long — Foreign key → ITEM.Id — NOT NULL
  • 주문 가격 (order_price) — int
  • 주문 수량 (count) — int