recifit
Tables (5)
rf_comment (CopyOfCopyOfUntitled)
- 코멘트번호 (comment_num) — NUMBER — Primary key — NOT NULL — sequence
- 레시피번호 (recipe_num) — NUMBER — Foreign key → rf_recipe.레시피번호 — NOT NULL — sequence
- 코멘트내용 (comment_text) — VARCHAR2(255) — NOT NULL
- 코멘트작성날짜 (comment_date) — DATE — NOT NULL
- 코멘트갯수 (comment_sum) — NUMBER — NOT NULL
- 로그인ID (user_id) — VARCHAR2(20) — Foreign key → rf_user.아이디 — NOT NULL
rf_recipe (CopyOfUntitled)
- 레시피번호 (recipe_num) — NUMBER — Primary key — NOT NULL — sequence
- 레시피이름 (recipe_name) — VARCHAR2(255) — NOT NULL
- 레시피사진 (recipe_originalfile) — VARCHAR2(255) — NOT NULL
- 레시피사진저장 (recipe_savedfile) — VARCHAR2(255) — NOT NULL
- 레시피재료 (recipe_ need) — VARCHAR2(255) — NOT NULL
- 레시피설명 (recipe_howto) — VARCHAR2(2000) — NOT NULL
- 레시피분류 (recipe_type) — VARCHAR2(50) — NOT NULL
- 레시피날짜 (recipe_date) — DATE — NOT NULL
- 레시피특징 (recipe_icon) — VARCHAR2(20) — NOT NULL
- 레시피조회수 (recipe_hit) — NUMBER — NOT NULL
- 로그인ID (user_ id) — VARCHAR2(20) — Foreign key → rf_user.enabled — NOT NULL
rf_refrigerator (CopyOfCopyOfUntitled2)
- 냉장고번호 (refrigerator_num) — NUMBER — Primary key — NOT NULL — sequence
- 로그인ID (user_id) — VARCHAR2(20) — Foreign key → rf_user.아이디 — NOT NULL
- 냉장고재료 (refrigerator_need) — VARCHAR2(255) — NOT NULL
- 유통기한 (refrigerator_date) — DATE — NOT NULL
rf_user (Untitled)
- 아이디 (user_id) — VARCHAR2(20) — Primary key — NOT NULL
- 비밀번호 (user_ pw) — VARCHAR2(100) — NOT NULL
- 이름 (user_ name) — VARCHAR2(20) — NOT NULL
- 전화번호 (user_ phone) — VARCHAR2(20) — NOT NULL
- 이메일 (user_email) — VARCHAR2(50) — NOT NULL
- 권한 (user_role) — VARCHAR2(20) — NOT NULL
- (enabled) — NUMBER(1) — NOT NULL
rf_zzim (CopyOfUntitled2)
- 찜번호 (zzim_num) — NUMBER — Primary key — NOT NULL — sequence
- 레시피번호 (recipe_num2) — NUMBER — Foreign key → rf_recipe.레시피번호 — NOT NULL — sequence
- 찜날짜 (zzim_date) — DATE — NOT NULL
- 로그인ID (user_id) — VARCHAR2(20) — Foreign key → rf_user.아이디 — NOT NULL
- 찜레시피이름 (zzim_name) — VARCHAR2(255) — NOT NULL
- 찜사진 (zzim_originalfile) — VARCHAR2(255) — NOT NULL
- 찜저장사진 (zzim_savedfile) — VARCHAR2(255) — NOT NULL
- 찜재료 (zzim_need) — VARCHAR2(255) — NOT NULL
- 찜설명 (zzim_howto) — VARCHAR2(2000) — NOT NULL
- 찜분류 (zzim_type) — VARCHAR2(50) — NOT NULL
- 찜특징 (zzim_icon) — VARCHAR2(20) — NOT NULL