고독한 먹짱

테이블 (4)

product (상품)

  • Field (num) — NUMBER — 기본 키
  • 카테고리명 (category_name) — VARCHAR2(20)
  • 제철음식 (is_seasonfood) — CHAR(1)
  • 제철음식(월) (seasonfood_month) — CHAR(2)
  • 간편식 (is_HMR) — CHAR(1)
  • Field (is_shoping) — CHAR(1)
  • 상품명 (product_name) — VARCHAR2(20)
  • Field (storage_method) — VARCHAR2(50)
  • Field (prepare_ingredients) — VARCHAR2(50)
  • Field (efficacy) — VARCHAR2(50)
  • Field (product_pic) — BLOB
  • Field (num2) — NUMBER — 외래 키 → product.Field

recipe (베스트)

  • (numbering) — INT(12)
  • 레시피명 (recipe_name) — VARCHAR2(20)
  • 레시피사진 (recipe_pic) — BLOB
  • 레시피주소 (recipe_url) — VARCHAR2(100)

shopping (알뜰쇼핑)

  • (numbering) — INT(12)
  • 상품주소 (product_url) — VARCHAR2(100)
  • 상품쇼핑명 (product_shopping_name) — VARCHAR2(20)
  • 가격 (price) — INT(12)
  • 할인가 (discountPrice) — INT(12)
  • 할인률 (dc_percent) — DEC(5,2)
  • 리뷰 (review) — VARCHAR2(200)

tip (tip 게시판)

  • (numbering) — INT(12)
  • 블로그 제목 (blog_title) — VARCHAR2(20)
  • 블로그주소 (blog_url) — VARCHAR2(100)
  • 블로그요약 (blog_summary) — VARCHAR2(50)
  • 블로그게시일 (blog_post_date) — DATETIME