고독한 먹짱
테이블 (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