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 (반품수량)