recipick

Tables (11)

COMMENTS

  • comment_id — number(5) — Primary key — NOT NULL
  • uname — varchar2(20) — NOT NULL
  • review_id — number(5) — NOT NULL
  • recipe_id — number(5) — NOT NULL
  • comment_text — varchar2(1000)
  • parentcomment_id — number(5)

DETAILRECIPE

  • detailrecipe_ID — number(5) — Primary key — NOT NULL
  • recipe_id — number(5) — NOT NULL
  • detail_pic — varchar2(100)
  • detail_text — varchar2(4000)
  • make_order — number(5)

FOOD

  • food_id — number(5) — Primary key — NOT NULL
  • recipe_id — number(5) — NOT NULL
  • food_name — varchar2(60)
  • food_value — varchar2(20)

GGIM

  • ggim_id — number(5) — Primary key — NOT NULL
  • uname — varchar2(20) — NOT NULL
  • recipe_id — number(5) — NOT NULL

HASHTAG

  • hash_id — number(5) — Primary key — NOT NULL
  • review_id — number(5)
  • recipe_id — number(5) — NOT NULL
  • hash_name — varchar2(20)
  • tag_type — varchar2(20)

MAINIMG

  • top_img_id — number(5) — Primary key — NOT NULL
  • main_id — number(5) — NOT NULL
  • top_img — varchar2(100)
  • bottom_img — varchar2(100)

MAINPAGE

  • main_id — number(5) — Primary key — NOT NULL
  • recipe_id — number(5) — NOT NULL
  • top_img — varchar2(100)
  • favor_img — varchar2(100)
  • recom_img — varchar2(100)

MEMBER

  • uname — varchar2(20) — Primary key — NOT NULL
  • rname — varchar2(20)
  • email — varchar2(20)
  • pw — varchar2(20)
  • birth — date
  • phone — varchar2(20)
  • gender — varchar2(20)
  • guest — varchar2(10)

RECIPE

  • recipe_id — number(5) — Primary key — NOT NULL
  • recipe_date — date
  • mainpic — varchar2(100)
  • maintext — varchar2(4000)
  • viewer — varchar2(20)
  • uname — varchar2(20) — NOT NULL
  • recipe_title — varchar2(300)

RECOMMEND

  • recom_id — number(5) — Primary key — NOT NULL
  • uname — varchar2(20) — NOT NULL
  • recipe_id — number(5) — NOT NULL

REVIEW

  • review_id — number(5) — Primary key — NOT NULL
  • pic — varchar2(100)
  • review_text — varchar2(4000)
  • review_date — date
  • viewer — number(5)
  • uname — varchar2(20) — NOT NULL
  • review_title — varchar2(300)