project
Tables (9)
cart (장바구니)
- c_id (장바구니아이디) — integer — Primary key — NOT NULL
cart_order (장바구니_상품)
- co_id (장바구니상품아이디) — integer — Primary key — NOT NULL
- ea (수량) — integer
- price (가격) — price
- p_id (상품아이디2) — int — Foreign key → product.p_id — NOT NULL
- c_id (장바구니아이디) — integer — Foreign key → cart.c_id — NOT NULL
category (카테고리)
- c_id (카테고리아이디) — integer — Primary key — NOT NULL
- c_name (카테고리명) — varchar(20)
- c_type (카테고리타입) — char
member (회원)
- member_id (회원아이디) — integer — Primary key
- id (아이디) — varchar(20)
- password (비밀번호) — varchar(20)
- phone (연락처) — varchar(20)
- adress (주소) — varchar(40)
- birth (생년월일) — varchar(8)
- email (이메일) — varchar(20)
- home_p (집전화) — varchar(20)
order (주문_상품(결제전))
- o_id (주문상품아이디) — integer — Primary key — NOT NULL
- date (주문날짜) — varchar(20)
- total_price (주문금액) — integer
- status (주문상품상태) — varchar(20)
- po_id (주문아이디) — integer — Foreign key → pro_order.po_id — NOT NULL
- p_id (상품아이디2) — int — Foreign key → product.p_id — NOT NULL
pro_order (주문)
- po_id (주문아이디) — integer — Primary key — NOT NULL
- ea (총수량) — integer
- price (총가격) — price
- member_id (회원아이디) — integer — Foreign key → member.member_id
product (상품)
- p_id (상품아이디) — int — Primary key — NOT NULL
- name (이름) — varchar(40)
- price (가격) — integer
- date (제조년월) — varchar(14)
- origin (원산지) — varchar(40)
- manu (제조사) — varchar(40)
- size (사이즈) — varchar(20)
- color (색상) — varchar(20)
- c_id (카테고리아이디) — integer — Foreign key → category.c_id — NOT NULL
review (리뷰)
- r_id (리뷰아이디) — integer — Primary key — NOT NULL
- text (리뷰내용) — varchar(200)
- rating (평점) — integer
statistics (통계)
- s_id (통계아이디) — integer — Primary key — NOT NULL
- Field (판매수량)
- Field (반품수량)