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)