News_Project

Tables (4)

ARTICLE (Untitled3)

  • ARTICLE_ID — INTEGER — Primary key — NOT NULL
  • ARTICLE_THEME — VARCHAR(45)
  • ARTICLE_TITLE — VARCHAR(45)
  • ARTICLE_CONTENT — VARCHAR(255)
  • ARTICLE_IMAGE — VARCHAR(255)
  • ARTICLE_CRAWLED_TIME — DATE
  • ARTICLE_MODIFIED_TIME — DATE
  • ARTICLE_WRITTEN_TIME — DATE
  • ARTICLE_KEYWORD — VARCHAR(45)

COMMENT (Untitled2)

  • COMMENT_ID — INTEGER — Primary key — NOT NULL
  • ARTICLE_ID — INTEGER — Foreign key → ARTICLE.ARTICLE_ID — NOT NULL
  • WRITER_ID — INTEGER
  • WRITER_NAME — VARCHAR(45)
  • COMMENT_CONTENT — VARCHAR(255)
  • COMMENT_WRITTEN_TIME — DATE

KEYWORD (Untitled4)

  • KEYWORD_CRAWLED_TIME — DATE — Primary key — NOT NULL
  • KEYWORD1 — VARCHAR(45)
  • KEYWORD2 — VARCHAR(45)
  • KEYWORD3 — VARCHAR(45)

MEMBER (Untitled)

  • MEMBER_ID — INTEGER — Primary key — NOT NULL
  • MEMBER_NAME — VARCHAR(45)
  • MEMBER_PASSWORD — VARCHAR(45)