jpashop

Tables (14)

Member (회원)

  • memberid (회원id) — long — Primary key — NOT NULL
  • name (회원명) — String
  • address (도시명) — address
  • order_list (주문리스트) — List<orders>

address (주소)

  • address_id (주소_id) — long — Primary key — NOT NULL
  • memberid (회원id) — long — Foreign key → member2.memberid — NOT NULL
  • address (주소) — address

caregory_item (category_item테이블)

  • category_item_id (카테고리_아이템_id) — long — Primary key — NOT NULL
  • category_id (카테고리id) — long — Foreign key → category.category_id — NOT NULL
  • item_id (아이템id) — long — Foreign key → item.item_id — NOT NULL

category (카테고리)

  • category_id (카테고리id) — long — Primary key — NOT NULL
  • name (카테고리명) — String
  • parent (상위카테고리) — category
  • child (하위카테고리) — category

category (카테고리2)

  • category_id (카테고리id) — long — Primary key — NOT NULL
  • category_name (카테고리명) — String
  • parent (부모카테고리) — List<category>
  • child (자식카테고리) — List<category>

delivery (배송지)

  • delivery_id (배송지id) — long — Primary key — NOT NULL
  • order_id (주문id) — long — Foreign key → orders.order_id — NOT NULL
  • memberid (회원id) — long — Foreign key → orders.memberid — NOT NULL
  • address (배송지) — address
  • status (상태) — boolean

item (상품)

  • item_id (아이템id) — long — Primary key — NOT NULL
  • name (아이템명) — String
  • categories (카테고리들) — List<category>
  • price (가격) — String
  • stockQuantity (재고) — int

member2 (회원2)

  • memberid (회원id) — long — Primary key — NOT NULL
  • id (로그인시id) — String
  • pw (로그인시pw) — String

order (주문테이블)

  • orderid (주문id) — long — Primary key — NOT NULL
  • memberid (회원id) — long — Foreign key → member2.memberid — NOT NULL
  • cancel (주문취소여부) — boolean
  • order_date (주문일) — Date
  • address (배송지) — address

order_item (주문한item)

  • order_item_id (주문item_id) — long — Primary key — NOT NULL
  • order_id (주문id) — long — Foreign key → orders.order_id — NOT NULL
  • memberid (회원id) — long — Foreign key → orders.memberid — NOT NULL
  • item_id (아이템id) — long — Foreign key → item.item_id — NOT NULL
  • count (주문한 item 개수) — int

order_product (주문_상품_테이블)

  • order_product_id (주문_상품_id) — long — Primary key — NOT NULL
  • orderid (주문id) — long — Foreign key → order.orderid — NOT NULL
  • memberid (회원id) — long — Foreign key → order.memberid — NOT NULL
  • productid (상품id) — long — Foreign key → product2.productid — NOT NULL
  • order_count (주문수량) — int

orders (주문)

  • order_id (주문id) — long — Primary key — NOT NULL
  • memberid (회원id) — long — Foreign key → Member.memberid — NOT NULL
  • orderdate (주문일) — Date

product2 (상품2)

  • productid (상품id) — long — Primary key — NOT NULL
  • type (상품종류) — productType
  • stockQuantity (재고) — int
  • price (가격) — String

product_category (상품과 카테고리)

  • product_category_id (상품_카테고리_id) — long — Primary key — NOT NULL
  • productid (상품id) — long — Foreign key → product2.productid — NOT NULL
  • category_id (카테고리id) — long — Foreign key → category.category_id — NOT NULL