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_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