team project

Tables (5)

cart (장바구니)

  • cart_id (장바구니 번호) — number — Primary key — NOT NULL
  • product_id (상품번호) — number — Foreign key → product.product_id — NOT NULL
  • cart_count (장바구니 수량) — number
  • cart_price (장바구니 가격) — number
  • Field

order (주문정보)

  • order_id (주문번호) — number — Primary key — NOT NULL
  • product_id (상품번호) — number — Foreign key → product.product_id — NOT NULL
  • order_count (주문수량) — number
  • order_price (주문가격) — number
  • order_status (주문상태) — varchar2(10

product (상품)

  • product_id (상품번호) — number — Primary key — NOT NULL
  • category_id (카테고리번호) — number — Foreign key → product_category.product_category_id — NOT NULL
  • product_name (상품명) — varchar2(30)
  • product_price (상품가격) — number
  • product_stock (상품재고수량) — number
  • product_regdate (상품등록일) — date
  • product_desc (상품설명) — varchar2(500)
  • product_hits (상품조회수) — number
  • product_option1 (상품옵션1) — varchar2(20)
  • product_option (상품옵션2) — varchar2(20)

product_category (상품 카테고리)

  • product_category_id (상품카테고리번호) — number — Primary key — NOT NULL
  • product_category_name (상품카테고리명) — varchar2(30)

refund (환불)

  • refund_id (환불번호) — number — Primary key — NOT NULL
  • order_id (주문번호) — number — Foreign key → order.order_id — NOT NULL
  • Field