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