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 (적립금)