11

Tables (12)

TB_Ingredient

  • Ingredient_no — number — Primary key — NOT NULL
  • ing_pr_category — varchar2(20) — NOT NULL
  • ing_cd_category — varchar2(20) — NOT NULL
  • Ingredient_name — varchar2(30) — NOT NULL
  • eng_pr_category — varchar2(50)
  • eng_cd_category — varchar2(50)
  • ing_filename — varchar2(50) — NOT NULL

TB_member

  • CREATE — TABLE

TB_menu_category

  • menu_pr_category — varchar2(20) — NOT NULL
  • menu_cd_category — varchar2(20) — NOT NULL

TB_onedayclass

  • onedayclass_no — number — Primary key — NOT NULL
  • member_id — varchar2(40) — NOT NULL
  • oneday_name — varchar2(100) — NOT NULL
  • oneday_price — number — NOT NULL
  • oneday_content — varchar2(2000) — NOT NULL
  • Latitude — number
  • longitude — number
  • detailed_addr — varchar2(100) — NOT NULL
  • oneday_time — number — NOT NULL
  • oneday_maxper — number — NOT NULL
  • oneday_minper — number — NOT NULL
  • oneday_img — varchar2(50)
  • menu_list — varchar2(100) — NOT NULL

TB_recipe

  • recipe_no — number — Primary key — NOT NULL
  • video_title — varchar2(60) — NOT NULL
  • video_link — varchar2(30) — NOT NULL
  • timeline — varchar2(4000)
  • menu_name — varchar2(100) — NOT NULL
  • chef_nick — varchar2(30) — NOT NULL
  • chef_id — varchar2(30) — NOT NULL
  • cooking_time — number — NOT NULL
  • category — varchar2(20) — NOT NULL
  • recipe_content — long — NOT NULL
  • view_count — number — NOT NULL
  • regdate — date — NOT NULL

TB_report

  • member_id — varchar2(40) — NOT NULL
  • reply_no — number — NOT NULL
  • report_date — date — NOT NULL
  • report_Reason — varchar2(100) — NOT NULL

Tb_rec_ingredients

  • recipe_no — number — NOT NULL
  • Ingredient_no — number
  • min_weight — varchar2(50) — NOT NULL
  • ingredient_name — varchar2(100) — NOT NULL

tb_Ingredient_mall

  • Ingredient_no — number — NOT NULL
  • price — number — NOT NULL
  • stock — number — NOT NULL
  • min_unit — varchar2(50) — NOT NULL
  • ing_origin — varchar2(30) — NOT NULL
  • Shelf_life — number — NOT NULL
  • ing_info — varchar2(50) — NOT NULL

tb_buy_list

  • buy_no — number — Primary key — NOT NULL
  • member_id — varchar2(40) — NOT NULL
  • total_price — number — NOT NULL
  • regdate — date — NOT NULL
  • buy_status — varchar2(30) — NOT NULL

tb_oneday_cancel

  • reservation_no — number — NOT NULL
  • onedayTime_no — number — NOT NULL
  • onedayClass_no — number — NOT NULL
  • cancel_reason — varchar2(100) — NOT NULL

tb_onedayclasstime

  • onedayTime_no — number — Primary key — NOT NULL
  • onedayClass_no — number — NOT NULL
  • onedaytime_date — date — NOT NULL

tb_reservation

  • reservation_no — number — Primary key — NOT NULL
  • member_id — varchar2(40) — NOT NULL
  • onedayTime_no — number — NOT NULL
  • onedayClass_no — number — NOT NULL
  • regdate — date — NOT NULL
  • personnel — number — NOT NULL
  • cancel_check — char(1) — NOT NULL