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)