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