1

Tables (10)

TB_CHALLENGE

  • CHALLENGE_ID — NUMBER(10)
  • CHALLENGE_NAME — VARCHAR2(100) — NOT NULL
  • DESCRIPTION — VARCHAR2(500)
  • TARGET_TYPE — VARCHAR2(20) — NOT NULL — COOK/VISIT/SUBMIT
  • TARGET_VALUE — NUMBER(10) — NOT NULL
  • BADGE_IMG — VARCHAR2(255)

TB_CHAT_LOG

  • LOG_ID — NUMBER(10)
  • USER_ID — NUMBER(10) — NOT NULL
  • MESSAGE — VARCHAR2(1000)
  • RESPONSE — VARCHAR2(1000)
  • REC_RECIPE — VARCHAR2(500)
  • CRT_DT — DATE — NOT NULL

TB_COOK_HIS

  • HIS_ID — NUMBER(10)
  • USER_ID — NUMBER(10) — NOT NULL
  • RECIPE_ID — NUMBER(10) — NOT NULL
  • RATING — NUMBER(1)
  • REVIEW — VARCHAR2(500)
  • DIFF_RATING — VARCHAR2(10)
  • COOK_DT — DATE — NOT NULL
  • CRT_DT — DATE — NOT NULL

TB_COOK_HIS_ING

  • HIS_ID — NUMBER(10) — Primary key — NOT NULL
  • ING_ID — NUMBER(10) — Primary key — NOT NULL
  • USED_QTY — NUMBER(7,2)
  • UNIT — VARCHAR2(20)

TB_CRAWL_SOURCE

  • SOURCE_ID — NUMBER(10)
  • DOMAIN — VARCHAR2(100) — NOT NULL
  • LAST_CRAWLED — DATE

TB_RECIPE

  • RECIPE_ID — NUMBER(10)
  • TITLE — VARCHAR2(200) — NOT NULL
  • TITLE_INITIAL — VARCHAR2(20)
  • DESCRIPTION — VARCHAR2(1000)
  • COOK_TIME — NUMBER(4)
  • DIFFICULTY — VARCHAR2(10)
  • SERVINGS — NUMBER(2)
  • CALORIE — NUMBER(5)
  • MAIN_IMG — VARCHAR2(255)
  • RATING_AVG — NUMBER(3,2)
  • VIEW_CNT — NUMBER(8)
  • CRT_DT — DATE — NOT NULL

TB_STEP_COMMENT

  • undefined_ID — NUMBER(10) — NOT NULL
  • USER_ID — NUMBER(10) — NOT NULL
  • CONTENT — VARCHAR2(1000) — NOT NULL
  • CRT_DT — DATE — NOT NULL

TB_USER

  • USER_ID — NUMBER(10)
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PW — VARCHAR2(255)
  • USER_NAME — VARCHAR2(50) — NOT NULL
  • AGE — NUMBER(3)
  • GENDER — CHAR(1)
  • PROFILE_IMG — VARCHAR2(255)
  • AUTH_TYPE — VARCHAR2(20) — NOT NULL
  • USER_STATUS — CHAR(1) — NOT NULL
  • TOTAL_VISITS — NUMBER(10)
  • TOTAL_COOKED — NUMBER(10) — 요리
  • TOTAL_SUBMIT — NUMBER(10) — 레시피
  • CRT_DT — DATE — NOT NULL
  • UDT_DT — DATE — NOT NULL

TB_USER_ALLERGY

  • USER_ID — NUMBER(10) — Primary key — NOT NULL
  • ING_ID — NUMBER(10) — Primary key — NOT NULL
  • SEVERITY — NUMBER(1) — 1:경증

TB_USER_FAV

  • USER_ID — NUMBER(10) — Primary key — NOT NULL
  • CRT_DT — DATE — NOT NULL