store

Tables (6)

communte (게시판)

  • w_code (글번호) — Primary key — NOT NULL
  • id (회원아이디) — Foreign key → usres.id — NOT NULL
  • w_name (글제목)
  • w_content (글내용)
  • w_date (작성일자)

order (주문)

  • p_code (상품번호) — Foreign key → product.p_code — NOT NULL
  • id (회원아이디) — Foreign key → usres.id — NOT NULL
  • p_code (상품번호2) — Foreign key → product.p_code — NOT NULL
  • id (회원아이디2) — Foreign key → product.id — NOT NULL
  • o_code (주문번호)
  • o_amount (주문수량)
  • o_del (배송지)
  • o_date (주문일자)

packtory (제조업체)

  • p_name (제조업체명) — Primary key — NOT NULL
  • p_code (상품번호) — Foreign key → supply.p_code — NOT NULL
  • p_code (상품번호2) — Foreign key → supply.p_code — NOT NULL
  • id (회원아이디) — Foreign key → supply.id — NOT NULL
  • fonbun (전화번호)
  • address (위치)
  • manager (Field3)

product (상품)

  • p_code (상품번호) — Primary key — NOT NULL
  • p_code (상품번호2) — Foreign key → order.p_code — NOT NULL
  • id (회원아이디) — Foreign key → order.id — NOT NULL
  • p_name (상품명)
  • amount (재고량)
  • price (단가)

supply (공급)

  • p_code (상품번호) — Foreign key → product.p_code — NOT NULL
  • p_code (상품번호2) — Foreign key → product.p_code — NOT NULL
  • id (회원아이디) — Foreign key → product.id — NOT NULL
  • s_date (공급일자)
  • s_amount (공급량)

usres (Untitled)

  • id (회원아이디) — Primary key — NOT NULL
  • pass (비번)
  • name (이름)
  • age (나이)
  • job (직업)
  • vip (등급)
  • Field6 (적립금)