rfge
Tables (41)
TB_AD
- AD_UID — NUMBER — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- AD_POS — VARCHAR2(20 CHAR) — NOT NULL
- AD_TITLE — VARCHAR2(50 CHAR) — NOT NULL
- AD_DESC — VARCHAR2(100 CHAR) — NOT NULL
- AD_BUTTON_DESC — VARCHAR2(50 CHAR) — NOT NULL
- IMAGE_URL — VARCHAR2(100 CHAR) — NOT NULL
- TARGET_URL — VARCHAR2(100 CHAR) — NOT NULL
- AD_START_TIME — DATE — NOT NULL
- AD_END_TIME — DATE — NOT NULL
- ADV_BUSINESS_NUMBER — VARCHAR2(30 CHAR) — NOT NULL
- ADV_NAME — VARCHAR2(30 CHAR) — NOT NULL
- ADV_EMAIL — VARCHAR2(30 CHAR) — NOT NULL
- ADV_PHONE — VARCHAR2(30 CHAR) — NOT NULL
- AD_PRICE — NUMBER — NOT NULL
- ACTIVE_STATUS — VARCHAR2(20 CHAR) — NOT NULL
TB_ADMIN
- ADMIN_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- ADMIN_ID — VARCHAR2(30 CHAR) — NOT NULL
- ADMIN_PASS — VARCHAR2(150 CHAR) — NOT NULL
- JOB — VARCHAR2(50 CHAR) — NOT NULL
- PHONE_NUM — VARCHAR2(20 CHAR) — NOT NULL
- EMAIL_ADDR — VARCHAR2(50 CHAR) — NOT NULL
- ADMIN_TYPE — VARCHAR2(100 CHAR) — NOT NULL
- PRIVILEGE_STR — VARCHAR2(100 CHAR) — NOT NULL
- USE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_AD_LOG
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- AD_UID — NUMBER — NOT NULL
- USER_ID — NUMBER — NOT NULL
- USER_IP — VARCHAR2(30 CHAR) — NOT NULL
- DEVICE_OS — VARCHAR2(20 CHAR) — NOT NULL
- DEVICE_MODEL — VARCHAR2(50 CHAR) — NOT NULL
- SHOW_YN — VARCHAR2(1 CHAR) — NOT NULL
- CLICK_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_AD_STATISTICS
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- AD_UID — NUMBER — NOT NULL
- SHOW_DATE_STR — VARCHAR2(20 CHAR) — NOT NULL
- SHOW_CNT — NUMBER — NOT NULL
- CLICK_CNT — NUMBER — NOT NULL
TB_APP_INFO
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- DEVICE_OS — VARCHAR2(20 CHAR) — NOT NULL
- VERSION_NAME — VARCHAR2(30 CHAR) — NOT NULL
- VERSION_CODE — NUMBER — NOT NULL
TB_BLOG
- BLOG_UID — NUMBER — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_RANGE — VARCHAR2(20 CHAR) — NOT NULL
- RANGE_TARGET — VARCHAR2(20 CHAR) — NOT NULL
- BLOG_TITLE — VARCHAR2(100 CHAR) — NOT NULL
- BLOG_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- BLOG_TAGS — VARCHAR2(200 CHAR) — NOT NULL
- IMAGE_YN — VARCHAR2(1 CHAR) — NOT NULL
- VOTE_YN — VARCHAR2(1 CHAR) — NOT NULL
- LIKE_CNT — NUMBER — NOT NULL
- UNLIKE_CNT — NUMBER — NOT NULL
- REPLY_CNT — NUMBER — NOT NULL
- ADMIN_DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
- DEL_REASON — VARCHAR2(100 CHAR)
- ADMIN_ID — VARCHAR2(30 CHAR)
- BLOG_KEY — VARCHAR2(50 CHAR)
TB_BLOG_FILE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- FILE_URL — VARCHAR2(100 CHAR) — NOT NULL
- FILE_TYPE — VARCHAR2(20 CHAR)
- FILE_DESC — VARCHAR2(200 CHAR) — NOT NULL
- FILE_ORDER — NUMBER — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_BLOG_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- BLOG_TITLE — VARCHAR2(100 CHAR) — NOT NULL
- BLOG_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- IMAGE_YN — VARCHAR2(1 CHAR) — NOT NULL
- VOTE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_BLOG_LIKE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- LIKE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_BLOG_READ
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- BLOG_READ_TIME — DATE — NOT NULL
- REPLY_READ_TIME — DATE — NOT NULL
- READ_REPLY_UID — NUMBER — NOT NULL
TB_BOOKMARK
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
TB_CAFE
- CAFE_CODE — VARCHAR2(20 CHAR) — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- CAFE_NAME — VARCHAR2(50 CHAR) — NOT NULL
- CAFE_BADGE — VARCHAR2(20 CHAR) — NOT NULL
- USE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_CAFE_LIKE
- IND — NUMBER — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- CAFE_CODE — VARCHAR2(20 CHAR) — NOT NULL
TB_CAFE_REQUEST
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- CAFE_TITLE — VARCHAR2(50 CHAR) — NOT NULL
- REQ_REASON — VARCHAR2(300 CHAR) — NOT NULL
- PROCESS_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_CHAT
- CHAT_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- SEND_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- USER_ID — NUMBER — NOT NULL
- PEER_USER_ID — NUMBER — NOT NULL
- CONTENTS — VARCHAR2(1000 CHAR) — NOT NULL
- READ_YN — VARCHAR2(1 CHAR) — NOT NULL
- SAVE_YN — VARCHAR2(1 CHAR) — NOT NULL
- READ_TIME — DATE
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_CHECK_CODE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_EMAIL — VARCHAR2(50 CHAR) — NOT NULL
- CHECK_CODE — VARCHAR2(20 CHAR) — NOT NULL
- VALID_TIME — DATE — NOT NULL
- COMPLETE_YN — VARCHAR2(1 CHAR) — NOT NULL
- CHECK_KEY — VARCHAR2(50 CHAR) — NOT NULL
TB_DEPARTMENT
- UNI_CODE — VARCHAR2(20 CHAR) — NOT NULL
- DEPT_CODE — VARCHAR2(20 CHAR) — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- DEPT_NAME — VARCHAR2(50 CHAR) — NOT NULL
- USE_YN — VARCHAR2(1 CHAR) — NOT NULL
- DEPT_BOARD_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_FAQ
- IND — NUMBER — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- FAQ_TITLE — VARCHAR2(100 CHAR) — NOT NULL
- FAQ_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_FEED
- FEED_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- FEED_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- FEED_CONTENTS — VARCHAR2(300 CHAR) — NOT NULL
- TARGET_UID — NUMBER — NOT NULL
- MEMO — VARCHAR2(100 CHAR) — NOT NULL
- READ_YN — VARCHAR2(1 CHAR) — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_INQUIRY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- INQUIRY_TITLE — VARCHAR2(50 CHAR) — NOT NULL
- INQUIRY_CONTENTS — VARCHAR2(300 CHAR) — NOT NULL
- PROCESS_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_KEYWORD_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- USER_KEYWORD — VARCHAR2(50 CHAR) — NOT NULL
TB_MARKET
- MARKET_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- MARKET_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- PRICE — NUMBER — NOT NULL
- TITLE — VARCHAR2(50 CHAR) — NOT NULL
- MARKET_IMAGE — VARCHAR2(100 CHAR) — NOT NULL
- DESC_IMAGE — VARCHAR2(100 CHAR) — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_MARKET_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- MARKET_UID — NUMBER — NOT NULL
- PRICE — NUMBER — NOT NULL
- BUY_CNT — NUMBER — NOT NULL
- USE_POINT — NUMBER — NOT NULL
- PROCESS_YN — VARCHAR2(1 CHAR) — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_NICK_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- USER_NICKNAME — VARCHAR2(20 CHAR) — NOT NULL
TB_NOTICE
- NOTICE_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- NOTICE_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- NOTICE_TITLE — VARCHAR2(100 CHAR) — NOT NULL
- NOTICE_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_POINT_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- EARN_YN — VARCHAR2(1 CHAR) — NOT NULL
- EARN_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- POINT — NUMBER — NOT NULL
- BEFORE_POINT — NUMBER — NOT NULL
- AFTER_POINT — NUMBER — NOT NULL
- MEMO — VARCHAR2(100 CHAR) — NOT NULL
- MEMO_DESC — VARCHAR2(100 CHAR) — NOT NULL
TB_REALTIME_RANKING
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- REALTIME_TIME_STR — VARCHAR2(100 CHAR) — NOT NULL
- REALTIME_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- SHOW_ORDER — VARCHAR2(100 CHAR) — NOT NULL
- READ_CNT — NUMBER — NOT NULL
- LIKE_CNT — NUMBER — NOT NULL
TB_REPLY
- REPLY_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- PARENT_REPLY_UID — NUMBER — NOT NULL
- REPLY_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- IMAGE_YN — VARCHAR2(1 CHAR) — NOT NULL
- LIKE_CNT — NUMBER — NOT NULL
- UNLIKE_CNT — NUMBER — NOT NULL
- CHILD_CNT — NUMBER — NOT NULL
- ADMIN_DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
- DEL_REASON — VARCHAR2(100 CHAR)
- ADMIN_ID — VARCHAR2(30 CHAR)
TB_REPLY_FILE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- REPLY_UID — NUMBER — NOT NULL
- FILE_URL — VARCHAR2(100 CHAR) — NOT NULL
- FILE_TYPE — VARCHAR2(20 CHAR)
- FILE_ORDER — NUMBER — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_REPLY_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- REPLY_UID — NUMBER — NOT NULL
- REPLY_CONTENTS — VARCHAR2(4000 CHAR) — NOT NULL
- IMAGE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_REPLY_LIKE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- REPLY_UID — NUMBER — NOT NULL
- LIKE_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_REPORT_BLOG
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- REPORT_REASON — VARCHAR2(30 CHAR) — NOT NULL
- OTHER_REASON — VARCHAR2(100 CHAR) — NOT NULL
- PROCESS_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_REPORT_REPLY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- REPLY_UID — NUMBER — NOT NULL
- REPORT_REASON — VARCHAR2(100 CHAR) — NOT NULL
- OTHER_REASON — VARCHAR2(100 CHAR) — NOT NULL
- PROCESS_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_TERMS
- TERMS_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- CONTENTS — CLOB — NOT NULL
- MEMO — VARCHAR2(100 CHAR) — NOT NULL
TB_UNIVERSITY
- UNI_CODE — VARCHAR2(20 CHAR) — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- UNI_NAME — VARCHAR2(30 CHAR) — NOT NULL
- UNI_DOMAIN — VARCHAR2(30 CHAR) — NOT NULL
- UNI_TYPE — VARCHAR2(20 CHAR) — NOT NULL
- UNI_HOMEPAGE — VARCHAR2(100 CHAR)
- UNI_EMAIL — VARCHAR2(50 CHAR)
- UNI_COUNTRY — VARCHAR2(50 CHAR)
- UNI_LOCATION — VARCHAR2(50 CHAR)
- USE_YN — VARCHAR2(1 CHAR) — NOT NULL
- UNI_BOARD_YN — VARCHAR2(1 CHAR) — NOT NULL
- UNI_IMAGE — VARCHAR2(255 BYTE)
TB_USER
- USER_ID — NUMBER — Primary key — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_STATUS — VARCHAR2(1 CHAR) — NOT NULL
- UNI_CODE — VARCHAR2(20 CHAR) — NOT NULL
- DEPT_CODE — VARCHAR2(20 CHAR) — NOT NULL
- USER_EMAIL — VARCHAR2(50 CHAR) — NOT NULL
- USER_NICKNAME — VARCHAR2(30 CHAR) — NOT NULL
- USER_PASSWORD — VARCHAR2(30 CHAR) — NOT NULL
- POINT — NUMBER — NOT NULL
- USER_OS — VARCHAR2(10 CHAR)
- NOTICE_READ_TIME — DATE — NOT NULL
- DEV_TOKEN — VARCHAR2(255 CHAR)
- ACCESS_TOKEN — VARCHAR2(50 CHAR)
- PUSH_YN — VARCHAR2(1 BYTE) — NOT NULL
- PAUSE_DATE — DATE — NOT NULL
TB_USER_BLOCK
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- PEER_USER_ID — NUMBER — NOT NULL
TB_USER_LEAVE
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_EMAIL — VARCHAR2(50 CHAR) — NOT NULL
TB_USER_LOGIN_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- DEVICE_OS — VARCHAR2(20 CHAR) — NOT NULL
- DEVICE_MODEL — VARCHAR2(50 CHAR) — NOT NULL
- USER_IP — VARCHAR2(30 CHAR) — NOT NULL
TB_VOTE
- VOTE_UID — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- EDT_DATE — DATE — NOT NULL
- BLOG_UID — NUMBER — NOT NULL
- MULTI_YN — VARCHAR2(1 CHAR) — NOT NULL
- PUBLIC_YN — VARCHAR2(1 CHAR) — NOT NULL
- VOTE_TITLE — VARCHAR2(50 CHAR) — NOT NULL
- VOTE_CONTENTS — VARCHAR2(200 CHAR) — NOT NULL
- VOTE1_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE2_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE3_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE4_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE5_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE6_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE7_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE8_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE9_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE10_LABEL — VARCHAR2(100 CHAR) — NOT NULL
- VOTE1_SUM — NUMBER — NOT NULL
- VOTE2_SUM — NUMBER — NOT NULL
- VOTE3_SUM — NUMBER — NOT NULL
- VOTE4_SUM — NUMBER — NOT NULL
- VOTE5_SUM — NUMBER — NOT NULL
- VOTE6_SUM — NUMBER — NOT NULL
- VOTE7_SUM — NUMBER — NOT NULL
- VOTE8_SUM — NUMBER — NOT NULL
- VOTE9_SUM — NUMBER — NOT NULL
- VOTE10_SUM — NUMBER — NOT NULL
- DEL_YN — VARCHAR2(1 CHAR) — NOT NULL
TB_VOTE_HISTORY
- IND — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- USER_ID — NUMBER — NOT NULL
- VOTE_UID — NUMBER — NOT NULL
- VOTE_NUM — NUMBER — NOT NULL