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