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