newssss

Tables (29)

BOOKMARK

  • ID — NUMBER — Primary key — NOT NULL
  • BOOKMARK_TYPE — VARCHAR2(100) — NOT NULL
  • PUBLISHED_TIME — TIMESTAMP — NOT NULL
  • FOLDER_ID — NUMBER — NOT NULL

CATEGORY

  • ID — NUMBER — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR2(100) — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL

CONTENT_BOOKMARK

  • ID — NUMBER — Primary key — NOT NULL
  • NEWS_TEXT_ID — NUMBER — NOT NULL

EMOJI

  • ID — NUMBER — Primary key — NOT NULL
  • UNICODE — VARCHAR2(100) — NOT NULL
  • EMOJI_CONTENT — VARCHAR2(100) — NOT NULL

EMOTION

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • EMOTION_TYPE — VARCHAR2(100) — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL

FOLDER

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • FOLDER_NAME — VARCHAR2(100) — NOT NULL
  • FOLDER_ORDER — NUMBER — NOT NULL
  • IS_DEFAULT_FOLDER — CHAR(1) — NOT NULL

JOURNAL

  • ID — NUMBER — Primary key — NOT NULL
  • JOURNAL_NAME — VARCHAR2(100) — NOT NULL
  • NEWS_LOGO_THUMBNAIL_PATH — VARCHAR2(100) — NOT NULL
  • SHORTS_LOGO_THUMBNAIL_PATH — VARCHAR2(100) — NOT NULL

KEYWORD

  • ID — NUMBER — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(100) — NOT NULL

MEMBER

  • ID — NUMBER — Primary key — NOT NULL
  • PERSONA_ID — VARCHAR2(100) — NOT NULL
  • NICKNAME — VARCHAR2(100) — NOT NULL
  • CustomerAge — NUMBER — NOT NULL
  • LAST_READ_BRIEFING_TIME — TIMESTAMP — NOT NULL
  • CATEGORY_VECTOR — VARCHAR2(100) — NOT NULL

MEMBER_CATEGORY

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • CATEGORY_ORDER — NUMBER — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL

MEMBER_KEYWORD

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • KEYWORD — VARCHAR2(100) — NOT NULL
  • KEYWORD_ORDER — NUMBER — NOT NULL
  • UPDATED_TIME — TIMESTAMP — NOT NULL

NEWS

  • ID — NUMBER — Primary key — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • NEWS_TITLE — VARCHAR2(100) — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL
  • MODIFIED_TIME — TIMESTAMP — NOT NULL
  • SUMMARY — VARCHAR2(100) — NOT NULL
  • NEWS_URL — VARCHAR2(100) — NOT NULL
  • NEWS_THUMBNAIL_PATH — VARCHAR2(100) — NOT NULL
  • JOURNAL_ID — NUMBER — NOT NULL

NEWS_BOOKMARK

  • ID — NUMBER — Primary key — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL

NEWS_COMMENT

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • NEWS_COMMENT_POSITION — NUMBER — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL
  • IS_DELETED — CHAR(1) — NOT NULL
  • NEWS_COMMENT_CONTENT — VARCHAR2(100) — NOT NULL
  • MENTION_MEMBER_ID — NUMBER — NOT NULL
  • NEWS_COMMENT_ID — NUMBER — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL

NEWS_CONTENT

  • ID — NUMBER — Primary key — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL
  • NEWS_SEQUENCE — NUMBER — NOT NULL
  • NEWS_CONTENT_TYPE — VARCHAR2(100) — NOT NULL

NEWS_IMAGE

  • ID — NUMBER — Primary key — NOT NULL
  • IMAGE_PATH — VARCHAR2(100) — NOT NULL

NEWS_KEYWORD

  • ID — NUMBER — Primary key — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL
  • EMPTY_COLUMN — VARCHAR2(100) — NOT NULL
  • KEYWORD_ID — NUMBER — NOT NULL

NEWS_TEXT

  • ID — NUMBER — Primary key — NOT NULL
  • TEXT_CONTENT — BLOB — NOT NULL

NEWS_VIDEO

  • ID — NUMBER — Primary key — NOT NULL
  • VIDEO_PATH — VARCHAR2(100) — NOT NULL
  • VIDEO_THUMBNAIL_PATH — VARCHAR2(100) — NOT NULL
  • DOWNLOAD_COMPLETE — CHAR(1) — NOT NULL

NEWS_WRITER

  • ID — NUMBER — Primary key — NOT NULL
  • WRITER_ID — NUMBER — NOT NULL
  • EMPTY_COLUMN — VARCHAR2(100) — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL

SEARCH_LOG

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • QUERY — VARCHAR2(100) — NOT NULL
  • SEARCH_TIME — TIMESTAMP — NOT NULL

SHORTS

  • ID — NUMBER — Primary key — NOT NULL
  • JOURNAL_ID — NUMBER — NOT NULL
  • SHORTS_VIDEO_PATH — VARCHAR2(100) — NOT NULL
  • SHORTS_TITLE — VARCHAR2(100) — NOT NULL
  • SHORTS_THUMBNAIL_PATH — VARCHAR2(100) — NOT NULL
  • SHORTS_URL — VARCHAR2(100) — NOT NULL
  • SHORTS_CONTENT — BLOB — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL

SHORTS_BOOKMARK

  • ID — NUMBER — Primary key — NOT NULL
  • SHORTS_ID — NUMBER — NOT NULL

SHORTS_COMMENT

  • ID — NUMBER — Primary key — NOT NULL
  • SHORTS_COMMENT_POSITION — NUMBER — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL
  • IS_DELETED — CHAR(1) — NOT NULL
  • SHORTS_COMMENT_CONTENT — VARCHAR2(100) — NOT NULL
  • MENTION_MEMBER_ID — NUMBER — NOT NULL
  • SHORTS_COMMENT_ID — NUMBER — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • SHORTS_ID — NUMBER — NOT NULL

SHORTS_LOG

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • SHORTS_ID — NUMBER — NOT NULL
  • VIEW_TIME — TIMESTAMP — NOT NULL

SUBSCRIBE

  • ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL
  • JOURNAL_ID — NUMBER — NOT NULL
  • EMPTY_COLUMN — VARCHAR2(100) — NOT NULL
  • JOURNAL_ID — NUMBER — NOT NULL
  • MEMBER_ID — NUMBER — NOT NULL

SUMMARY_EMOJI

  • ID — NUMBER — Primary key — NOT NULL
  • NEWS_ID — NUMBER — NOT NULL
  • EMOJI_ID — NUMBER — NOT NULL
  • EMPTY_COLUMN — VARCHAR2(100) — NOT NULL

TRENDING_STATISTICS

  • ID — NUMBER — Primary key — NOT NULL
  • MODIFIED_TIME — TIMESTAMP — NOT NULL
  • KEYWORD — VARCHAR2(100) — NOT NULL
  • PUBLISH_COUNT — NUMBER — NOT NULL
  • SEARCH_COUNT — NUMBER — NOT NULL

WRITER

  • ID — NUMBER — Primary key — NOT NULL
  • WRITER_NAME — VARCHAR2(100) — NOT NULL
  • WRITER_EMAIL — VARCHAR2(100) — NOT NULL
  • JOURNAL_ID — NUMBER — NOT NULL