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