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