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