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