1

Tables (5)

buy_table (Untitled3)

  • buy_no (구매번호) — Primary key — NOT NULL
  • product_no (상품번호) — Foreign key → product_table.product_no — NOT NULL
  • member_no (회원번호) — Foreign key → user_table.member_no — NOT NULL
  • date (구매날짜)
  • quantity (구매수량)
  • seal_service (각인여부)
  • total_price (총구매)
  • method (구매방식)

category_table (Untitled4)

  • category_no (카테고리번호) — Primary key — NOT NULL
  • name (이름)
  • delete (삭제)

image_table (Untitled5)

  • image_no (이미지번호) — Primary key — NOT NULL
  • product_no (상품번호) — Foreign key → product_table.product_no — NOT NULL
  • origin_path (원본이미지)
  • save_path (암호화 이름)
  • save_date (저장날짜)
  • update_date (수정날짜)
  • delete (삭제)

product_table (Untitled2)

  • product_no (상품번호) — Primary key — NOT NULL
  • category_no (카테고리번호) — Foreign key → category_table.category_no — NOT NULL
  • name (상품이름)
  • company (회사명)
  • in_price (입고가)
  • out_price (판매가)
  • sell_count (판매량)
  • quantity (재고)
  • visit (조회수)
  • seal_service (각인서비스)
  • delete (삭제)

user_table (Untitled)

  • member_no (회원번호) — Primary key — NOT NULL
  • id (아이디)
  • password (비밀번호)
  • name (이름)
  • dob (생년월일)
  • gender (성별)
  • address (주소)
  • email (이메일)
  • phone (전화번호)
  • admin (관리자 여부)
  • joinDate (회원가입일)
  • delete (삭제)