erd

Tables (6)

board (게시판)

  • b_id (글번호) — NUMBER — Primary key — NOT NULL
  • u_id (회원아이디) — VARCHAR2 — Foreign key → member.u_id — NOT NULL
  • b_title (글제목) — VARCHAR2
  • b_content (글내용) — VARCHAR2
  • b_date (작성일자) — DATE

member (회원정보)

  • u_id (회원아이디) — VARCHAR2 — Primary key — NOT NULL
  • u_pw (회원비밀번호) — VARCHAR2
  • u_name (회원명) — VARCHAR2
  • u_email (회원이메일) — VARCHAR2
  • u_post (회원우편번호) — VARCHAR2
  • u_addr (회원주소) — VARCHAR2
  • u_phone (회원전화번호) — VARCHAR2

orderList (장바구니)

  • o_id (주문번호) — VARCHAR2 — Primary key — NOT NULL
  • u_id (회원아이디) — VARCHAR2 — Foreign key → member.u_id — NOT NULL
  • p_id (상품번호) — VARCHAR2 — Foreign key → product.p_id — NOT NULL
  • o_amount (주문수량) — NUMBER
  • o_addr (배송지) — VARCHAR2
  • o_date (주문일자정보) — DATE

product (상품정보)

  • p_id (상품번호) — VARCHAR2 — Primary key — NOT NULL
  • p_name (상품이름) — VARCHAR2
  • p_content (상품내용) — VARCHAR2
  • p_image (상품이미지) — BLOB
  • p_type (상품종류) — VARCHAR2

productStatus (상품기타정보)

  • p_id (상품번호) — VARCHAR2 — Foreign key → product.p_id — NOT NULL
  • p_status (상품삭제여부) — VARCHAR2
  • p_best (베스트상품여부) — VARCHAR2
  • p_date (상품등록일정보) — DATE

product_price (상품가격정보)

  • p_id (상품번호) — VARCHAR2 — Foreign key → product.p_id — NOT NULL
  • p_price (판매가) — NUMBER
  • p_cost (원가) — NUMBER
  • p_margin (수익) — NUMBER